SCCM Integration for Insight: What Locator do I need to use?

[Richard Schmidlin]

Hi everyone

I am trying to import data from SCCM to the Insight CMDB in Jira Core.

When I create an object type mapping, I need to set the data locator. But I don't know what data Locator I need to use. I tried the same with LDAP import and the data locator for this scenario I managed it with an OU Path.

I tried it with a specific table of the SCCM database, but there are so many tables so I have no idea where to start.

Sadly I found no specific documentation on this topic.

[Craig Haynal · Accepted solution]

If you're using the SCCM plugin for Insight, I would suggest starting by letting it create the schema and import mapping.  We used it to learn some techniques for managing SCCM data in Insight, though ultimately we decided to scrap it and develop our own SQL queries that pull the specific asset elements we need.  It's the best place to start.

If you're trying to import manually via SQL or similar, nearly everything in SCCM relates to a Resource ID, which I have found to be the most useful locator for system, user, and group objects.  Other objects like hardware and software have similar IDs that can serve as good locators.  I would suggest taking a look at the relevant version of the SCCM views database schema from TechNet.