SCCM Graph connector not creating records in sys_object_source and cmdb_ci_computer table.

KushalT
Tera Contributor

‎03-09-2022 06:06 AM

I have recently migrated from SCCM2016 to the SCCM Graph connector. All the data are getting populated in the Import set table i.e sn_sccm_integrate_sccm_2019_computer_id, however, a few of the records are not coming nither in sys_object_source nor in cmdb_ci_computer table.

Any input would be highly appreciated.

Thanks

  • 1,045 Views
2 REPLIES 2

Not applicable

‎03-09-2022 06:21 AM

There isn't a lot of information to go by, so these are just some suggestions to look at.

  • The import set table should have some information in the comment field that may help indicate what is going on.  This should be the output message from the IRE.  Something like:
  • {
  "cmdb_ci_computer": {
    "errors": 0,
    "unchanged": 0,
    "skipped": 0,
    "warnings": 0,
    "incomplete": 0,
    "partial": 1,
    "mergedPartialPayloads": 0,
    "inserted": 0,
    "additionalInserted": 0,
    "updated": 0
  }
}
  • This will indicate what the state of a given record's IRE payload.
  • For information on partial/incomplete payloads see here.  It may be that SCCM doesn't provide enough information to identify a record and it is being put in the partial/incomplete payloads table.  You can look at the table to grab the payload (filtering using the ResourceId in the payload) and then run through the Identification Simulation to get more information.
  • Errors are more general, you can check your error logs for messages.  If you get an error message for the IRE that will also help indicate what is happening.
0 Helpfuls

Cal Riley
Tera Expert

‎03-21-2023 08:03 AM

Just ran into this problem myself. Did you ever find a solution?

0 Helpfuls