Hi all, I need to make a file that lists the following for all of my Exchange 2007 users: Name, EmailAddress, LastLogonTime I can get their name and lastlogon time by doing: get-mailboxstatistics | select-object Displayname, LastLogonTime, however I am not sure how to sneak their email address in there as well. Any help is appreciated.

Get-MailboxStatistics doesn't give email address in output so you need to get it from Get-Mailbox or any otherequivalentcmdlet and add into same output like below... Get-MailboxStatistics | Select-Object Displayname, LastLogonTime,@{Name="EmailAddress";expression={(Get-Mailbox $_).PrimarySMTPAddress}}Amit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com

Amits cmdlet is basically correct, I tested in the lab and modified a little bit: Get-MailboxStatistics | Select-Object Displayname,LastLogonTime,@{Name="EmailAddress";expression={Get-Mailbox $_.Displayname | Select-Object PrimarySMTPAddress}} | ft -wrap

Thanks guys.

You're welcome...! :)Amit Tank | MVP Exchange Server | MCITP: EMA | MCSA: M | http://ExchangeShare.WordPress.com