Kace Patch Compliance Report by OS Version

Hi All,

Hope you are well,

We have a KACE patch compliance report and wanted to see if we can only report for specific OS, like Windows 10, Windows Server, atm it shows all OS's in the report.

Here is the syntax:


M.NAME as Systemname,

M.OS_NAME as 'Operating System',

M.LAST_INVENTORY as 'Last Inventory',

M.USER as User,


MAX(PMS.STATUS_DT) as 'last detection',

Does anyone know what I have to change in the above so I can report e.g. on Windows 10 Pro, Windows Server etc.

Thank you in advance :)

0 Comments   [ + ] Show comments

Answers (2)

Posted by: KevinG 4 months ago
Red Belt

Filtering is done with a where clause in the SQL statement. 

where M.OS_NAME = 'Windows 10'    

^^ exact match

Another example:

where M.OS_NAME  like 'Windows 10%'  

^^ Starts with Windows 10

More information about "where"

Posted by: barchetta 4 months ago
2nd Degree Black Belt

Would you mind sharing the entire report?

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ