I am trying to make simple custom Table widget to show last 10 node downs and order them by the Triger time which was missing on the original widget that already exist in SW, I am getting this error when submitting my SWQL that shared below.
and how to change the Date and Time format and Time zone ?
Message I am getting :
SELECT
a.Caption AS [Name],
a.Status AS [Down],
a.DetailsUrl AS[URL],
a.LastSystemUpTimePollUtc AS[Date]
FROM Orion.Nodes a
WHERE (Status = 2)
GROUP BY a.Caption,
a.LastSystemUpTimePollUtc,
a.Status,
a.DetailsUrl
ORDER BY a.LastSystemUpTimePollUtc DESC
I really need advice for this matter and I am not so familiar with SQL .
