Dear All,
Based on that above alert rule:1 it only show device ID: but it doesn’t show the devices name, and location , Can you please assit me on that;
The message come like this:{Device Status UP/DOWN
Severity: critical
Timestamp: 2025-03-15 11:10:39
Unique-ID: 1249
Rule: Device Down! Due to no ICMP response. Faults:
#1: sysObjectID = .1.3.6.1.4.1.11.2.3.7.11.173; sysDescr = HP JL070A 2530-8-PoEP Switch, revision YB.16.02.0012, ROM YB.15.09 (/ws/swbuildm/rel_spokane_qaoff/code/build/ponds(swbuildm_rel_spokane_qaoff_rel_spokane)); location_id = 13;
Alert sent to:
}
Below is query:
SELECT * FROM devices WHERE (devices.device_id = ?) AND (devices.status = 0 && (devices.disabled = 0 && devices.ignore = 0)) = 1 AND devices.status_reason = “icmp”
So question which alert rule, I will use so that it will show me device name & location or device name, Any help will be great appreciated.
Kindest regards,
Elia Otito