We do API monitoring for an unsupported Container. In the message for our NOC and other personnel we need the Message in EOC alerts console or the MPE same same. to be specific and give the following info.
1. Severity
2. Node Name (Orion.Node.Caption)
3. Node custom Property Business_system
4. standard message
Issue: Caption, always puts out the same value example BOB-Container-id100.FQDN.COM. In reality the warnings we have should cover a handful of host name succh as
BOB-Container-id100.FQDN.COM
BOB-Container-id101.FQDN.COM
BOB-Container-id103.FQDN.COM
We are hoping to find the right quey that returns the correct hostname in the message.
Failed option queries:
1.
Severity - ${N=Alerting;M=Severity}
| Node: ${N=SWQL;M=SELECT V.Node.Caption AS APInode
FROM Orion.APIPoller.ValueToMonitor V
Where V.RelatedEntityID =V.Node.NodeID
AND V.Status ='3'
}
| Business System - ${N=SWQL;M=SELECT A.Node.CustomProperties.Business_System AS APIbs FROM Orion.APIPoller.ApiPoller A Where A.Name like '%- srvcl'}
| Message - "${N=SwisEntity;M=DisplayName}: ${N=SwisEntity;M=Metric}"
2.
Severity - ${N=Alerting;M=Severity}
| Node: ${N=SWQL;M=SELECT V.Node.Caption AS APInode
FROM Orion.APIPoller.ValueToMonitor V
Where V.RelatedEntityID =V.Node.NodeID
AND V.Status ='3'
}
| Business System - ${N=SWQL;M=SELECT A.Node.CustomProperties.Business_System AS APIbs FROM Orion.APIPoller.ApiPoller A Where A.Name like '%- srvcl'}
| Message - "${N=SwisEntity;M=DisplayName}: ${N=SwisEntity;M=Metric}"
This query works in SWQL:
SELECT Distinct N.Caption
FROM Orion.Nodes N
Where N.ApiPollers.RelatedEntityId = N.NodeID
AND N.ApiPollers.Status ='3'
IN SWQL studio this provides no results, adn no errors:
SELECT A.Node.Caption AS APInode
FROM Orion.APIPoller.ApiPoller A
Where (
A.Name like '%- srvcl'
AND A.Status ='3'
AND A.RequestDetails.ValueToMonitors.DisplayName = A.DisplayName
3.
Severity - ${N=Alerting;M=Severity}
| Node: ${N=SWQL;M=SELECT A.Node.Caption AS APInode FROM Orion.APIPoller.ApiPoller A Where A.Name like '%- srvcl'}
| Business System - ${N=SWQL;M=SELECT A.Node.CustomProperties.Business_System AS APIbs FROM Orion.APIPoller.ApiPoller A Where A.Name like '%- srvcl'}
| Message - "${N=SwisEntity;M=DisplayName}: ${N=SwisEntity;M=Metric}"
