How to start a Monitoring Dashboard with Microsoft SQL Server

1

Hello Community , today i tried my first step to create a Monitoring Dashboard.
I think i successfully created my DataSource .
I created a Panel and upload my DataSource in it .

Test1
Test1936×314 40.4 KB

Now the problem is , why cant he “read” my data source? I think i have to chance something but i dont know what?
Maybe someone has an idea?

Thanks

2

What column type do the PatchID and ComputerID fields have?

3

u mean what datatype?

PATCHID = Uniqueidentifier
ComputerID = same as PatchID

4

uniqueidentifier is a GUID and not a string so think you need to convert it to a string.

5

cast(SpaltenName as nvarchar(38)) something like that?
CAST(nn.ComputerID AS NVARCHAR(36)) AS [ComputerID], client.computername
with this it worked somehow , but how can i get more plugins for visualisation?

6

There are some built-in visualizations but a lot of them will need the query result to be in time series format: https://grafana.com/docs/grafana/latest/features/datasources/mssql/#time-series-queries

If the built-in visualizations (Graph, bar gauge, gauge, heatmap, stat etc.) are not enough then there are lots of community plugins too: https://grafana.com/grafana/plugins?orderBy=weight&direction=asc

Here are some other resources for getting started:

7

So , grafana always tells me that it wants a column named " time "if i try use " Pie Chart " , could you somehow make an example how my DB should look like so that i can use Pie chart?

SELECT TOP (1000) [ComputerID]
,[SoftwareID]
,[Installed]
,[LastSeen]
,[InstanzID]
,[InstallSource]
FROM [OEMS].[dbo].[oems_client_nn_software]