need query to show what exchange mailboxes were created this year

So we are doing our 2011 MS True up and Exchange 2010 shows that we have 1600 mailboxes.  This is strange to me since last year we had 1050 mailboxes and have not added that many users.  

Can you point me to some sort of query that will show me what mailboxes were created this year?

stowyoAmericas Regional IT ManagerAsked:
Who is Participating?
Benjamin MOREAUConnect With a Mentor Project ManagerCommented:
i wrote get-QADCompute but it was get-QADUser :)
Benjamin MOREAUProject ManagerCommented:
Hi !

You have to download & install free QAD Powershell :

Then, run on Active Roles powershell : Get-QADComputer | select Name, WhenCreated | Export-Csv EXPORT.CSV

this should work via standard powershell on your dc (non-tested):

$Date = New-Object DateTime(2011,01,01,0,0,0)
Get-ADUser -RecipientTypeDetails User -Filter { whenCreated -gt $date } -Properties whenCreated | Select Name,whenCreated,distinguishedName | FT -Autosize -Wrap
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

stowyoAmericas Regional IT ManagerAuthor Commented:
These will show when Exchange Mailboxes were created?  Let me run some tests.
stowyoAmericas Regional IT ManagerAuthor Commented:
None of the shells.  2008, ActiveRoles or EMS will accept GET-QADUser.  I tried both of your scripts and they will not run..  See this error.

The term 'Get-QADUser' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the
 spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:12
+ Get-QADUser <<<<  | select Name, WhenCreated | Export-Csv EXPORT.CSV
    + CategoryInfo          : ObjectNotFound: (Get-QADUser:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException
Benjamin MOREAUProject ManagerCommented:
Have you install the QAD Powershell ? If No, install it. If Yes, you must run the command line from this powershell (start menu > Quest > Active Roles Powershell) and not from the standard powershell.
stowyoAmericas Regional IT ManagerAuthor Commented:
I did run this from ActiveRoles Powershell...  Can you post the script so I can copy/paste it into a PS1 file?
You don't NEED to install QAD. This would work the same using:

get-mailbox | where-object {($_.whencreated -like "*2011*)} | format-list name,whencreated
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.