Hi, I have a WMI script which is taking almost 2 minutes to return me a count of the number of items in an SwbemObjectSet returned from ExecQuery. This happens even when the set is empty! Code snippet below: Set objBizTalk = GetObject( "Winmgmts:!root\MicrosoftBizTalkServer" ) strQuery2 = "SELECT * FROM MSBTS_MessageInstance" & _ " WHERE ServiceName <> """" AND (ServiceInstanceStatus=4 OR ServiceInstanceStatus=32)" Set objInstSet2 = objBizTalk.ExecQuery( strQuery2 ) suspMesgCount = objInstSet2.Count From putting echos in the script, I can see that all the time is spent executing objInstSet2.Count. I understand that this enumerates through the set couting up how many items are in it, but surely if there's nothing there then it should not take any time at all? The same happens if there are items in the collection. Other WMI queries (e.g. to get the number of services) which do similar things using different providers work fine. Is the problem the MicrosoftBizTalkServer WMI provider? And if it is, is there anything I can do about it? I have tried specifying a forwards only collection, but that makes no difference. Thanks for any help, Al.
