8 Replies Latest reply: Apr 12, 2012 2:38 AM by Alvin Tan RSS

SCCM 2 CMDB integration.

Ganesh M

Hi Team,

 

We are integrating SCCM 2003 with CMDB 7.6.04. I have two points for which i need help/suggestion how to proceed with.

 

 

1. What field we can use to identify the CI coming from SCCM?

 

Client has mapped the SCCM Resource ID with CMDB Instance ID (Resource id is primary key from SCCM).

We can identify using Instance ID but, as per SCCM architect this resource id can change based on some modifications in CI. Now if this happens CMDB can not identify the CI and it will create a new one.

 

We are thinking of using serial number as a primary key.. will that work?

 

 

2. I created a test recon job and found that when I merge the identified data from seamless dataset to production. CMDB creates its own instance ID insted of the one stored in actual CI. Why is such behaviour? We need to push our own Instance ID in production dataset in merge activity. How can we achieve this?

 

 

 

Any suggestions would be helpful.


--


Regards,
Ganesh.

  • 1. SCCM 2 CMDB integration.
    Curtis Rowell

    Serial number might work except that it must be populated in bios for WMI to acquire this.

     

    The Instance ID is an internally generated/used unique identifier for Remedy.  You can put your Instance ID in the CI ID field.

  • 2. SCCM 2 CMDB integration.
    Ganesh M

    Thanks Crowell,

     

    I am not getting the field CI ID? do you mean to say asset ID. I could not find CI ID field on form.

     

     

    Regards,

    Ganesh.

  • 3. SCCM 2 CMDB integration.
    Curtis Rowell

    Sorry about that - try TokenID.  This is the field the BMC Discovery Tools use for the same purpose.

  • 4. SCCM 2 CMDB integration.
    careyw

    1. Asset ID and CI ID are the same field, just (confusingly) named differently on asset and base class forms. When you define a mapping it will be assetid.

     

    2. Don't map anything to InstanceId. This should be treated as a system attribute/field and left for Remedy to manage. As Curtis says above, use TokenID for SCCM Resource ID, which despite the issue mentioned above (ResourceID can change) is still your best bet for unique identifier in SCCM world. Serial number is probably a bigger risk than ResourceID, in terms of global uniqueness - we have seen plenty of issues across a wide range of items where serial number is not unique. It is usually good if used in conjunction with the manufacturer code, but no so much by itself.

     

    Did you say above you were using the Seamless SCCM integration product for this? It is usually all set up to manage these issues for you, so it shouldn't be an issue??

  • 5. SCCM 2 CMDB integration.
    Ganesh M

    Hi Careyw,

     

    Thanks for the explaination on this.

     

    Yes we are using seamless connector, As per your suggestion i will use the resource ID for identification activity.

     

    But as a case pointed by one of colleague, can you please suggest what can be done in case if.

     

    Incase the resource ID of CI changes.. As per my knowledge it would result in duplicate CI for same Asset.

     

    Regards,

    Ganesh.

  • 6. Re: SCCM 2 CMDB integration.
    Yogesh Somavanshi

    In case if ResourceIDs of CI are going to change then we have to identify a combination of attributes which is going to remain the same for every CI so that it is easily distinguishable from the others.

     

    -Thanks

    Yogesh

  • 7. SCCM 2 CMDB integration.
    careyw

    Hi Ganesh

     

    1. If you are using the Seamless Connector, it comes with mappings and recon. rules which should mean you don't have to worry about many of these things. So not sure why you are having to do your own mappings and make decisions about recon. identification rules etc. Having said that ....

     

    Can you ask your SCCM team to provide the reasons for a ResourceId changing over time?? I recall from several years back that we were advised that SCCM/SMS had a 'self repair' mechanism (think that was it) that could potentially result in a given item getting a new Resource Id. There may be other situations as well. If you can find that out, we can probably come up with a suitable identification strategy. If that isn't possible, then running with serial number plus manufacturer might be your only option. Otherwise as you mention, you will get duplicate CIs. You will need to do some data sampling from SCCM to confirm that this combination is unique for all your current data. Also, to confirm that ALL items have a serial number and manufacturer, and, to see if you need to do any Manufacturer normalisation first as well.

  • 8. SCCM 2 CMDB integration.
    Alvin Tan

    Hi Ganesh,

     

    We have been working on the integration between SCCM and CMDB for a couple of months now. Here are a couple of intricacies may be useful to your specifications.

     

    1. Resource ID changes fairly frequently and can occur for the following reasons, workstation moved to another location (different IP), operating system upgrade, new SCCM client installed and other similar type of configuration change. When that happens, you will find there are two records relate to the same workstation/machine but having a different Resource ID. This duplication occurs as the workstation with the original Resource ID remains in the source and isn't set to 'inactive' until after a number of iterations. Both records will remain until SCCM marks the original ResourceID record as 'Inactive'. So mapping ResourceID to CMDB Instance ID will lead to duplication over time and can get really messy when there are thousands of CIs to manage.

     

    The approach we have taken is combining both the name and serial number and assign it to the Instance ID for each machine. And we found that they are unique.

     

    2. Use the Reconciliation Identifier to match records between the imported and the production dataset, then you don't really need to care about the Instance ID in the production dataset.