Solved

Exchange 2010 List all Mailboxes by last access date

Posted on 2015-01-05
6
185 Views
Last Modified: 2015-01-08
Hello,  I need to run an audit of our Exchange Server and clean up any old accounts.  What's the best way to get a report of all mailboxes sorted by last access date in Exchange 2010?  Thanks for the help
0
Comment
Question by:sdpads
6 Comments
 
LVL 3

Assisted Solution

by:biaselectronics
biaselectronics earned 150 total points
Comment Utility
Use Powershell and the following command:

Get-MailboxStatistics | Sort LastLogonTime

You can modify it with server name, database and other variables if you wish
0
 
LVL 53

Accepted Solution

by:
Will Szymkowski earned 350 total points
Comment Utility
Added detail to the script...

Get-Mailbox -Resultsize unlimited | get-mailboxstatistics | select DisplayName, Database, LastLogonTime

Open in new window


Will.
0
 
LVL 3

Expert Comment

by:Bahloul
Comment Utility
hi sdpads,

if you use A.D Saved queries that would be better see the attached xml file and import it to saved queries in the A.D that will get you all users with 60 days last logon  you can determine the suitable duration and edit the same query, command line in you target not reliable.

the below screen to import the xml file just browse to the file location :-

aduc-import-query-definition.png
0
Promote certifications in your email signature

Has your company recently won an award or achieved a certification? They'll no doubt want to show it off. Email signature images used to promote certifications & awards can instantly establish credibility with a recipient and provide you with numerous benefits.

 
LVL 20

Expert Comment

by:SatyaPathak
Comment Utility
try below and export the inactive mailbox to CSV formate .

http://www.slipstick.com/exchange/cmdlets/create-list-inactive-exchange-mailboxes/
0
 
LVL 3

Expert Comment

by:Bahloul
Comment Utility
also for your target you may search first for never logged on users using the following query in saved query  :-

 ff.png
ff.JPG
(&(&(objectCategory=person)(objectClass=user))(|(lastLogon=0)(!(lastLogon=*))))
0
 

Author Closing Comment

by:sdpads
Comment Utility
Thanks Will exactly what I needed.
0

Featured Post

Too many email signature changes to deal with?

Are you constantly being asked to update your organization's email signatures? Do they take up too much of your time? Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Well, you can!

Join & Write a Comment

Easy CSR creation in Exchange 2007,2010 and 2013
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
In this video we show how to create a User Mailbox in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >> Mailb…
This video discusses moving either the default database or any database to a new volume.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now