• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

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?

1 Solution
Benjamin MOREAUProject ManagerCommented:
Hi !

You have to download & install free QAD Powershell : http://www.quest.com/powershell/activeroles-server.aspx

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
Benjamin MOREAUProject ManagerCommented:
i wrote get-QADCompute but it was get-QADUser :)
Easily manage email signatures in Office 365

Managing email signatures in Office 365 can be a challenging task if you don't have the right tool. CodeTwo Email Signatures for Office 365 will help you implement a unified email signature look, no matter what email client is used by users. Test it for free!

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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now