How to get the Software Ci's to show in Software Asset Foundation plugin after running SCCM (no Discovery)

[Susan29]

We have installed the Software Foundation Plugin and we ran SCCM to pull the assets but the Software Ci's are only on the cmdb_sam_sw_install table but nothing shows under CI list . Before we got the Foundation plugin, SCCM pulled all the software and listed as CI. Documentation is very vague and mixed with a lot of Sam Pro information. What should we be doing to populate the Software CI table?

Before Foundation Plugin was installed - after SCCM was connected 

And this is when we run SCCM after installing Foundation plugin

Ci table is empty. Any insight appreciated.

[VaranAwesomenow]

ServiceNow SCCM plugin comes with a JDBC integration, which directly integrates with MSSQL database of SCCM, once those data sources are configured (MSSQL credentials are provided) SCCM integration will happen and data will populate.

[Susan29]

It only populates hardware ci table, not software ci. everything is set up and synced several times. But it doesn't put it in CI table 😞

it puts everything here in the installation table:

[VaranAwesomenow]

are you referring to below cmdb_ci_spkg table ? if so is data present in SCCM in v_GS_ tables listed below.

v_GS_Add_Remove_Programs v_GS_Add_Remove_Programs_64

SCCM <version> Software [imp_sccm<version>_software]

Software [cmdb_ci_spkg] Software Installation [cmdb_sam_sw_install] (when Software Asset Management is enabled*)

[Susan29]

Yes data is there except in 

• Software [cmdb_ci_spkg]

So when I pull the CI list for software, it's empty. How can the client see their Software CI? Did it get put into a different ci class?