Solved

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

Posted on 2014-03-02
6
621 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 500 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

829 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