Show LastLogOnTime on Exchange 2007
While most organization works on Exchange 2003 for their email the move to the newer Exchange 2007 provides more functionality and benefits. Exchange 2007 not only provide a good looking EMC. But is packed with new cool features such as Unified Messaging, Message tracking Center and mailbox recovery and addresses also the limitation on the database size of your the previous Exchange 2003. Well theoretically it can go up to 16TB of Exchange database size surpassing the previous 75GB limit on your Exchange 2003. But I don’t think someone would want his database size to be 16TB that is way too much to handle. Ok All is going well until one day the CIO asked me to send him a list of people who are not reading their email. So I opened up my Exchange Admin console and went to the users mailbox node..and guess what. it is not there anymore.
What used to show up in Exchange 2003 under Mailbox Store>Mailboxes is not there anymore in Exchange 2007. In Exchange 2003 thru the EMC you will find and can even export these information see figure below.
Fig 1. Exch2003
By navigating to the Mailboxes Node
You will be presented with the LasLogOnTime
But it is not the case with Exchange 2007. You will need to hustle your skill a little bit on Power shell . Yes you heard me right Power shell. So I need to brush up my typing again. Well its a little pain but once you get to have the feel of it its a great new tool to manage your Exchange 2007. After all the things you click on your EMC fires up a PS command.
So fire up the Exchange Management shell. And type in the following :
To display the entire exchange organization run
Get-MailboxStatistics -Server servername
To display a particular user LasLogOnTime run
Get-MailboxStatistics username | list LastLogOnTime
To dump to a text file you can dump it into a text file or an HTML filel by
providing the appropriate output extensions.
Get-MailboxStatistics -Server servename | out-file textfilename.txt
Get-MailboxStatistics -Server servename | out-file textfilename.html
These commands on PS ( Power shell ) will not only show you the LastLogOnTime date on a user mailbox but will also show other statistics on a user mailbox. You can display it on screen or dump it to a text/html file and submit it to your boss.
Hope it helps