How Software installation records are populated from SCCM?

[ashishkumar_s]

Hi All,

Some of the fields are not getting populated in Software Installation table : cmdb_sam_sw_install

SCCM Data Source SCCM Software

Import Set Table : imp_sccm_software

In above import set we are receiving data for all the defined attributes/columns, however after running the Schedule import we did notice that some of the field values are missing in software installation table, like, revision, Install Date, Publisher, etc..

How these fields are getting mapped in Software Installation table (any BR or some other script) ?

How would I know why some fields are missing?

Any help would be appreciated.

[ashishkumar_s]

Thanks for your reply Bhavesh.

We have SCCM 3.0 enabled and in this plugin I am not sure where to check mapping of fields for Softwares.

I also verified field formats and they look fine at both the ends.

Do you know where can I find mappings of fields for Softwares ? OR

which script is responsilbe for field mappings?

Your answer is informative.

[krishna_ozarks]

I am looking for an answer for the same questions above . Please let us know the solution .

Thanks,

Krishna

[Daniel Draes]

Guess you should upgrade to the SCCM 2007 plugin. This comes with two different software data sources. One called AI one not. AI is asset intelligence and maps the import to the SAM tables.