Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SWQL script not working

Team,

To display events summary on the custom widgets as the Top 10 events should display in CST time zone, I have created the below script but its not working. Please someone help on this. Thanks

SELECT TOP 10
DATEADD(hour, -6, E.EventTime) AS [Time of Event],
E.EventTypeProperties.Name AS [Event],
E.Message AS [Message],
CONCAT('/NetPerfMon/images/Event-',
TOSTRING(E.EventType), '.gif') AS [_IconFor_Message]
FROM Orion.Events AS E
ORDER BY E.EventTime DESC;

-Kumar

Find more posts tagged with

SWQL

Accepted answers

Lofstrand

See https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions for all available functions in SWQL

All comments

Lofstrand

Hi @kumarsw

DateAdd is not working in SWQL. Here you can use "AddHour" instead.

But, if you are interested in converting the UTC time zone into your local time zone, it's easier to use "ToLocal()"

SELECT TOP 10

   ADDHOUR(-6, E.EventTime) AS [Time of Event],

   ToLocal(E.EventTime) AS [Local Time of Event],

   E.EventTypeProperties.Name AS [Event],

   E.Message AS [Message],

   CONCAT('/NetPerfMon/images/Event-',TOSTRING(E.EventType), '.gif') AS [_IconFor_Message]

FROM Orion.Events AS E

ORDER BY E.EventTime DESC;

Lofstrand

See https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions for all available functions in SWQL

kumarsw

Hi Lofstrand,

I've added your script and looks like its changed to the local time zone. Thanks for your reply!

will keep monitor for a day and let you know the results.

kumarsw

Hi Lofstrand,

============================================================================

SELECT TOP 10
ToLocal(E.EventTime) AS [Local Time of Event],
E.EventTypeProperties.Name AS [Event],
E.Message AS [Message],
CONCAT('/NetPerfMon/images/Event-',TOSTRING(E.EventType), '.gif') AS [_IconFor_Message]
FROM Orion.Events AS E
ORDER BY E.EventTime DESC;

==============================================================================

This script is working but not running to the local time of Orion Server ( As our server running in CST timezone)

what is the swql query to use in order to show time of event (date & time ) in CST timezone? please help out

Lofstrand

The function "ToLocal" converts the [Time] to local by the running application. For example if you run it in SWQL studio, it's local to where you run SWQL studio. If you run the query in a widget, it's local to that web browser.

(I think the explanation on the SWQL Functions web page is wrong here)