Return
-
Title
Report - Devices that have specific software Discovered on Software Catalog -
Description
This custom SQL report that allows you to determine which devices have specific Discovered software on them.
-
Resolution
Click Reporting | Reports | Choose Action | New (SQL).
Enter your report Title, Category, and Description fields and add the following SQL:
select
distinct
SV_MDS.NAME as CATALOGED_SOFTWARE,
SV_MDS.VERSION,
M.NAME as MACHINE_NAME,
M.USER_FULLNAME as LAST_USER
from
SAM_VIEW_DISCOVERED_SOFTWARE SV_DS
left join
SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE SV_MDS on SV_MDS.ID=SV_DS.ID
left join
MACHINE M on M.ID=SV_MDS.MACHINE_ID
where SV_MDS.MACHINE_ID is not null
and SV_MDS.NAME rlike 'NAME_REGEX'
order by SV_DS.NAME,M.NAME*NOTE - You would need to change the line that reads SV_MDS.NAME rlike 'NAME_REGEX' for software packages.
For Suites, enter the following SQL:select
distinct
SV_MDS.NAME as CATALOGED_SOFTWARE,
M.NAME as MACHINE_NAME,
M.USER_FULLNAME as LAST_USER
from
SAM_VIEW_DISCOVERED_SUITES SV_DS
left join
SAM_VIEW_MACHINE_DISCOVERED_SOFTWARE SV_MDS on SV_MDS.ID=SV_DS.ID
left join
MACHINE M on M.ID=SV_MDS.MACHINE_ID
where SV_MDS.MACHINE_ID is not null
and SV_MDS.NAME rlike 'SUITENAME_REGEX'
order by SV_DS.NAME,M.NAME