Add a field to the existing Service Graph Intune connector for more data from the source

[Stephen Skaggs]

I have a requirement to import the "Last check-in" field from Intune via the Service Graph connector. I am not seeing this field from the source data that being imported to the staging table. Is there a way to accomplish this? I have checked how to leverage the Integration Hub ETL to modify the existing mappings but that doesn't help when trying to determine what information is being extracted from the source.

Any help is appreciated!

[Palani Chockali · Accepted solution]

Hi Stephen,

I believe the attribute you may need is called 'lastSyncDateTime' from the Microsoft Graph API call:

https://graph.microsoft.com/beta/deviceManagement/managedDevices

These API calls are being used with some filters in SG-Intune connector device and computer data sources.

Example of a device output:

{
  "id": "someid",
   "userId": "someuserid",
   "deviceName": "somedevicename",
    .....
   "lastSyncDateTime": "2022-01-01T13:41:31Z",
   <other attributes...>
}

It is currently not being pulled by SG-Intune connector and so it will not be in the staging table. It is in the back log along with some other attributes that needs to be included as part of the pull and could be in a future release. If it cannot wait until then, follow this blog post which provides steps on how to add a custom field once you know which attribute yo want to bring in:

Service Graph Connector for Microsoft Intune - Add a custom field

Also, validate 'lastSyncDateTime' from the Graph API call output with what is actually stored in Intune for a device so you are pulling the correct attribute that you need from Intune.