How do I get a list of inactive accounts in Office 365?

Question

_{Monday, April 7, 2014 8:18 PM}

Hey guys,

How can I get a list of users that have been inactive for a period of time (30 days, 60 days, etc.) in Office 365?

The Portal will only give me numbers, but no account list and I need a list of what/who they are.

Thanks,

All replies (3)

_{Wednesday, April 9, 2014 10:00 PM ✅Answered}

Hi jurgen73,

I found the following powershell script useful to me in finding the user's logon dates.  http://gallery.technet.microsoft.com/office/Export-Office-365-User-7fc0b73f

Hope this helps!

Jack

_{Tuesday, April 8, 2014 2:04 PM}

Hi,

As far as I know, at this time the Office 365 portal is the best way to get this information, please log into your Office 365 portal to see the report that gives you the number of active and inactive mailboxes over time.

In O365 a mailbox is considered inactive if a user has not logged in for more than 30 days. Number of inactive mailboxes are grouped by the number of days the user has not logged in.

But if you need the detailed list, I suggest you post the question to Office 365 Forum, the experts there may provide a suggestion:

http://community.office365.com/en-us/f/default.aspx

Regards,

Melon Chen
TechNet Community Support

_{Thursday, March 15, 2018 7:01 AM | 2 votes}

Hi,

The below GUI tool gives you inactive users on all Office 365 services and also you can find the inactive users by their last activity type such as last mail read time, last mail sent time, last team message sent, last yammer post time etc.

https://gallery.technet.microsoft.com/office/Office-365-Reporting-Tool-7987b4c2

Following are the some of the inactive Office 365 user reports which are available in the above tool.

• Inactive Exchange Users by Last Mail Read Date 
• Inactive Exchange Users by Last Mail Sent Date 
• Inactive Exchange Users by Last Mail Received Date
• Inactive SharePoint Users by Last File Accessed Date 
• Inactive SharePoint Users by Last File Synced Date 
• Inactive SharePoint Users by Last External File Sharing Date
• Inactive SharePoint Users by Last Internal File Sharing Date
• Inactive SharePoint Users by Last Page Accessed Date
• Inactive OneDrive Users by 'Last File Access Date'
• Inactive OneDrive Users by 'Last Internal Sharing Activity'
• Inactive OneDrive Users by 'Last External Sharing Activity'
• Inactive OneDrive Users by 'Last File Synced Time'
• Inactive Yammer Users by Last Like Received Date
• Inactive Yammer Users by Last Post Posted Date
• Inactive Yammer Users by Last Post Read Date
• Inactive Yammer Users by Last Activity Date
• Inactive Teams Users by Last Team Chat Message Sent
• Inactive Teams Users by Last Private Chat Message Sent
• Inactive Teams Users by Last Call Activity
• Inactive Teams Users by Last Meeting Activity
• Last Active Time of Users by Office 365 Services
• Daily Active User Count by Office 365 Services