Export mailboxes using "last Logon time" attribute

Posted on 2005-04-28
Medium Priority
Last Modified: 2012-08-14
Does anyone know if there is a way to do this?  I have looked at the attributes that are available with Header.exe and cannot find anything.
My dilema is that I have an exch 5.5 organization with 7500 mailboxes in it, of which about half have been used in the past 5 months.  I want to delete those that are inactive, but as you know with the interface for Exch5.5 you cannot delete from the "Private Information Store" container.
Any help or suggestions is appreciated.
Question by:putzco
LVL 27

Accepted Solution

Exchange_Admin earned 1200 total points
ID: 13890637
Bear with me it has been awhile since I have used 5.5, I am working from memory. Some of my statements may not be 100% exact, but it will put you in the ballpark.

Well you could try this:
1. In the Exchange Admin program, go to the Mailboxes container. Make sure that the Last Logon and Directory Name column are visible.
2. Click on one of the mailboxes in the right hand pane. Then go to the File pulldown and select SAVE AS (could be SAVE CONTENTS, you should see what I mean). Save it as a CSV file.
3. Open this up in Excel. You should then be able to sort by the Last Logon column.
4. Narrow the file down to just the ones you want to delete.

Now you will have something you can work with. You should be able to create your own CSV file to use to delete the mailboxes that are not needed.

It seems like you know how to delete mailboxes via Directory Import so I will not go into that detail. But be sure you have a GOOD backup prior to doing this. It also would not hurt to do a DIRECTORY EXPORT of the mailboxes prior to deleting any. This is just a safeguard.

Hope this helps.

Author Comment

ID: 13894190
Thanks allot, I can't believe I forgot about that feature.  That works well and will allow me to use the import tool to hide then delete these accounts....

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.
Suggested Courses

839 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