I'm curious if anyone else has ran into this issue. I'm working on some modern dashboards and receive an error if I have a comment as the last line.
I'm trying to rig up a general home page template for our internal teams, that could be duplicated, and then just have to make some minor moidifications to the query itself (filtering off of custom properties). I'd like to leave the comment line in there, at the bottom to try and speed up the process. During some tests I got around it by starting my Where clause with a 1 = 1 and ending with a 1 = 1.
Provided SWQL query is not valid. Details: RunQuery failed, check fault information. mismatched input '' expecting ')' in From clause
The query itself is pretty simplistic.
SELECT [N].Caption
, [N].DetailsUrl
, [N].Status
, CASE
When [N].StatusDescription like '%Node status is Warning, %' Then Replace ([N].StatusDescription, 'Node status is Warning, ', '')
When [N].StatusDescription like '%Node status is Critical, %' Then Replace ([N].StatusDescription, 'Node status is Critical, ', '')
When [N].StatusDescription like '%Node status is Down, %' Then Replace ([N].StatusDescription, 'Node status is Down, ', '')
Else [N].StatusDescription
END As Description
, [N].StatusIcon
, [N].CustomProperties.ResponsibleGroup
From Orion.Nodes [N]
Where 1 =1
And [N].Status != 1
And [N].Status != 9
-- And [N].CustomProperties.Email like '%Test%'
