Intune Integration - lastLogOnDateTime and lastlogonuser attributes are empty values?

[Vini]

Hi Community friends,

We have "Service Graph Connector for Intune" and able to retrieve CI's from Intune. customer is looking for  lastLogOnDateTime and lastlogonuser attributes values but these attributes has empty values.

Note# On staging table these attributes has EMPTY values.

Please advice on this requirement. 

Regards,

Vinil.

[ersureshbe]

Hi, I recommend checking the robust transform in the scheduled job. I perceive the mapping is not present. 

If mapping is present check the value of the field from Intune.

[Vini]

@ersureshbe  & Community friends,

We are able to retrieve last login date from Intune to ServiceNow staging table but it is not set on Computer table.

I believe it's date format issue.

Last login date# 2023-02-15T14:15:04.079Z

it should be 2023-02-15 14:15:04 [How to set this value to "Last Login Date" attribute in Computer table?

[Rahul Priyadars]

(1) Either You Customize the Robust Transform Map which is avaliable OOTB and map these Fields.

(2) Write a small Transform Map on Staging table to populate these 2 attributes after Main Job is finished. This will ease your maintenance down the line as you are not touching OOTB Robust Transform Map Jobs.

Regards

RP 

[ersureshbe]

Hi, I suspect the import set table's last login date time field is a string or date time. If the string changes it to date it will resolve.

Another use case -  Import set table holds correct the field type then you should check the DD TT formats.

If not matched your ServiceNow instance date time zone you should convert it as per ServiceNow Date Time Zone using GlideDateTime() functions