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

Custom SQL query display wrong time zone so need help on SQL query to change time zone in PST hours.

darshansdesai

We have created following scripts and working properly but I could not get correct time zone.

Could you please help me and provide me correct scrip with PST time zone?

Following scrip provide me 5:30 AM at this moment.

select

n.caption as [Device], n.DetailsURL as [_LinkFor_Device]

,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Device]

,n.IP_Address as [IP], n.DetailsURL as [_LinkFor_IP]

, Alerts.SuppressFrom as [Mute from], Alerts.SuppressUntil as [Mute Until]

from Orion.AlertSuppression AlertS

join Orion.nodes n on n.uri = AlertS.EntityURI

Find more posts tagged with

sql query

Accepted answers

stuartd

I'm no S(W)QL expert but would these help: https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions#datetime-functions

At first glance it looks to me like the following could work:

All comments

stuartd

I'm no S(W)QL expert but would these help: https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions#datetime-functions

At first glance it looks to me like the following could work:

bobmarley

Assuming that you are running from a machine in PST try this.

select

n.caption as [Device], n.DetailsURL as [_LinkFor_Device]

,'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Device]

,n.IP_Address as [IP], n.DetailsURL as [_LinkFor_IP]

, TOLOCAL (Alerts.SuppressFrom) as [Mute from], TOLOCAL (Alerts.SuppressUntil) as [Mute Until]

from Orion.AlertSuppression AlertS

join Orion.nodes n on n.uri = AlertS.EntityURI

darshansdesai

Thanks for the update. Above is same script what is different could you please update me ?.

darshansdesai

Thanks for the update. Above is same script what is different could you please update me ?.

darshansdesai

Can i copy paste and add on script or need to subs track or add anything from scrip which you have suggested.

stuartd

@bobmarley has added in the ToLocal which converts the time fields to your local time rather than the server time.

darshansdesai

Thanks for the update. I tried but no luck