LM alerts → Edwin AI → ServiceNow ticket reconciliation
Summary: Barb Ramirez created a GitHub repository to help users check if LogicMonitor alerts have corresponding ServiceNow incidents. The process involves exporting active alerts and incidents, running a lookup script, and resolving any discrepancies through specified steps. This solution offers visibility into alert management and helps address mismatches or missing incident links between platforms.
Ever wondered if all of your alerts in LM had an associated ServiceNow Incident;
https://github.com/bramirez12/EdwinAI
I have needed this visibility so i created this repo,
Step 1 — Export active alerts from LogicMonitor by running lm_active_alerts.py
Step 2 — Export ServiceNow incidents (with the exact columns needed) directly from ServiceNow as per ReadMe
Step 3 — Run the Edwin lookup with all flags explained and output columns described by running edwin_incident_lookup.py
Step 4 — How to resolve "Needs Manual Check" items using the CI/Object fallback in the Spreadsheet that was created
Step 5 — How to interpret the results (state mismatches, no incident linked, etc.) - re=trigger any alerts found with no matcing ServiceNow INC