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

No. I want to get all user's last login date. Therefore I need to get them all. I now founf the query: 

 

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

 

But even setting notruncationretrievs only 500000 users.  And I have 750000.

  • 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.