How to Prevent SGC for Microsoft Intune from deleting CMDB records

dd31
Tera Guru

3 weeks ago

We are using the Service Graph Connector for Microsoft Intune to sync hardware devices into the CMDB (e.g., cmdb_ci_computer). I noticed that when a device is wiped in Microsoft Intune, the connector automatically deletes the corresponding hardware record in the CMDB after some time

Can someone clarify:

  • Where exactly this “delete when missing in source” behaviour is configured ?

  • Is there a recommended way (data stream settings, transform map, or lifecycle rule) to prevent deletion of CMDB records and instead mark them as Retired or Inactive when the app is no longer present in Intune?

If you have implemented a similar pattern in your environment, please share your approach or example scripts.

0 Helpfuls
  • 556 Views
2 REPLIES 2

Vijaya_Mnpram
Kilo Sage

a week ago

@dd31  We do use SG-Intune and there is no comparison happens with fetch data (from source) and CMDB data as part of this load. SG-Intune get the data existing in Souce and the same is loaded into CMDB.

If the Device is erased in Intune, then the data wouldn't be part of the load and thus,nothing gets updated in CMDB. You can find these records where updated date is not the recent load date.

If you say these are getting deleted in CMDB, then there might be archive rules - sys_archive.LIST for the cmdb_ci_computer table. Also, there might be a deletion job (sys_dm_delete.LIST) in your system deleting the stuff, which is archived (Deletion is not possible without archiving it). 

Check these tables and you should find the RC.

Doci1
Kilo Sage

Monday

Are you sure that the deletion is not part of Retirement/deletion policy in Data Manager?

 

0 Helpfuls