Anyone encountered macro SQL error when importing alerts in version 2025?

cgting

This query in alert message works in version 2023, but not in 2025. 

${SQL: SELECT CAST( CAST(('${N=Alerting;M=Downtime}') AS int) / 60 AS varchar) + ' hours '  + right('0' + CAST(CAST(('${N=Alerting;M=Downtime}') AS int) % 60 AS varchar(2)),2) + ' minutes'}

Reference: solarwindscore.my.site.com/.../Change-downtime-variable-from-minutes-to-hours

When importing alerts in version 2025 getting - "MACRO SQL ERROR - No column name was specified for column 1 of ---- "

 

Closest article I can find relating to Macro sql error: solarwindscore.my.site.com/SuccessCenter/s/article/Importing-Alerts-containing-SQL-fails-in-the-SolarWinds-Platform-2022-1-and-newer?language=en_US

Thanks,

Lofstrand

It's a bit picky on having all columns named in the output. In this case you don't have a column name and it complains about that.

Try add "AS T" at the end, just before the }
So the end is like this: 

+ ' minutes' AS T}