Hi community,
we running 9.1.1
My plan is to create a report from Azure AD every x hour with the last logon and write the last logon date per app in a dedicated table.
For that I have created a little table with UID_AADuser, UID_AADServicePrincipal and LastLogon field. I only want to have the latest logon. So basically, I would run a query if UID_AADUser and UID_AADServicePrincipal exists, If yes, is the new value newer then the old one, write this information. With a little script, this is a no brainer, but are there any chance to build this with the SyncEditor? I´m planning a simple CSV import.
Best, Denny
