cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Claim your free VMworld 2020 ticket now for a completely digital experience to learn about how VMware Carbon Black can protect you from sophisticated threats.

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
Community Manager
Community Manager
Status changed to: Approved
 
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.

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