?
Solved

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

Posted on 2014-03-02
6
Medium Priority
?
684 Views
Last Modified: 2014-03-31
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?
0
Comment
Question by:Scamquist
  • 3
  • 2
6 Comments
 
LVL 37

Expert Comment

by:bbao
ID: 39899657
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
0
 
LVL 2

Accepted Solution

by:
ssmith81 earned 2000 total points
ID: 39899735
Hi Scam,
Please check this MS-Exchange link to get the mailbox statics in exchange 2007.

Hope, this helps you.
0
 
LVL 1

Author Comment

by:Scamquist
ID: 39900288
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.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 1

Author Comment

by:Scamquist
ID: 39900561
Found it.    on the Exchange Management Shell,  right-click on it and choose “Run as Administrator


ssmith81 - thanks
0
 
LVL 1

Author Closing Comment

by:Scamquist
ID: 39900563
I appreciate the assist.
0
 
LVL 2

Expert Comment

by:ssmith81
ID: 39902349
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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question