Report on Computers and Software installed

[dvientos]

Hey All!

I am trying to narrow down an issue that is occuring during discovery where a CI is discovered and created but the software installed area is not either being populated or downloaded. However, my initial question is related to reporting.

I want to be able to create a report or filter to show me all computers that do not have software installed populated. I can start to get my full population then work on figuring out why and where this is occuring.

Thanks

Domenic

[marcelo_moreli]

In order to do that report (and any other report that needs a outer join), you can reach the result you seek by creating a Database View.

1 - Go to Database View
2 - New -> Give it a name and Save
3 - In the related list "View Tables", click "new" and populate
-- Table: (Computer) cmdb_ci_computer
-- Order (very important): 100
-- Prefix: comp
4 - Save it
5 - In the related list "View Tables", click "new" again, in order to create the second table, and populate
-- Table: (Software Instance) cmdb_software_instance
-- Order (very important): 200
-- Prefix: sof
-- Where Clause: sof_installed_on = comp_sys_id
-- Left Join: True (For this one, you'll probably need to personalize the form and add the field)
6 - Save

Done, you have a table with all the computers and software installed. If you want to see the computers with no software, just filter the new table (the database view) using "Installed On" is empty 😉

Hope this helps you, please let me know if there is something unclear,

And I've created the view on demo if you want to check it out: https://demo002.service-now.com/nav_to.do?uri=sys_db_view.do?sys_id=c6a9635b2f609544d0a0a31c91a189e8

Thanks!,

[dvientos]

Where do I find Database view?

Domenic

[Jogen]

In filter put "sys_db_view.list". you will get the database view if you cant find in system definations.

[Nathan Okh]

This helped me out for sure.