SQL Query Event Down Event Up

This website uses cookies. By clicking OK, you consent to the use of cookies. Click Here to learn more about how we use cookies.

Product Forums
Network Management
Systems Management
Database Management
- Database Performance Analyzer (DPA)
- Database Performance Monitor (DPM)
Application Management
- AppOptics
- Loggly
- Papertrail
- Pingdom
IT Security
IT Help Desk
Resources
Featured Resources
Featured Groups
Blogs
Contests & Missions
Guides
- Basics of Network Monitoring
- Server Management Basics
THWACK Tuesday Tips
- Triple-T Hub
Events
Online Events
- ON DEMAND: THWACKcamp 2019
- SolarWinds Lab
In-Person Events
Free Tools & Trials
Store

cancel

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Search instead for

Did you mean:

Create Post

THWACK
:
Network Performance Monitor (NPM)
:
NPM Discussions
:
SQL Query Event Down Event Up

Options

Subscribe to RSS Feed
Mark Topic as New
Mark Topic as Read
Float this Topic for Current User
Bookmark
Subscribe
Mute
Printer Friendly Page

contracer

Level 11

Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Email to a Friend
Report Inappropriate Content

‎03-10-2019 11:38 AM

SQL Query Event Down Event Up

Hi,

Please, I´m looking for a SQL query to show me all nodes that stayed down for at least 15 minutes and are up at least 60 minutes in the last 24 hours.

Node_Name Ip_Address Event_Down Event_Up Duration_of_Event_Up

Thanks in advance.

0 Kudos

All forum topics
Previous Topic
Next Topic

0 Replies

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab

About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials

Legal Documents Terms of Use Privacy California Privacy Rights Security Information