Oct 13 2016
02:32 AM
- last edited on
Feb 07 2023
08:02 PM
by
TechCommunityAP
Oct 13 2016
02:32 AM
- last edited on
Feb 07 2023
08:02 PM
by
TechCommunityAP
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?
Oct 13 2016 07:54 AM
Hi @Andrew Gilleran,
That report indeed doesn't contain the status.
An easier way to do this is using PowerShell:
Connect-MSOLService
Get-MSOLUser -All
You will then get an overview of all users including their UserPrincipleName, DisplayName and if they are licensed or not.
Oct 13 2016 08:50 AM
Oct 13 2016 01:08 PM
Thanks guys. But the client won't be using PowerShell! Hard enough getting to use the Admin area.
Oct 13 2016 01:15 PM
Hi @Andrew Gilleran,
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.