Office365 Inactive Users

[fairm010]

I'm just taking a butchers at our Office 365 dashboard and I noticed this graph:

 

[ATTACH=CONFIG]29770[/ATTACH]

 

I don't log in often enough to see it change but where can I get it to actually tell me WHICH users are inactive!?

 

Please help!

[Michael]

I'm guessing there probably is a Powershell command, which you may/may not be able to export into Excel.

[6Foot2]

I'm guessing there probably is a Powershell command, which you may/may not be able to export into Excel.

 

If you go to Reports via the navigation bar at the side:

 

http://i.snag.gy/hp9v1.jpg

 

Then click 'Active and inactive mailboxes' you get a bar graph:

 

http://i.snag.gy/KDEyb.jpg

 

Click on the bar that you are interested in and it will offer a report:

 

http://i.snag.gy/HWuby.jpg

Mine is giving an error at the moment but there are also links available:

 

Clicking the link 'Use Windows PowerShell to create reports in Office365' takes you to a resource page that tells you how to create these reports.

[adamholt1]

Mine is giving an error. Is this an internal problem with my system or is this a whole 365 problem?

 

It will be very interesting to see the accounts as the Head is ultra keen on EVERY staff member checking their emails on a regular basis.

[fairm010]

I'll give it a shot. Does anyone else find it ridiculous that we have to use Powershell to get such basic info?

[sted]

have a look at this Download Mail Protection Reports for Office 365 from Official Microsoft Download Center

[fairm010]

Getting errors too. I'll try again tomorrow!

[fairm010]

Cheers @sted but I don't have Excel 13 installed which is a requirement for that.

[sted]

Cheers @sted but I don't have Excel 13 installed which is a requirement for that.

 

try downloading the pre release office 16

[fairm010]

Would that interfere with my Outlook setup etc? I can't be bothered dealing with that. I may just wait until the site works again.

[rs513]

You can connect to your Office365 in powershell and run this script to produce a csv of all mailboxes then just sort by last logon date once you open the csv:

 

get-mailbox | get-mailboxstatistics | export-csv "file path\file name.csv"

Edited March 20, 2015 by rs513