Cireson Analytics support more than just a select statement
Recently i started to create a dashboard to cater for our Hyper V Cluster patching progress, a lot of orchestrator run books and SCCM task sequences later we were able to automate the system health pre checks node drains, software update installations and Post health checks across 100's of clusters overnight but monitoring the overall job execution was a nightmare, so i created a dashboard that tracked the Orchestrator jobs that write custom information to a custom SQL Table to show the progress, which assisted greatly, however we then wanted to add a chart to show the overall success/still pending software update installation progress for that single plane of glass progress dashboard.
the SQL Query was used
this resulted in the error
ERROR [ 308]: Dashboard: Invalid query. Query must contain select statements only.
i needed to remove the
Case Statement which resulted in the dashboard showing only the Status Code of 0,1,2,3
whilst i can add the break down of the meaning of each status in the description it would be great if the analytics portal supported the CASE function
it would be great if we can add these types of SQL Query's to the analytics SQL widgets.
if anyone needs any more information let me know or have managed to work around this issue let me know