Monday, August 08, 2005

Iterating though storage groups with CDOEXM C# sample

Someone asked today about a C# sample for Iterating though mailboxes stores in a storage group in C#. There's a lack of good samples out there that show this at the moment so I threw one quickly together.

One thing that recently changed with the release of the latest Exchange SDK is that Microsoft has "removed support for CDOEXM in ASP and ASP.NET Web pages Because of issues with multiple-hop authentication and unexpected results observed in multithreaded runtime environments" see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/wss_sdk_whats_new.asp

I've put a downloadable copy of this code here


CDOEXM.IExchangeServer iExs;
CDOEXM.IStorageGroup iSg;
CDOEXM.MailboxStoreDB iMdb;
CDOEXM.PublicStoreDB iPf;
iExs = new CDOEXM.ExchangeServerClass();
iSg = new CDOEXM.StorageGroupClass();
iMdb = new CDOEXM.MailboxStoreDBClass();
iPf = new CDOEXM.PublicStoreDBClass();
string snServername = "servername";
iExs.DataSource.Open(snServername,null,ADODB.ConnectModeEnum.adModeReadWrite,
ADODB.RecordCreateOptionsEnum.adOpenIfExists,
ADODB.RecordOpenOptionsEnum.adOpenSource,null,null);
foreach (string Sgname in (IEnumerable)iExs.StorageGroups){
iSg.DataSource.Open(Sgname,null,ADODB.ConnectModeEnum.adModeReadWrite,
ADODB.RecordCreateOptionsEnum.adOpenIfExists,
ADODB.RecordOpenOptionsEnum.adOpenSource,null,null);
foreach( string Mbname in (IEnumerable)iSg.MailboxStoreDBs){
iMdb.DataSource.Open(Mbname,null,ADODB.ConnectModeEnum.adModeReadWrite,
ADODB.RecordCreateOptionsEnum.adOpenIfExists,
ADODB.RecordOpenOptionsEnum.adOpenSource,null,null);
System.Console.WriteLine("Store Name: " + iMdb.Name);
System.Console.WriteLine("Status: " + iMdb.Status);
System.Console.WriteLine("Storage Quota Limit: " + iMdb.StoreQuota);
System.Console.WriteLine("Over Quota Limit: " + iMdb.OverQuotaLimit);
System.Console.WriteLine("HardLimit: " + iMdb.HardLimit);
System.Console.WriteLine("");
}
foreach( string Pfname in (IEnumerable)iSg.PublicStoreDBs){
iPf.DataSource.Open(Pfname,null,ADODB.ConnectModeEnum.adModeReadWrite,
ADODB.RecordCreateOptionsEnum.adOpenIfExists,
ADODB.RecordOpenOptionsEnum.adOpenSource,null,null);
System.Console.WriteLine("Store Name: " + iPf.Name);
System.Console.WriteLine("Status: " + iPf.Status);
System.Console.WriteLine("");
}
}
}