Alerts_-_Currently_Enabled.OrionReport

Audit Report for when your manager's ask about what alerts are active and what they do, who they email, etc.

I have joined from AlertDefinitions & AlertActions Tables...I learned this today as I did this, so Njoy as much as possible. Focus is on Enabled Alerts and the Email Action of the Alert.

Breakdown is as follows :

SELECT

ObjectType,

AlertName,

AlertDescription,

TriggerQuery,

ActionDefinitions.ActionType as ActionType,

ActionDefinitions.Title as Title,

ActionDefinitions.Target as Target,

ActionDefinitions.Parameter1 as AlertMsgTitle,

ActionDefinitions.Parameter2 as AlertMsg,

ActionDefinitions.Parameter3 as AlertEmailFrom

FROM [dbo].[AlertDefinitions]

left join ActionDefinitions on (AlertDefinitions.AlertDefID = ActionDefinitions.AlertDefID)

where (enabled = 'True' and ActionType='Email')

order by enabled, ObjectType, AlertName, AlertDescription, TriggerQuery asc

Alerts_-_Currently_Enabled.OrionReport

Find more posts tagged with

enabled_alerts

Alert

audit_alert

audit

content_exchange

Accepted answers

All comments

jhandberg

It looks like this will take a little modifying to get it to work. I am getting an error "Source entity [dbo.AlertDefinitions] not found in catalog.

cahunt

I just tested this from the DB Manager and also the Web SQL Report setup. Both parse without issue.

Can you query from the db manager, or SSMS and tell me if it highlights a specific line for the issue?

Also this is what I am running on;

Orion Platform 2016.1.5300, WPM 2.2.1, IPAM 4.3.2, SRM 6.2.1, VNQM 4.2.3, NCM 7.5, NPM 12.0, DPA 10.0.1, PM 2.1, QoE 2.1.0, NTA 4.2.0, OFSMM 6.6.8, IVIM 2.1.2, UDT 3.2.4, SAM 6.2.4, NetPath 1.0

jhandberg

I will need to work at getting the DB Manager to connect for me. I have not been at this agency long enough to get the credentials to connect that tool. However, I tried both copying the downloaded file to the reports directory and the Web SQL report method. The copied file runs, but has no entries. The Web SQL gives me a query error on both our lab and production instances.

I have no training in SQL or SWQL, but I have the SWQL studio loaded and see the AlertDefinitions has a prefix. I didn't know if that was an issue or not.

Orion Platform 2016.2.100, WPM 2.2.1, IPAM 4.3.2, SRM 6.3.0, NPM 12.0.1, DPA 10.2.0, QoE 2.2.0, VIM 7.0.0, SAM 6.3.0, NetPath 1.0.1

cahunt

Open your DB Manager and click 'Add Default Server' and see if that works.. it should use the app's stored settings.

You can confirm your tables there, AlertDefinitions and ActionDefinitions. Then the columns, specifically AlertDefID the column this join is being done on.

Also,

In your Alert creation, click the edit, and confirm SQL is selected, and preview there to confirm data output. If that works, then save that and click the 'EDIT TABLE' button and make sure the columns are there.

Let me know how this turns out.