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
Hi! Just fake a “time” column using SQL NOW() function.
SELECT NOW() as time ...
could make me a example? do i have to change it in My MSSQL Database or can i use the SQL-Code i posted?
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:
NOW() AS time,
CAST(nn.ComputerID AS NVARCHAR(36))[Computer ID],
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;
well… that would be to easy
i get the error : mssql : NOW is not recognizeed as the name of an integrated function
My bad) Try to use any of MSSQL’s date functions
GETDATE() instead of NEW()
well now i got the error , value column must have numeric datatype , column : ComputerName type : string value : …