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

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