How to report on computers and installed software

[Michael Cater]

Hello,

In the ServiceNow instance I work with there are Computer CIs and some of these have Installed Software instances representing their BIOS version.

I want to report on ALL Computers and include the Software values Product Name, Installed, Version. This will allow me to find Computer records that do not have a related Installed Software record or where that record needs updating.

I cannot see how to perform this reporting function. I can separately report a list of all computers together with a list of all computers WITH Installed Software but I cannot see how to do a report that includes all computers and details of installed software if that record has any such relationships.

I would be grateful for some advice.

Thanks.

[StevensonJ]

I profoundly like your dedicated abilities as the post you distributed has some incredible data which is very valuable for me.
 

Mary Kay In Touch

[jba-m]

@rambabuboyapatiwhat tables are you joining in the view? I'm missing a many-to-many relational table between cmdb_ci and cmdb_ci spkg 

@emir query_builder does not allow a relation between server and software,  a 2nd level relationships does not find anything