Forum Discussion

guyhorn's avatar
guyhorn
New Member
3 years ago

How to get all ACTIVE Azure AD users

Hi. Active user is a user who logs-in. Do not confuse that with accountEnabled.   Azure AD reports that in the SigninLogs.    I use this one now:   "set truncationmaxrecords=600000;SigninLogs |...
Need Help
guyhorn's avatar
guyhorn
New Member
3 years ago

PS: this works and retrieve 30 records:\

 

$signInQuery = "set truncationmaxrecords=30;SigninLogs | summarize count() by UserPrincipalName"

lbendlin's avatar
lbendlin
Super User
3 years ago

With that amount of users you likely have subdomains. You could run separate queries for each subdomain and then concatenate.

  • guyhorn's avatar
    guyhorn
    New Member
    3 years ago

    No. For two reaons. I do have an Azure AD domain with almost a million users. But above all,AAD has no sub domains.