Dick Pluim
Dick Pluim
I gave up on this months ago. It was installed but had/have an automation to check if the connection is still present. But the integration is constantly giving problems. I...
I decided to give it another try. On the developer-site of Honeywell I removed the old app, created a new one. Put the client id and secret key in secrets.yaml,...
I have the same again. Also found out that the Honeywell-app has a new name Residio.
Following query would give the correct sort order in the dashboard: select [sql_instance], [Checks] = max(case when last_check_status = 'OK' then 0 when last_check_status = 'WARNING' then 1 when last_check_status...
After testing and trying I came up with the following: create view dbo.vw_sqlwatch_grafana_overview as SELECT [servername] FROM (select top 1000 [sql_instance] as servername, [Checks] = max(case when last_check_status = 'OK'...
Still have to figure out one issue: the autorefresh doesn't refresh the query so after a refresh the color-order might be different again. Pressing F5 solves this then.
Filed https://github.com/grafana/grafana/issues/44889 for this. See what comes out of it.
Update: I'm moving stuff from DickUMCG to my other account and will close the other one. Inconvenient to use 2 accounts. Forked repository has also been transferred.
Another thing. Discovered now that in the repository database there were about 170 tables named _DUMP_20220201_timestamp_server_tablename . Had to remove those manually (fortunately with one statement :-) ).
@marcingminski but shouldn't the index-definitions be changed to prevent this?