Browse Live Discover and Response Queries by Category
Approved

This query is one you are recommended to read the full content of the post to use. It is not simply a copy and paste query, like others in the forum. It is valuable in the right situation 

Live discover: How to check Windows updates Available or not installed

Hi friends,

I've been trying create a query about how display all patches or windows updates available from a server. I tried this, but doesn't work:

SELECT
meta_hostname AS ep_name,
hotfix_id,
caption,
description,
FROM xdr_data
WHERE query_name = 'windows_updates_patch'

Any idea?''

Thank you

Team Management Infrastructure Clients
Parents

  • I have an update on this that may help you on this, But this is only a Live discover query at the moment.

    The below query lists the updates available and returns the status if they are installed and mandatory or not.

    SELECT
    title,
    support_url,
    msrc_severity,
    installed,
    mandatory,
    size,
    kbarticle
FROM
    win_update

Comment

  • I have an update on this that may help you on this, But this is only a Live discover query at the moment.

    The below query lists the updates available and returns the status if they are installed and mandatory or not.

    SELECT
    title,
    support_url,
    msrc_severity,
    installed,
    mandatory,
    size,
    kbarticle
FROM
    win_update

Children
No Data
Unfiltered HTML