K1000 reports based on certain software
I'm new to Kace and have been asked to come up with a report that will pull out certain software from our software inventory. Here's the criteria
Select certain software
Need to know what user has this certain software installed and metering if possible.. Any help or direction would be much appreciated.
Community Chosen Answer
This will work. Replace Software_Name with the name of your software.
I don't currently use metering so I can't test that part. There is a METER_COUNTER table though so it should be able to be added.
SELECT M.NAME AS SYSTEM_NAME, IP, S.DISPLAY_NAME, USER_LOGGED USER,LAST_SYNC FROM MACHINE M LEFT JOIN MACHINE_SOFTWARE_JT ON M.ID = MACHINE_SOFTWARE_JT.MACHINE_ID LEFT JOIN SOFTWARE S ON MACHINE_SOFTWARE_JT.SOFTWARE_ID = S.ID WHERE (S.DISPLAY_NAME like 'Software_Name%') ORDER BY M.NAME