Built off the open source project Osquery
Description: A single row containing the operating system name and version.
What The Data Shows: Look for operating systems out of compliance
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.
@ksalce Here you go:
SELECT name,major,minor,patch,buildFROM os_version;
You can get more information on all the tables at: https://osquery.io/schema/4.1.2