cmdb_sam_sw_install table missing on fresh Zurich instance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 hours ago
Hi all,
Per the ServiceNow documentation, cmdb_software_instance is deprecated as of the Zurich release, and cmdb_sam_sw_install is now the table used to store the relationship between a Computer CI and a Software Package CI.
However, on our Dev instance — a freshly installed Zurich version — this table doesn't exist. (Screenshot attached.)
Separately, we're also seeing the GlideRecord API fail silently when writing to cmdb_software_instance — specifically, the setValue() method fails silently, with no exceptions thrown.
What I'd like to know:
- Is cmdb_sam_sw_install gated behind a specific plugin or SAM Pro license?
- If so, which plugin needs to be activated to make this table available. Any documentation related to the same?
- Is there any documentation on the setup steps required post-installation?
- Is the silent failure on cmdb_software_instance writes expected/related to its deprecation?
Any pointers would be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago - last edited 2 hours ago
Hi @kunalachary
Can you confirm if you have SAM role to check this. Like sam_admin?
Also confirm following plugin is installed in your instance.
Software Asset Management Core (com.snc.sam.core)
Regards
Tanushree Maiti
ServiceNow Technical Architect
LinkedIn: https://www.linkedin.com/in/tanushreemaiti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago - last edited an hour ago
Hi @kunalachary
yes it is part of SAM Pro '[ You can install this plugin in PDI] https://youtu.be/7P4PIwZOg-0
The Software Install table (cmdb_sam_sw_install) is the base table SAM Pro is built on. The Software Install table is a 1:1 from your discovery sources. For example, if you have SCCM or ServiceNow Discovery identifying software it would be loaded into this table with the same values as the source.
The next step is the SAM module looks at your raw Software Install data and normalizes and enriches it in the Discovery Model table (cmdb_sam_sw_discovery_model). This normalization happens automatically when new software install data is populated (software model is not a requirement for normalization).
After everything is normalized we come to the software model table (cmdb_software_product_model). The software model references what discovery models we want in scope.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
2 hours ago
Hi @kunalachary
Once you install Software Asset Management (sn_itam_samp), the cmdb_sam_sw_install table will be installed automatically.
I just installed in my PDI and verified.
Regards,
Siva