Solved

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

Posted on 2014-03-02
6
646 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

728 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