Built off the open source project Osquery
Description: Csname and patch level of windows hosts
What The Data Shows: gives a full accounting of the patch level and OS version you are running in your environment
SQL:
SELECT csname,hotfix_id,description
FROM (`patches` ) ;
Copyright © 2005-2023 Broadcom. All Rights Reserved. The term “Broadcom” refers to Broadcom Inc. and/or its subsidiaries.