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.

[emir]

try the Query Builder

[Michael Cater]

Thank you for the suggestion, however unfortunately I am restricted to using the standard report builder.

[rambabuboyapati]

You can achieve this by creating a database view using left join and reporting on the view. See below documentation for more information.

Example left join in creating a database view | ServiceNow Docs

[Michael Cater]

Thanks for the suggestion, however unfortunately that option is not available to me.