How do I create a list of all active mailboxes?

Hello, Which version of Exchange are you using? If Exchange 2007 then you can run below command to get mailbox statistics and see user logged on date. List all mailboxes with LastLogonTime and export to c:\users.csv Get-MailboxStatistics -ResultSize Unlimited |FT DisplayName,LastLogonTime | Export-Csv C:\Users.csv List all mailboxes where nobody logged on Get-MailboxStatistics -ResultSize Unlimited | Where {$_.LastLogonTime -eq $null }|FT DisplayName,LastLogonTime List all mialboxes on which nobody logged on in last 5 days Get-MailboxStatistics -ResultSize Unlimited | Where {$_.LastLogonTime -lt (Get-Date).AddDays(-5)} |FT DisplayName,LastLogonTime

I am using Exchange 2003 and it needs to be active employees. Many of these mailboxes are hidden from GAL as well.

In Exchange 2003 you can get last logon time & ID in Exchange System Manager. You can export the result into csv and filter it to get required result. If you want to see when user logged into AD account then you can see additional Last Logon Attribute.

Is there a way to do it that will go through all mailbox stores? IF so, what's the command? Thanks!

For that, you will either need some custom development, third party software,or you will need to use Exchange System Manager to export a list of all mailbox stores (one at a time) and then pull all of those separate CSV files in to a single spreadsheet and sort them. You might try looking at a piece of software like Promodag (they have a 30 day trial) and see if it will give you the reports you are looking for.

Thanks, I just did them one at a time. Ah...the pains of not upgrading to 2007! Thanks all!

And the pain of providing reports... especially to management.

Hey Amit,Itried your CMDlet, but getting error.[PS] H:\>Get-MailboxStatistics -resultsize unlimited |FT displayname,lastlogontime |Export-csv e:\test_siva\ActiveAccount.csvGet-MailboxStatistics : A parameter cannot be found that matches parameter name'resultsize'.At line:1 char:34+ Get-MailboxStatistics -resultsize <<<< unlimited |FT displayname,lastlogontime |Export-csv e:\test_siva\ActiveAccount.csvFunnyghost

Hey Amit, I tried your CMDlet, but getting error. [PS] H:\>Get-MailboxStatistics -resultsize unlimited |FT displayname,lastlogontime |Export-csv e:\test_siva\ActiveAccount.csv Get-MailboxStatistics : A parameter cannot be found that matches parameter name 'resultsize'. At line:1 char:34 + Get-MailboxStatistics -resultsize <<<< unlimited |FT displayname,lastlogontime |Export-csv e:\test_siva\ActiveAccount.csv Funnyghost I get the same error. I'm assuming it is because we are both on Exchange with no SP?

On Wed, 16 Feb 2011 00:46:20 +0000, Thief_1968 wrote: >Hey Amit, I tried your CMDlet, but getting error. [PS] H:\>Get-MailboxStatistics -resultsize unlimited |FT displayname,lastlogontime |Export-csv e:\test_siva\ActiveAccount.csv Get-MailboxStatistics : A parameter cannot be found that matches parameter name 'resultsize'. At line:1 char:34 + Get-MailboxStatistics -resultsize <<<< unlimited |FT displayname,lastlogontime |Export-csv e:\test_siva\ActiveAccount.csv >FunnyghostI get the same error. I'm assuming it is because we are both on Exchange with no SP? There's never been a "-resultsize" parameter on the get-mailboxstatistics cmdlet. --- Rich Matheisen MCSE+I, Exchange MVP --- Rich Matheisen MCSE+I, Exchange MVP

Hello. I have a task disable AD users. With is task consist of some subtasks. 1 - List all mialboxes on which nobody logged on in last 30 days (I find ansewer in this post) 2 -Get All Users in AD from 1 step. (I saved list DisplayName in 1 step in file) 3 - I get-content from file 2 and for each search Get-QADUser -Service 'dc.com:389' -SearchRoot 'OU=Users,OU=Example,DC=dc,DC=com' for fing LDAP path for users. And so doing I wait long time for the end work script, becouse in file saved 1000+ records. May be have another way for completed this task?