Hi Guys,
I've got the following SQL query which works in Orion Database Manager:
SELECT * FROM [dbo].[CPUMultiLoad_Current] where nodeid in (1646,1647,1645,1663,1666,1684,1670,1671,1672,1696,1673,1674,1675,1697,1690,1691,1652,1653,1654,1678,1687,1655,1656,1658,1679,1688,1677) and AvgLoad >90
This query tells me when one of the CPU's within my McAfee Web Gateways has hit over 90% utilisation. However, when I go to create an alert based on the above, I can't seem to be able to select that table to base a query on? I go to Trigger Conditions and then alert on Custom SQL Alert, select SQL condition as Node, but then the tables it uses are
SELECT Nodes.Caption, Nodes.NodeIE FROM Nodes.
So how do I go about alerting against the required tables for my query?
Thanks in advance.