Query Output Transformation

Grafana MSSQL
1

Grafana Version: 11.2.0

I have connected Microsoft SQL server as a datasource. I have a query and the output is displayed in Table in 3 columns.

I want to replace the data fields in one column based on certain matching criteria.

Basically, I want to replace, all fields with in 2nd column containing ““SystemCenter”” to " Windows Server" and “Unix” to “Linux Server”

I tried regex transform, but it is not working. Kindly assist on the same.

grafanas
grafanas718×211 37.8 KB

Regards
Fadil

2

check out the grafana play site for some regex examples:

https://play.grafana.org/d/M7q9kvPMz/renamy-by-regex?from=now-6h&to=now&refresh=&editPanel=2&tab=transformations

https://play.grafana.org/d/3sevWaU7z/multiple-regex-value-mappings?from=now-30d&to=now&refresh=&editPanel=2