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.
![Cataloged Discovered Software and devices](https://prod-support-images-cfm.s3.amazonaws.com/KB_1-4E87FNS_233193_REPO1_EN.PNG)
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
|
![Cataloged Discoverd Suites and devices](https://prod-support-images-cfm.s3.amazonaws.com/KB_1-4E87FNS_CATSUITELIST_EN.PNG)