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:
Select
M.NAME as Systemname,
M.OS_NAME as 'Operating System',
M.LAST_INVENTORY as 'Last Inventory',
M.USER as User,
ASSET_LOCATION.NAME AS LOCATION,
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 :)
Answers (2)
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"
https://www.w3schools.com/mysql/mysql_where.asp
