How to validate SCCM integration?

[Gopi22]

Hi,

I am working in a domain separated instance and we have enabled SCCM integration. I want to validate if the correct data is flowing from SCCM to SNOW CMDB. Please guide me how can i go forward on this. Thanks.

Regards,

Gopi

[ashwinkumar_pat]

Hi Gopi,

I would import just few test records records of each CI class (computer, s/w etcs) before doing a full blown import. You have an option to do that in an import set. This will ensure that I have only few records to validate.

After fixing all the errors reported by import, I would -

1. look at the scheduled import job to identify the data being imported.
2. look at the staging table where the data is first loaded and compare it with the data in SCCM database
3. look at the transformation map to understand how is the imported data being mapped to CMDB tables (e.g. a computer record in your staging import table is mapped to cmdb_ci_computer table)
4. look at the CMDB tables to ensure that the data is consistent

Once your initial test load passes these data checks, go for full blown import in a scheduled manner.

Let me know if you need any additional info on this.

~@$h

[Gopi22]

Thank you Ashwin...for testing this integration in DEV instance, i need to delete all existing CIs in DEV instance. For this i am running a background script:

doit("cmdb_ci");

//for example doit("cmdb_ci");

function doit(cmdb_ci) {

  var gr = new GlideRecord('cmdb_ci');

  gr.addQuery('sys_domain','b736e4160a0a3c1800ebbcbb46124c74');

  gr.query();

  gr.deleteMultiple();

}

This will take some days to delete all CIs. I will start testing after deleting all CIs.

Also, how can i compare the data in staging table with SCCM database??

[ashwinkumar_pat]

Hello Gopi,

That's very easy. Just look at import set. The data that you see there is the data that got imported from SCCM. Let me know if you need more details on this. The Import Set and SCCM integration is well documented in servicenow docs. Take a quick look at docs.servicenow.com if you have not done so already.

Since you find my first reply helpful and hopefully correct, request you to mark it so. Here is how to do it -

How to Mark Answers Correct From Inbox View.

~@$#

[dravvyramlochun]

Hi Gopi,

The best way to validate is to load a few records as test for a class. Thereafter, verify the import set, transform map, schedule job and the staging table. Also query your database to see if the records have been properly updated.

References:

ServiceNow: SCCM Integration Training - YouTube

Best Practices When Using Discovery and SCCM Together - ServiceNow Wiki

http://wiki.servicenow.com/index.php?title=Microsoft_SCCM_Integration_3.0#gsc.tab=0

Microsoft SCCM integration

Introducing the MID Server

Thanks,

Dravvy

Please Hit like, Helpful or Correct depending on the impact of the response