Powershell to determine active mailbox on Exchange Server 2010

@Fox,

I've done it already using the Powershell script below:

Get-MailboxServer | Get-Mailbox -ResultSize Unlimited | Measure-Object

Select allOpen in new window

But how to know if the mailbox is still in use or not ?

You should try the Get-MailboxStatistics -Identity 'username' | fl * to check out the LastLogonTime and LastLogoffTime attributes that it returns.

check if this works

Get-Mailbox –Resultsize Unlimited | Get-MailboxStatistics | Sort LastLogonTime | select Displayname, lastlogontime

Select allOpen in new window

you can export to .csv

Get-Mailbox –Resultsize Unlimited | Get-MailboxStatistics | Sort LastLogonTime | select Displayname, lastlogontime | Export-CSV -Path d:\Mailbox-Logon-Report.csv -NoTypeInformation

Select allOpen in new window

Add additional properties to select statement as required.

Hope that helps.

You can also use "Date" comparison using (Get-Date).adddate(-30) and the LogonTime value to check users who has logged in last 30 days from the current date.

@Vaseem,

Yes please, how to include that date older than 90 days into the script that you've suggested ?

Use a variable to store the value of (get-date).adddays(-90)
Compare the result in the variable to the value in lastlogontime
Logic would be, if lastlogontime is greater than value in variable then collect those user details else discard.
I can't give you a working script as am on vacation ;-)

Thanks Vaseem,

let us know when you back from the vacation :-)