Active alerts report

Hi,

I need create an active alerts report, but my report doesn´t show nothing,

am I making any mistake ?

Find more posts tagged with

Hi,

this Active Alerts report shows only basic alerts. Fortunately, there's available workaround if you want to report advanced alerts:

1) Create new report, select Advanced SQL type.

2) Now you may entry SQL query to select desired columns. The table name in FROM clause is AlertStatus

3) Right now you may edit grouping and format as usual

Example:

This SQL would select Alert Name, time when it was triggered and Node Name

SELECT
AlertStatus.ObjectName as Node, AlertStatus.TriggerTimeStamp as Time, AlertDefinitions.AlertName

FROM
AlertStatus, AlertDefinitions

WHERE AlertDefinitions.AlertDefId=AlertStatus.AlertDefId

Have a nice day,

Adam

Hi,

this Active Alerts report shows only basic alerts. Fortunately, there's available workaround if you want to report advanced alerts:

1) Create new report, select Advanced SQL type.

2) Now you may entry SQL query to select desired columns. The table name in FROM clause is AlertStatus

3) Right now you may edit grouping and format as usual

Example:

This SQL would select Alert Name, time when it was triggered and Node Name

SELECT
AlertStatus.ObjectName as Node, AlertStatus.TriggerTimeStamp as Time, AlertDefinitions.AlertName

FROM
AlertStatus, AlertDefinitions

WHERE AlertDefinitions.AlertDefId=AlertStatus.AlertDefId

Have a nice day,

Adam

Back "in the day", I created this query which showed me all enabled basic alerts and who they were being sent to:

SELECT

Alerts.Alertname AS Alert_Name, Alerts.TriggerSubjectTemplate AS Trigger_Subject_Message, AlertActions.target AS Email_Addresses

FROM

Alerts INNER JOIN AlertActions ON (Alerts.AlertID = AlertActions.AlertID)

WHERE

Alerts.enabled = 1

I'm guessing this can still be done for Advanced alerts as well?