Advise Required: Multi SCCM Integration
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2024 10:25 AM
While doing SCCM Integration, Resource ID of SCCM plays an important Role as an Unique Key (Correlation ID) to populate data in CMDB, In case we are using multiple SCCM and both are having similar Resource ID, Is it possible to modify criteria to make Correlation ID as combination of Resource ID and Site Code, so data populated by multiple SCCM has a unique Key? @Rahul Priyadars.
If Yes, Could you please help on how to configure the same using Service Graph connector?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 02:12 AM
Yes Ashish
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 02:51 AM
If you have followed SGC Guided setup then you must have 2 records in Instances with 2 prefix you choose.
If that is the case then you dont need to do anything, SGC will append connection id with ResourceID to make it unique (connection id is the sys_id of the instance record)
So even if you have multiple instances of SCCM Databases configured in your SGC it is fine because Resource ID | Connection ID is always going to be unique as Connection ID is unique for each SCCM instance.
To validate this:
Go to sys_object_source.FILTER in navigation and search for Target sys id = <sys id of any CI created by SG-SCCM data source)
Are you seeing any issues with Identifications ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 12:51 AM
Hi Ashish,
As Correlation ID coming via both SCCM has 200+ similar correlation IDs so everyday, one data source replacing another data source. Any solution to it?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-13-2024 06:21 AM
Hi@Sumit Maheshwar ,
If CI's are getting pancaked because of similar CorrelationID (Resource ID) then you have to concatenate Site ID with Resource ID as it looks like you have duplicate Resource ID in SCCM Database under different sites. We had the same issue and we also had to customize SQL's.
You can do that by going to Service Graph Connector >>SCCM >>Instances.
Choose Instance and customize SQL for all the Data sources to concatenate Site ID + Resource ID. It is must to modify SQL in all the data sources that are active.
You will have to do this for both SCCM Instances.
Thanks,
Ashish
