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

Date format in the the solarwinds DB

what is the swql query to fetch the node metrics with in a specified dates. Can we change the dateformat while storing the metrics in the solarwinds db. right now it is yyyy-MM-dd HH:MM:ss.SSS format

Find more posts tagged with

Accepted answers

All comments

The date functions can be found on SolarWinds wiki for the OrionSDK here:

SWQL Functions · solarwinds/OrionSDK Wiki · GitHub

An example for interface traffic over the last 60 minutes would be this:

SELECT n.Caption, i.Caption, it.[DateTime], it.AveragebpsFROM Orion.Nodes nJOIN Orion.NPM.Interfaces i ON n.NodeID = i.NodeIDJOIN Orion.NPM.InterfaceTraffic it ON i.InterfaceID = it.InterfaceIDWHERE MINUTEDIFF(it.[DateTime], GETDATE()) <= 60

--

Steven W. Klassen

Programmer Analyst @ Loop1 Systems

http://www.loop1systems.com/

http://www.linkedin.com/in/mrxinu

Quick Links