Using PieChart Without a time Column

Grafana
1

Hello there , at the moment im trying to create a pie chart with the plugin , but for that the plugin wants a time column , that i dont have
is there any way to convert my code or to ignore that rule? i just want to use the pie chart to show the amount of updates or simple integers

Select CAST(nn.ComputerID AS NVARCHAR(36))[Computer ID], client.ComputerName , count(*) as [number Software] From oems_client_nn_software as nn
Left Join oems_client as client on client.ComputerID = nn.ComputerID
GROUP BY nn.ComputerID, client.ComputerName
2

Hi! Just fake a “time” column using SQL NOW() function.
SELECT NOW() as time ...

3

could make me a example? do i have to change it in My MSSQL Database or can i use the SQL-Code i posted?

4

You can use your sql-code posted above but with a little modification. Just add

NOW() as time

into your SELECT statement.
Something like this:

SELECT
  NOW() AS time,
  CAST(nn.ComputerID AS NVARCHAR(36))[Computer ID],
  client.ComputerName,
  COUNT(*) AS [number Software]
FROM oems_client_nn_software as nn
LEFT JOIN oems_client as client on client.ComputerID = nn.ComputerID
GROUP BY nn.ComputerID, client.ComputerName;
5

well… that would be to easy
i get the error : mssql : NOW is not recognizeed as the name of an integrated function

6

My bad) Try to use any of MSSQL’s date functions

For example:
GETDATE() instead of NEW()

7

well now i got the error , value column must have numeric datatype , column : ComputerName type : string value : …