fairm010 Posted March 20, 2015 Posted March 20, 2015 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 Posted March 20, 2015 Posted March 20, 2015 I'm guessing there probably is a Powershell command, which you may/may not be able to export into Excel.
6Foot2 Posted March 20, 2015 Posted March 20, 2015 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 Posted March 20, 2015 Posted March 20, 2015 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 Posted March 20, 2015 Author Posted March 20, 2015 I'll give it a shot. Does anyone else find it ridiculous that we have to use Powershell to get such basic info?
sted Posted March 20, 2015 Posted March 20, 2015 have a look at this Download Mail Protection Reports for Office 365 from Official Microsoft Download Center
fairm010 Posted March 20, 2015 Author Posted March 20, 2015 Getting errors too. I'll try again tomorrow!
fairm010 Posted March 20, 2015 Author Posted March 20, 2015 Cheers @sted but I don't have Excel 13 installed which is a requirement for that.
sted Posted March 20, 2015 Posted March 20, 2015 Cheers @sted but I don't have Excel 13 installed which is a requirement for that. try downloading the pre release office 16
fairm010 Posted March 20, 2015 Author Posted March 20, 2015 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 Posted March 20, 2015 Posted March 20, 2015 (edited) 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now