software installations didn't populate

msjoy
Kilo Expert

Recent Discovery in our environment did not populate any software under Software Asset>Discovery>Software Installations

Which means Discovery Models under Software Asset App did not populate anything either

I can view software installed under Software Installed Related Lists of Base items>Computers

Did I miss something?

4 REPLIES 4

Erik Stolberg
Tera Guru

"Software Installed" = cmdb_software_instance (old SLM table)


"Software Installations" = cmdb_sam_sw_install (new SAM table)



I'd probably start here: http://wiki.servicenow.com/index.php?title=Upgrading_to_Software_Asset_Management#Step_3:_Migrate_So...


Previously, data from the Discovery integration plugins was added to the Software [cmdb_ci_spkg] and the Software Instance [cmdb_software_instance] tables. Now, the data is added to the Software Installation [cmdb_sam_sw_install] table. Reactivating SAM ensures that the new table is used for data.



It's possible you just need to reactive the SAM plugin. It sounds like your Discovery transform maps are pointed to the old table. You can also run Software Asset > System > Migrate Software Installs to migrate existing data.


Hi Erik,

We have done SCCM integration, Data Sources Software AI two tranform maps data store into two tables old SLM table and New SAM table. After Kingston upgrade Software [cmdb_ci_spkg] and the Software Instance [cmdb_software_instance] tables transform map got disabled

when i try to enable "Disabling the Incremental Import 2012 v2 transform script for cmdb_ci_spkg table because Software Asset Management plugin is enabled" we have lot of Software installation in cmdb_software_instance table 

If i run these steps   Software Asset > Administration > Migrate Software Installs and click Proceed  all the data in Software Instance table will get migrate into Software Installations table? Also we have some data available in Software Installation cmdb_sam_sw_install table

Please help me out in this issue 

 

Thanks in advance,

Correct. If you click the "Migrate Software Installs" module, you see the following on your screen:

find_real_file.png

 

It's pretty self explanatory at that point in time. Your row count should match how much data you have in the table (mine is 0 on my PDI). That should be the only step you have to do to start using the new functionality.

msjoy
Kilo Expert

what I did was re-run discovery.


After I activated the SAM plugin, I re-run discovery and everything worked as expected.