Report on Software Installed on cmdb_ci_computer

[Les1]

Wanting to build a report or query or something to show a list of cmdb_ci_computer  that has a particular software installed (i figured on conditioning off of manufacturer in order to get different versions captured)  and wanted the output to have the list of computers with the column showing the version of the software installed. So far i've been unable to concoct this via report, cmdb query, or database view.  thoughts?

i can get the list of computers by pulling in "software installed" related list condition, but havent figured out how to include the version as part of the report data.

talks about reporting on whats NOT there, which is also a question  https://community.servicenow.com/community?id=community_question&sys_id=a08943a5db5cdbc01dcaf3231f96...

this post sounded promising for using database view but i still couldnt get a report output that i want even based on a database view: https://community.servicenow.com/community?id=community_question&sys_id=3df05fa9dbdcdbc01dcaf3231f96...

have you accomplished something like this? am i going to have to export data to spreadsheets and then do like a lookup?

thanks

[The Machine · Accepted solution]

You could run a report on the cmdb_software_instance table.  This will allow you to dot walk to the installed on field for the computer, and the product name for versions, etc. 

Hope that helps!

[Nagarajan Singa]

Hi,

I want to get the Installed Application software in Linux servers using  "cmdb_software_instance " or "cmdb_sam_sw_install". but it is showing more than 800+ entry like all the RPM lists. 

It does not required to get in Software Inventory Reports. 

We have 31 application installed on Linux servers. This we could get from other tools like "BigFix Inventory". 

Could we have any way to get only Installed application details on linux platform?

Thanks,

Nagarajan.