Help about WMI query to SMS Site!

[David]

Hi,

I have a problem about my ASP .NET App(C# .NET) to query SMS2003 via WMI.

My web server is IIS 6.0 on Win2003 Svr SP1(Domain Controller-AD + SMS2003
SP1).

In my btn_cliclk method, my query code is as below. My question is, the
first query
gets correct result, the server and site name, while the second query get a
null collection(Coun t=0), neither an exception nor a correct one.

I am clear that these two queries connect to diffrent namespaces. But I do
have made the same security setting for these two ones in WMI Control.

And when I run these WMI query via wbemtest on the server, I do get right
result for either of them.

This problem results from WMI setting, SMS2003 setting or my code?

This question has troubled me for some days. Any helps? Thank you very much
in advance.

David

=============== =============== =============== =============== =============== =
===============
//1st query
ManagementObjec tSearcher s=new ManagementObjec tSearcher(new
ManagementScope (@"root\sms") ,
new WqlObjectQuery( "SELECT * from SMS_ProviderLoc ation WHERE
ProviderForLoca lSite='TRUE'")) ;

foreach(Managem entObject oProvLocation in s.Get())
{
sProvMachine = oProvLocation.G etPropertyValue ("Machine").ToS tring();
sSiteCode = oProvLocation.G etPropertyValue ("SiteCode").To String();
}

strTemp = @"\\" + sProvMachine + @"\root\sms\sit e_" + sSiteCode;

string strFirstQueryRs t = @"Site = " + strTemp + "\r\n";

//2nd query
ManagementObjec tSearcher oSearcher = new ManagementObjec tSearcher(new
ManagementScope (strTemp),
new WqlObjectQuery( "SELECT * from SMS_Collection" ));

string strSecondQueryR st = "Count = " + oSearcher.Get() .Count.ToString () +
"\r\n";

foreach ( ManagementObjec t oInst in oSearcher.Get() )
{
strSecondQueryR st += oInst.GetProper tyValue("Collec tionID").ToStri ng() +
"\r\n";
}