Access Query To Find Size, Number of Items and Storage Limits in Exchange 2007 Mailboxes

Scamquist
Scamquist used Ask the Experts™
on
Is it possible to use Microsoft Access 2010 to query the size, number of items and storage limits for each mailbox on an Exchange 2007 server?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
bbaoIT Consultant

Commented:
seems not able to do that.

Access is not listed as a supported dev environment here in the MSDN documentation.

Exchange 2007 SDK - Development Environment
http://msdn.microsoft.com/en-us/library/aa579066%28v=exchg.80%29.aspx
Commented:
Hi Scam,
Please check this MS-Exchange link to get the mailbox statics in exchange 2007.

Hope, this helps you.

Author

Commented:
ssmith81.  Thanks for the ideas.  The MS-Exchange link says to use the exchange shell and the command:

Get-MailboxStatistics

When I use this I get the error:
[PS] C:\Users\steven.xxxx\Desktop>Get-MailboxStatistics
Get-MailboxStatistics : Failed to commit the change on object "TEXCHANGE2007\St
andard Storage Group\Standard Storage Database" because access is denied.
At line:1 char:22
+ Get-MailboxStatistics <<<<
    + CategoryInfo          : NotSpecified: (0:Int32) [Get-MailboxStatistics],
    MapiAccessDeniedException
    + FullyQualifiedErrorId : 43402815,Microsoft.Exchange.Management.MapiTasks
   .GetMailboxStatistics

I am the administrator.  Any ideas.  I googled around and did not see a solution.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Found it.    on the Exchange Management Shell,  right-click on it and choose “Run as Administrator


ssmith81 - thanks

Author

Commented:
I appreciate the assist.

Commented:
Hi Scam,
I am sorry I was not in touch with you to assist further.
But I am glad to see that you searched and find the exact solution here.
Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial