Skip to main content

Entra ID

Microsoft renamed Azure AD to Entra ID; ERPL-Web exposes its directory data through Microsoft Graph.

Users​

SELECT id, displayName, mail, userPrincipalName, department
FROM graph_users()
WHERE department = 'Finance';

Sign-in logs​

Useful for audit and security analytics:

SELECT userPrincipalName, ipAddress, status, createdDateTime
FROM graph_user_signin_logs()
WHERE createdDateTime > now() - INTERVAL '24 hours'
  AND status.errorCode != 0;

Both functions support predicate pushdown where the Graph API permits it.