Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 14 subscribers
  • Views 14161 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Display installed Version of Windows 10

Dr Brezner

Hey Community,

is it possible to display the installed version or build of Windows 10 in Central? e.g. 20H2?

Best

DRbrezner



This thread was automatically locked due to age.
Parents
  • +1

    you could do it with live discover, if licensed.

    the query is Device>Hardware and operatin system details

  • +1 in reply to LHerzog

    I've not played with the data lake queries as much but does:

    SELECT
    distinct(meta_hostname),
    meta_os_name,
    meta_os_version,
    meta_username,
    meta_ip_address,
    meta_boot_time
    FROM xdr_data
    WHERE query_name = 'windows_updates_patch'
    group by meta_hostname,meta_os_name,meta_os_version,meta_username,meta_ip_address,meta_boot_time

    help, it would save waiting for machines to come online if they have sent some info up.

Reply
  • +1 in reply to LHerzog

    I've not played with the data lake queries as much but does:

    SELECT
    distinct(meta_hostname),
    meta_os_name,
    meta_os_version,
    meta_username,
    meta_ip_address,
    meta_boot_time
    FROM xdr_data
    WHERE query_name = 'windows_updates_patch'
    group by meta_hostname,meta_os_name,meta_os_version,meta_username,meta_ip_address,meta_boot_time

    help, it would save waiting for machines to come online if they have sent some info up.

Children
Unfiltered HTML