KACE Product Support

Are you currently running any detect schedules? - dugullett 10 years ago

I was able to find the tables that allowed my to create the report I need on the patches displayed in the "Installed patches via inventory" link. Those tables are MACHINE, MACHINE_SOFTWARE_JT, AND SOFTWARE. The query looks like "SELECT `MACHINE1`.`NAME`, `MACHINE1`.`OS_NAME`, `SOFTWARE1`.`DISPLAY_NAME`, `MACHINE1`.`LAST_INVENTORY`, `MACHINE1`.`LAST_REBOOT`, `SOFTWARE1`.`IS_PATCH` FROM (`ORG1`.`MACHINE` `MACHINE1` INNER JOIN `ORG1`.`MACHINE_SOFTWARE_JT` `MACHINE_SOFTWARE_JT1` ON `MACHINE1`.`ID`=`MACHINE_SOFTWARE_JT1`.`MACHINE_ID`) INNER JOIN `ORG1`.`SOFTWARE` `SOFTWARE1` ON `MACHINE_SOFTWARE_JT1`.`SOFTWARE_ID`=`SOFTWARE1`.`ID`
WHERE `SOFTWARE1`.`IS_PATCH`=1 ORDER BY `MACHINE1`.`OS_NAME`, `MACHINE1`.`NAME`, `SOFTWARE1`.`DISPLAY_NAME`. Make sure to add in the where clause "patch=1". - jrwallace96 10 years ago