Grafana-Dashboard does not show the correct Database-Count about sqlwatch HOT 4 OPEN

Thanks. I recall this issue but thought it was fixed. I'll look into it.

from sqlwatch.

I used the Json-Files from the Github-Repo here:
https://github.com/marcingminski/sqlwatch/tree/main/SqlWatch.Dashboard/Grafana
Is there a more current version?

from sqlwatch.

I just checked this in my test env, and the count is correct. Can you check if this view [dbo].[vw_sqlwatch_report_dim_database] returns the right databases, or let me see the results in CSV please?

And could you let me see results from this:

select *
from dbo.sqlwatch_meta_server s
outer apply (
	select *
	from [dbo].[vw_sqlwatch_report_dim_database] db
	where db.sql_instance = s.sql_instance
	and db.database_name = DB_NAME()
) dbs

from sqlwatch.

Attached you find the results of the SQLwatch_meta_Server query.
sqlwatch_meta.csv

from sqlwatch.