KACE Report - Software on Computer
I'm not really experienced with SQL but I made a duplicate of this built in KACE report "Software on Computer"
It grabs all systems but I would like to modify it to select only systems under a label or specific system by name:
Select CONCAT(MACHINE.NAME, "\\", MACHINE.SYSTEM_DESCRIPTION) as MACHINE_NAME, DISPLAY_NAME, DISPLAY_VERSION, PUBLISHER from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE)
MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and
SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
order by MACHINE_NAME, DISPLAY_NAME