Custom Alert Query

eem4osg

How would write this Custom Alert Query

SELECT
CP.Name
,A.NAME AS [Application Name]
,N.Caption AS [Node Name]
,N.IP_Address AS [IP Address]
,NP.OSG_Company AS [Business Unit]
,CCS.ErrorMessage AS [Error Message]
,ACP.Application_EverView_BU
,ACP.EverView_Application_Responsibility_Group
,ACP.Application_Severity
,ACP.OSG_Application_Product_Resource_Group

FROM Orion.APM.Application A

JOIN Orion.Nodes N
ON N.NodeID = A.NodeID
JOIN Orion.NodesCustomProperties NP
ON NP.NodeID = A.NodeID
JOIN Orion.APM.Component CP
ON CP.ApplicationID = A.ApplicationID
JOIN Orion.APM.CurrentComponentStatus CCS
ON CCS.ComponentID = CP.ComponentID
JOIN Orion.APM.ApplicationCustomProperties ACP
ON ACP.ApplicationID = A.ApplicationID

Where CP.ComponentType = 9 and CCS.ErrorCode = 33

Seashore

By the query it looks like you want to alert if a Windows Service is down. Then you can just do like this:

All the node data and application custom properties are not relevant here as they are not anywhere in the where part. They can be inserted later in the alert action if that info should be included.