We recently made the decision to rebuild our Orion instance from scratch (new servers, fresh install, new SQL instance). We did export the custom alerts from our old instance (2022.4.1). One of the alerts was created by someone that is no longer with the company. When the alert is triggered, we do not receive the correct data.
The alert is triggered when an interface is running at 95% utilization for 15 minutes. In the Message body, this is the query that I don't know what needs to be corrected:
Received : ${SQL: SELECT CONVERT(NUMERIC(15,2),CONVERT(NUMERIC(15,2),(${N=SwisEntity;M=Inbps}))/1000000)} Mbps
Transmitted : ${SQL: SELECT CONVERT(NUMERIC(15,2),CONVERT(NUMERIC(15,2),(${N=SwisEntity;M=Outbps}))/1000000)} Mbps
This is the error when it is triggered:
Received : MACRO SQL ERROR - No column name was specified for column 1 of 'yv5mjfbt_hlk'. Mbps
Transmitted : MACRO SQL ERROR - No column name was specified for column 1 of 'mrvfyz0b_qy1'. Mbps
When the alert works, this is an example of what we are expecting to see:
Received : 9.52 Mbps
Transmitted : 7.07 Mbps
