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

Best way to change LastBoot Time from UTC to EDT in a Dashboard.

I'm trying to use LastBoot in a query and it displays in UTC, how can I covert to my EDT? Do I just do the math and subtract 5 or is there a better SWQL way to do it?

Here is my current query:

SELECT TOP 20 NodeID, IPAddress, Caption, SysName, Status, PolledStatus, StatusLED, StatusDescription, StatusIcon, LastBoot, SystemUpTime, DetailsURL
FROM Orion.Nodes
WHERE vendor = 'Cisco' AND SystemUpTime <= 86400

I just want to display any device that rebooted in the last 2 days. I'm displaying by LastBoot Time but that is in UTC.

Thanks for any help.

Find more posts tagged with

Accepted answers

christopher.t.jones123

there is definetely an easier way to do it, if you add the tolocal() function to lastboot it will automatically convert it for you. It would look like this

tolocal(LastBoot) as [Last Boot Time]

Here's a screenshot from the OrionSDK article for functions

All comments

christopher.t.jones123

there is definetely an easier way to do it, if you add the tolocal() function to lastboot it will automatically convert it for you. It would look like this

tolocal(LastBoot) as [Last Boot Time]

Here's a screenshot from the OrionSDK article for functions

wanlanman

Thanks, that worked perfectly. I appreciate the quick response!

Steve

christopher.t.jones123

no prob, one thing I also wanna mention is that the documentation says that it will convert it to the time zone of the Orion Server, but it actually converts it to the time zone of the device that is running the query. I just tested it to confirm that. So someone at your Org running it from a device that is in MDT it will automatically convert it to MDT for them.