List OS and application/software in a table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2018 06:40 AM
I'm looking for a way to view all software/applications found during Discovery. The thing is that I also want to see OS in this table, but ServiceNow Discovery does not store that in neither cmdb_ci_app table nor cmdb_ci_spkg table.
Is there a way to get Computer OS into these tables?
What I'm looking for in the long run, is to be able to set dates when an application or software expires, so I'm looking to add a expiration date to this table. Basically a table where I can see both Google Chrome and Windows Server 2016.
Should be fairly simple in my mind...?
- Labels:
-
Discovery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2018 07:02 AM
On the cmdb_ci_spkg is there a reference to the server it's installed on? If so you can dot walk that in a report to pull out Server 2016. If there isn't or the reference is at too low of a table then you are going to have to create a database view to join those 2 tables and to pull out the information that you need. Hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2018 07:08 AM
Hi Robert,
No there isn't. There is a related list called "Installed on", but nothing is in there and this is from a record being added by ServiceNow Discovery. Just assumed this would be OOTB functionality that would display the data...?
