Reporting on installed software

[Bugner]

Is it possible to create a report to list all applications installed on specific computers?  This would be by Class, so all servers or all laptops and ideally allow a filter for specific application vendors, applications and versions or editions.

I can see the installed applications on a specific CI but having a report making it possible to look for a specific vendor or application across a range of computers would be really useful.

Can anyone help please? 

Thank you!

[Chetna]

Hi Bigner, As per my understanding you want to merge two reports 1) Application to server mappings 2) Applications to computer mappings using using tables cmdb_ci_application_software (for app details) and cmdb_rel_ci (for app to server/computer mappings) If yes, then it would be best to create a database view and get all details as one report. Hope that helps.

[Adam Stout]

Take a look at the CMDB Query builder.  We did a Performance Analytics and Reporting Office Hours session on it a few months ago.  You can find the recording and how to get started here: https://community.servicenow.com/community?id=community_blog&sys_id=024bda6c1ba690908672ea89bd4bcb0b

[Vivektietsood]

As Adam suggested CMDB query builder is the right solution for this. Please be aware of performance implications though.

Please find this property in the system properties

Max number of database joins per query.

Smaller values make ServiceNow issue a large amount of less complex queries, and vice versa

Please mark helpful or accept solution so that it helps others with a similar question.

[Robert Whyte]

I've found a way to do this if you have SAM Pro, go to samp_workbench_report.list and create a new report, use the source table cmdb_sam_sw-install

Once created view this within the reports section in the SAM Pro Workspace