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

Question: Do you know why a SWQL query shows different values than the WEB console?

jjhj

I mean, to be more specific...

The EventTime column, and the Message column, is the same.
But the value in EventTime, "the time is different" ,

Thank you in advance for your comments.

Greetings

Find more posts tagged with

SWQL

npm

Events

SolarWinds Platform

Hybribid Cloud

Comments

stevenstadel

Some time events are shown in the SWQL studio in UTC, as that is how it is recorded in the database. The GUI shows it in your local time zone. If you want the same time in SWQL, use ToLocal(EventTime) as LocalEventTime for example.

jjhj

Thank you @stevenstadel now I see the correct form.

Look for more than what you mentioned, and if someone else sees this post, I leave a guide on the use of more functions, I hope it helps:

References: github.com/.../SWQL-Functions

Quick Links

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches