- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2023 08:41 AM
Hi Team,
I am currently working on licensing position for particular publisher & for that I want to fetch data from ServiceNow but for that I am looking for only products which needs license or those are licensable and not components.
Could you please confirm which column I need to select to get only licensable products data from discovery?
Solved! Go to Solution.
- Labels:
-
cmdb_sam_sw_install
-
Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2023 11:52 AM
We are using SCCM to primarily populate the cmdb_sam_sw_install table. I believe the licensable, non licensable, child comes from the 'Product Type' field on the Software Discovery Model, either for an existing installed software, or when ServiceNow creates a new model, and references the content service to normalize publisher and title.
Running a query or report against cmdb_sam_sw_discovery_model where product type = licensable may get you what you need to start.
-Stephen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-06-2023 11:52 AM
We are using SCCM to primarily populate the cmdb_sam_sw_install table. I believe the licensable, non licensable, child comes from the 'Product Type' field on the Software Discovery Model, either for an existing installed software, or when ServiceNow creates a new model, and references the content service to normalize publisher and title.
Running a query or report against cmdb_sam_sw_discovery_model where product type = licensable may get you what you need to start.
-Stephen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-12-2023 08:21 AM
Thank you Stephen42. I really appreciate your quick help. 🙂
