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.