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.

[domaners]

You can see the fields that are queried by the Software import by clicking on the Data Sources link on the left in the ITCM application, then by choosing the Software data source. Check the SQL statement on the right-hand side to see the fields brought back from ITCM and update the query to add more fields if you are comfortable with SQL. If you add more fields, make sure to update the transform map (at the bottom of the data source record) so that the new fields pulled out of ITCM are mapped over to field in the CMDB Software table in Service Now.

[ashishkumar_s]

Thanks for your reply Adam.

You are right if I am using SCCM plugin version 4.0.

Here we have plugin 3.0 enabled. In this plugin in Software Data Source we do not have SQL statements visible as they are directly coming from SCCM, but your answer is useful.

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

which script is responsilbe for field mappings?

[domaners]

Hi Ashish,

I'm basing my knowledge from the 2012 plugin, which we are just implementing at the moment. From what I can gather, in the v3 plugin, if you want to set up more fields to be moved over, you'd need to add extra columns to the table which you create on the SCCM schema:

Microsoft SCCM Integration 3.0 - ServiceNow Wiki

This table seems to act much like a Database view, in that it pulls out loads of records out of multiple tables, denormalizes the relationships and the integration pulls everything from there. Section 6.2.2 contains the sample SQL script for setting up the table on your schema, so use this as a template for adding any new fields you require.

[Bhavesh Jain1]

Are you sure those fields are there in the Transform map?

if yes, you can check the type of the fields you are updating. Like for the Install date you need to set the date format in the Field map.

Check if revision and publisher fields are also having some format issue or field length issue.