K1000: Software Inventory By Vendor Report
I am using the Software Inventory By Vendor default report. This seems to work well, but is there any way to get this report to only show desired software?
This is the SQL for it:
Select PUBLISHER, DISPLAY_NAME, COUNT(DISPLAY_NAME) as Deployed_Count from (SOFTWARE, MACHINE_SOFTWARE_JT)
where SOFTWARE.ID = MACHINE_SOFTWARE_JT.SOFTWARE_ID
and not IS_PATCH
GROUP BY DISPLAY_NAME
order by PUBLISHER, DISPLAY_NAME