MS SQL Server - WMI Event Alerts - SQL 2005, what is the excution environment looking for as a return ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

WMI Event Alerts - SQL 2005, what is the excution environment looking for as a return ?

steve

2006-11-30, 7:14 pm

I have started using WMI Event Alerts on SQL Server.
A simple example being :

Namespace : \\.\root\cimv2

Query:

SELECT * from __InstanceModificati
onEvent
WITHIN 30
WHERE
TargetInstance ISA 'Win32_Processor'
AND
TargetInstance.LoadPercentage > 80

My Question :
What is SQL server looking for from the query to determine if an alert
needs to be triggered. My interpretation from this simple script is :
If any row count is returned (ie SELECT * from ..) then the alert will
be fired.

Is this correct for all WMI Event Alerts ? Is that all it is ? ie
Rowcount returned > 0 ?

Thanks
s

Sponsored Links