nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

UTC time to local time

rkalidh

Hi,

Is there any way to get local time of alerts where triggereddatetime stored in UTC time zone . Am using swis query to get data, how to get it in local time zone.

Am using python . Pls suggest

Find more posts tagged with

Accepted answers

dan_jagnow

If you'd like to convert the timestamp in the results in SWQL, you can use the ToLocal function:

results1=swis.query("select ac.Name,ac.AlertMessage,ao.RelatedNodeCaption,case when ac.Severity=2 then 'Critical' else 'major' end as Severity,ToLocal(aa.TriggeredDateTime) as Alertime from Orion.AlertActive aa left outer join Orion.alertObjects as ao on aa.AlertObjectID=ao.AlertObjectID left outer join Orion.AlertConfigurations as ac on ac.AlertID=ao.AlertID where ac.Severity=2 and aa.TriggeredDateTime>='2019-02-01 00:00:00' order by aa.TriggeredDateTime desc")

All comments

dan_jagnow

Python has libraries that convert UTC to local time.

rkalidh

Hi,

Thanks for response. below is the query

results1=swis.query("select ac.Name,ac.AlertMessage,ao.RelatedNodeCaption,case when ac.Severity=2 then 'Critical' else 'major' end as Severity,aa.TriggeredDateTime as Alertime from Orion.AlertActive aa left outer join Orion.alertObjects as ao on aa.AlertObjectID=ao.AlertObjectID left outer join Orion.AlertConfigurations as ac on ac.AlertID=ao.AlertID where ac.Severity=2 and aa.TriggeredDateTime>='2019-02-01 00:00:00' order by aa.TriggeredDateTime desc")

TriggeredDateTime is in UTC time zone. How can i use python method to get ti converted, or is there any way to covert using SWQL functions itself.