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