This article is limited to guiding the user to connect to the SCCM db using the WBEMTEST utility, for the purpose of mocking the sms extractor functionality. The steps listed here may be used to troubleshoot data related issues and connectivity problems as initial route for investigation.
Using Wbemtest to run SMS extractor queries:
This will result in the utility console opening up, which looks like this:
Please note that the connection must be using ‘IWbemLocator[Namespaces]’ and must return ‘IWbemServices’ as highlighted above. These two options are typically by default, but must be cross checked by the user.
It is important to ensure that the namespace is entered correctly here. If the user is not aware of the correct namespace string, they may check the TRC_SMS_EX_*.log file and use the following highlighted substring from their logs:
The so copied query is pasted in the box provided in wbemtest.
Click on apply and the results will be displayed similar to the following:
NOTE: For running queries from within the SCCM console, kindly follow the MSDN article:
In case of issues where there are no results returned to specific queries of the SMS extractor, I recommend that the user follow the KB article listed above and run the queries from within the SCCM console to check to see if the data that is found missing by the SMS extractor indeed exists or not.