I would like a report that is based on the console query All Status Messages from a Specific System. I have tried to take the SQL Query from the smsprovider.log but with no luck. So there is where my SQL knowledge ends. Do any of you maybe already have this report or could help me create one?

• Edited by Mikael O Karlsson Monday, April 27, 2015 12:31 PM

Hi,

If you want to run WMI query, try SMS_StatMsgWithInsStrings, namespace root\sms\site_SITECODE