The VMware Carbon Black Tech Zone is live! Checkout this great resource: Mastering Carbon Black Audit & Remediation.

OS's Out of Compliance

Description: A single row containing the operating system name and version.

What The Data Shows: Look for operating systems out of compliance

SQL: 

SELECT name,major,minor,patch 
FROM os_version;

0 Votes
3 Comments
Query_Admin
Community Manager
Community Manager
Status changed to: Approved
 
ksalce
New Contributor

Is there a way to get the build number for windows 10 included in the query? I'm trying to find out which computers are using older versions of Windows 10 but that query doesn't give me that information unfortunately.

jnelson
Carbon Black Employee

@ksalce Here you go:

SELECT name,major,minor,patch,build
FROM os_version;

You can get more information on all the tables at: https://osquery.io/schema/4.1.2