SWQL UTC TO GMT +5 CONVERSION

Question

Guys,

I need to know the query to convert utc timings into gmt +5 in swql for lastboot column in nodes table. In sql management studio, it's very easy however i am unable to do the same in swql.

Any help will be highly appreciated.

Regards,

Mike.

antonis.athanasiou · Accepted Answer

Hi,

Something like that?

SELECT NodeID, Caption, ChangeTimeZone(LastBoot,'+05:00') as LastBoot_5FROM Orion.Nodes

There are some helpful examples here:

Orion SWQL, Thwack! Now I got it

Antonis Athanasiou

Prosperon - UK SolarWinds Partners

Installation | Consultancy | Training | Licenses