Export mailboxes using "last Logon time" attribute

Posted on 2005-04-28
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

    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

    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

    Want to promote your upcoming event?

    Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

    Join & Write a Comment

    You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
    Set OWA language and time zone in Exchange for individuals, all users or per database.
    In this video we show how to create a mailbox database 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 Servers >> Data…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    729 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

    17 Experts available now in Live!

    Get 1:1 Help Now