Microsoft KB Archive/254347

= SMS: The Query Extract Tool in the Resource Kit Is Unable to Return Data from Large Collections =

Article ID: 254347

Article Last Modified on 9/11/2007

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q254347



SYMPTOMS
If your server receives more than 5000 hits, the Systems Management Server (SMS) 2.0 Query Extract tool, located in the Microsoft BackOffice Resource Kit, is unable to return complete data and you may receive the following error message:

Method 'ExecQuery' of object 'ISWbemServices' failed.



WORKAROUND
To work around this behavior, download the latest version of the Query Extract tool from the SMS 2.0 Support Tools section located on the following Microsoft Web site:

http://www.microsoft.com/smserver/default.mspx



STATUS
The latest version of the Query Extract tool has fixed this behavior.



MORE INFORMATION
The files in the Query Extract tool have the following file names, sizes, and dates:

Smsextract.mdb      454,656        3/18/99 Smsextract.xls      175,104        3/18/99 Smsextract.xlt      175,104        3/18/99 NOTE: Some files may have dates that are later than the preceding file dates.

Additional query words: prodsms, ACCESS, EXCEL

Keywords: kbbug kbcollections kbenv kbfix kbreport kbserver kbsmsadmin kbsmsutil KB254347

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.