Series name lost in alert rule

Grafana Alerting
1

Hello everyone,

I am trying to create an alert rule for a query with three column series. time stamp, status and feedback.

In the alert output, the names of the columns are getting replaced with series 1 and series 2. there are more series and this is confusing. What am i doing wrong that is making the series name get lost?

CREATE TABLE #Tempt
    (timestamp datetime, 
    status INT, feedback INT
);

DECLARE @rounded_time_from DATETIME = DATEADD(MINUTE, DATEDIFF(MINUTE, 0, $__timeFrom()), 0);

INSERT INTO #Tempt
    (timestamp,
    status, feedback)

EXEC DCS.usc
    @rounded_time_from, $__timeTo(),
    '4016, 3005',
    15;

SELECT *
    
FROM #Tempt;
DROP TABLE #Tempt;

series
series1211×874 60.9 KB

Thank you in advance!

2

Found the solution. Not sure if this is the only way. But, I needed to add the names to the sql query itself.

In the last line instead of * after SELECT

SELECT
‘status’ AS service_name,
(SELECT TOP 1 status FROM #Tempt ORDER BY timestamp DESC) AS value
UNION ALL
SELECT
‘feedback’ AS service_name,
(SELECT TOP 1 feedback FROM #Tempt ORDER BY timestamp DESC) AS value;