Azure Active Directory Data

[JoshHamilton77]

Hey there!

So I'll give a real quick run through of the problem that we are looking to solve. We have ServiceNow discovery set up for a variety of technologies for a specific client. What we are trying to do is pull the latest sign on data from Azure AD and push it into the corresponding CI record. Initially I was trying to use flow designer to accomplish this task but I ran into problems with the 'Look up Devices Stream' and 'Look up Sign on Steam' actions in the Microsoft AD spoke.

In theory I thought it made sense to loop through each and match the data by the unique device name, but it seems Flow Designer won't let me mix and match that data.

Heres my questions for the group:

1.) Has anyone run into anything similar and if so, how did you accomplish that task?

2.) Does that plan make sense? Or do I need to rethink my approach?

Any insights would be greatly appreciated. Thank you!

[Niklas Peterson · Accepted solution]

Hi,

I've done something similar but I just run a scheduled job that makes a REST Call to Microsoft Graph API and pushing the response to an import set and then transform the data to the CIs.

The end point I used is https://graph.microsoft.com/v1.0/devices and then I fetch the approximateLastSignInDateTime to update the CIs.

https://learn.microsoft.com/en-us/graph/api/device-list?view=graph-rest-1.0&tabs=http

Regards,
Niklas