How to report on computers and installed software

Michael Cater
Kilo Contributor

‎01-20-2022 08:41 AM

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.

0 Helpfuls
  • 1,463 Views
6 REPLIES 6

StevensonJ
Kilo Explorer

‎03-03-2022 01:34 AM

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

0 Helpfuls

jba-m
Tera Contributor

‎12-05-2023 03:09 AM - edited ‎12-05-2023 03:48 AM

@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

0 Helpfuls