Hello, I have a widget showing alerts and alert times with a link to acknowledge. But I cannot get the date format to display in the DDMMYY HH:MM:SS format, it defaults to MMDDYY. My query is below, everywhere else in solarwinds, the date is displayed DDMMYY just how I want it.
SELECT
o.AlertConfigurations.Name AS [ALERT NAME]
,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME]
,o.EntityCaption AS [ALERT OBJECT]
,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT]
,o.RelatedNodeCaption AS [RELATED NODE]
,o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE]
,ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME]
,o.AlertActive.TriggeredMessage AS [ALERT MESSAGE]
,CASE
WHEN o.AlertConfigurations.Severity = 0 then 'Informational'
WHEN o.AlertConfigurations.Severity = 1 then 'Warning'
WHEN o.AlertConfigurations.Severity = 2 then 'Critical'
WHEN o.AlertConfigurations.Severity = 3 then 'Serious'
WHEN o.AlertConfigurations.Severity = 4 then 'Notice'
END AS [Severity]
, o.AlertActive.Acknowledged
, o.AlertActive.AcknowledgedBy
, o.AlertActive.AcknowledgedDateTime
, o.AlertActive.AcknowledgedNote
, 'Click To Acknowledge' as [AcknowledgeIt]
, '/Orion/Netperfmon/AckAlert.aspx?AlertDefID='+tostring(o.AlertObjectID) AS [_linkfor_AcknowledgeIt]
FROM Orion.AlertObjects o
WHERE o.AlertActive.TriggeredMessage <> ''
AND o.AlertConfigurations.Severity = 2
-- AND o.AlertActive.TriggeredDateTime >= AddDay(-7, GETUTCDATE())
--Uncomment below for only alerts that have been acknowledged
-- AND o.AlertActive.Acknowledged IS NULL
ORDER by o.AlertActive.TriggeredDateTime DESC
Here's the screenshot of how I format it as a datetime, and choose the compact format, and the left of the screenshot shows what I get.
My chrome browser is set to UK language, my PC is set to uk region etc... and MS Edge is also set to UK, and both browsers show it as the US format.
I have no idea how to fix it, could someone please help?
many thanks
Nick
