we are trying to display alerts from orion DB to influxDB. Which table from OrionDB will help us to achieve this?
Active Alert SWQL:
SELECT AlertActiveID, AlertObjectID, Acknowledged, AcknowledgedBy, AcknowledgedDateTime, AcknowledgedNote, TriggeredDateTime, TriggeredMessage, NumberOfNotes, LastExecutedEscalationLevel, DisplayName, Description, InstanceType, Uri, InstanceSiteId
FROM Orion.AlertActive
More info: Alerts · solarwinds/OrionSDK Wiki · GitHub