How to report on computers and installed software
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
