User status in Admin export

Question

When I export all active users as a CSV from the Admin section, there is no column for Status. Even though this is prominent column in the view. Sorting by status is one of the most useful requirements. A client is requesting this which makes complete sense. Unless I am missing something?

Admin view of users

pieter veenstra · Answer

Hi Andrew Gilleran,&nbsp;That report indeed doesn't contain the status.&nbsp;An easier way to do this is using PowerShell:&nbsp;Connect-MSOLServiceGet-MSOLUser -AllYou will then get an overview of all users including their UserPrincipleName, DisplayName and if they are licensed or not.&nbsp;

pieter veenstra · Answer

Hi Andrew Gilleran,&nbsp;The client of course doesn't have to use PowerShell. Simply create a scheduled PowerShell to run on a daily basis and then send the output to a file in SharePoint. Converting a PowerShell into xml isn't too difficult.

jcgonzalezmartin · Answer

I agree with Pieter...PowerShell reports are currently more reliable and will provide you more information about your users and licenses assigned thant what you see in the Admin center

andrew gilleran · Answer

Thanks guys. But the client won't be using PowerShell! Hard enough getting to use the Admin area.

Forum Discussion

User status in Admin export

4 Replies

Resources