C#

<br />
try<br />
			{<br />
				string cServername;<br />
				ManagementObjectCollection mcExchange=queryServer(".","select * from Exchange_Server");<br />
				txtNoOfServers.Text=mcExchange.Count.ToString();<br />
				//Double ttlSize=0;<br />
				foreach(ManagementObject moExchange in mcExchange)<br />
				{<br />
					cServername = moExchange["Name"].ToString();<br />
				<br />
				<br />
				<br />
					string[] SQLArray=new string[7];<br />
					<br />
					SQLArray[0]="select * from Exchange_Mailbox where size <=10240";<br />
					SQLArray[1]="select * from Exchange_Mailbox where size >" + 10240 + " and size <=" + 5*10240;<br />
					SQLArray[2]="select * from Exchange_Mailbox where size >" + 5*10240 + " and size <=" + 10*10240;<br />
					SQLArray[3]="select * from Exchange_Mailbox where size >" + 10*10240 + " and size <=" + 25*10240;<br />
					SQLArray[4]="select * from Exchange_Mailbox where size >" + 25*10240 + " and size <=" + 50*10240;<br />
					SQLArray[5]="select * from Exchange_Mailbox where size >" + 50*10240 + " and size <=" + 100*10240;<br />
					SQLArray[6]="select * from Exchange_Mailbox where size >" + 100*10240;<br />
					// number of mailboxes<br />
					txtMB.Text=queryServer(cServername,"select * from Exchange_Mailbox").Count.ToString();<br />
					//Mailbox sizes<br />
					int[] MBSizesArray= new int[7];<br />
					lstMBSizes.Items.Add(cServername);<br />
					for (int i=0;i<7;i++)<br />
					{<br />
						MBSizesArray[i]=queryServer(cServername,SQLArray[i]).Count;<br />
						lstMBSizes.Items.Add(MBSizesArray[i].ToString());<br />
					}<br />
					//					//Number of Public folders according to Exchange<br />
					//					txtPF.Text=queryServer(cServername,"select * from Exchange_PublicFolder").Count.ToString();<br />
					//					//PF size<br />
					//					SQLArray[0]="select * from Exchange_PublicFolder where totalmessagesize <=" + 10240;<br />
					//					SQLArray[1]="select * from Exchange_PublicFolder where totalmessagesize >" + 10240 + " and totalmessagesize <=" + 5*10240;<br />
					//					SQLArray[2]="select * from Exchange_PublicFolder where totalmessagesize >" + 5*10240 + " and totalmessagesize <=" + 10*10240;<br />
					//					SQLArray[3]="select * from Exchange_PublicFolder where totalmessagesize >" + 10*10240 + " and totalmessagesize <=" + 25*10240;<br />
					//					SQLArray[4]="select * from Exchange_PublicFolder where totalmessagesize >" + 25*10240 + " and totalmessagesize <=" + 50*10240;<br />
					//					SQLArray[5]="select * from Exchange_PublicFolder where totalmessagesize >" + 50*10240 + " and totalmessagesize <=" + 100*10240;<br />
					//					SQLArray[6]="select * from Exchange_PublicFolder where totalmessagesize >" + 100*10240;<br />
					//					lstPFSizes.Items.Add(cServername);<br />
					//					int[] PFSizesArray= new int[7];<br />
					//					for (int i=0;i<7;i++)<br />
					//					{<br />
					//						PFSizesArray[i]=queryServer(cServername,SQLArray[i]).Count;<br />
					//						lstPFSizes.Items.Add(PFSizesArray[i].ToString());<br />
					//					}<br />
					//number of PF with AD<br />
					DirectoryEntry rootdse=new DirectoryEntry("LDAP://RootDSE");<br />
					DirectoryEntry cfg=new DirectoryEntry("LDAP://"+rootdse.Properties["configurationnamingcontext"].Value);<br />
					DirectorySearcher cfgsearch=new DirectorySearcher(cfg);<br />
					cfgsearch.Filter="(&(objectCategory=msExchExchangeServer)cn="+cServername +")";<br />
					cfgsearch.PropertiesToLoad.Add("distinguishedName");<br />
					cfgsearch.SearchScope=SearchScope.Subtree;<br />
					SearchResult res=cfgsearch.FindOne();<br />
					//define variables<br />
					SearchResultCollection resStorageGroups=searchContainer(res.Properties["distinguishedName"][0].ToString(),"&(objectCategory=msExchStorageGroup)");<br />
					<br />
					//loop through the storagegroup collection<br />
					foreach (SearchResult sg in resStorageGroups)<br />
					{<br />
						SearchResultCollection resMailboxes=searchContainer(sg.Properties["distinguishedName"][0].ToString(),"&(objectCategory=msExchPrivateMDB)");<br />
						//loop through the mailbox collection<br />
						foreach(SearchResult mb in resMailboxes)<br />
						{<br />
<br />
						<br />
						}<br />
					<br />
					}<br />
<br />
<br />
<br />
					//messages to internet<br />
					DateTime startTime=new DateTime(System.DateTime.Now.Year,System.DateTime.Now.Month,System.DateTime.Now.Day-1);<br />
					DateTime endTime=startTime.AddHours(24);<br />
				<br />
					string sTime=startTime.ToString("yyyyMMdd")+ "000000.000000+000";<br />
					string eTime=endTime.ToString("yyyyMMdd")+ "000000.000000+000";<br />
					<br />
				<br />
					ManagementObjectCollection mc=queryServer(cServername,"select * from Exchange_MessageTrackingEntry where Timelogged>='" + sTime + "' and TimeLogged<'" + eTime+"'");<br />
					txtMailVolumeMsg.Text=mc.Count.ToString();<br />
					Double ttlSize=0;<br />
					foreach(ManagementObject mo in mc)<br />
					{<br />
						ttlSize+=Convert.ToDouble(mo["Size"])/(1024*1024);		<br />
					}<br />
					//size to internet<br />
					txtMailVolumeMB.Text=ttlSize.ToString();<br />
				<br />
					//messages from internet<br />
<br />
			<br />
					//size from internet<br />
			<br />
<br />
					//#messages to internal recipient<br />
			<br />
					//size to internal recipient<br />
				}<br />
			}<br />
			catch (Exception ex)<br />
			{<br />
				MessageBox.Show(ex.ToString());<br />
			}<br />
<br />
<br />
		<br />
		}<br />
<br />
		private ManagementObjectCollection queryServer(string servername,string querystring)<br />
		{<br />
			try<br />
			{<br />
				System.Management.ConnectionOptions objconn = new System.Management.ConnectionOptions();<br />
				objconn.Impersonation = System.Management.ImpersonationLevel.Impersonate;<br />
				objconn.EnablePrivileges = true;<br />
				System.Management.ManagementScope exmangescope = new System.Management.ManagementScope(@"\\" + servername + @"\root\MicrosoftExchangeV2",objconn);<br />
				System.Management.ObjectQuery objquery = new System.Management.ObjectQuery(querystring);<br />
				System.Management.ManagementObjectSearcher objsearch = new System.Management.ManagementObjectSearcher(exmangescope,objquery);<br />
				return objsearch.Get();<br />
			}<br />
			catch (Exception e)<br />
			{<br />
				MessageBox.Show(e.ToString());<br />
				return null;<br />
			}<br />
		}<br />
<br />
		private SearchResultCollection searchContainer(string p,string fltr)<br />
		{<br />
			try<br />
			{<br />
				DirectoryEntry serverContainer=new DirectoryEntry("LDAP://"+p);<br />
				DirectorySearcher serverSearch=new DirectorySearcher(serverContainer);<br />
				serverSearch.Filter=fltr;<br />
				serverSearch.SearchScope=SearchScope.Subtree;<br />
				serverSearch.PropertiesToLoad.Add("cn");<br />
				serverSearch.PropertiesToLoad.Add("distinguishedName");<br />
				serverSearch.PropertiesToLoad.Add("homeMDBBL");<br />
				SearchResultCollection result=serverSearch.FindAll();<br />
<br />
				return result;<br />
			}<br />
			catch (Exception srcex)<br />
			{<br />
				MessageBox.Show(srcex.ToString());<br />
			<br />
			}<br />
		}

XmlDataSource xds = new XmlDataSource();
xds.DataFile = ("d:/test.xml");

GridView1.DataSource = xds;
GridView1.DataBind();

DataSet ds = new DataSet();

System.IO.StreamReader  str = new StreamReader("d:/test.xml") ;
StringReader rdr = new StringReader(str.ReadToEnd());

ds.ReadXml(rdr);//<-- this is the KEY bit as I need to load from a string
GridView1.DataSource = ds;
GridView1.DataBind();