SolarWinds THWACK
THWACK
  • Sign In
  • Search
  • Product Forums
    • Observability
      • Observability Solutions
      • ⮩ SolarWinds Observability
      • ⮩ Hybrid Cloud Observability
    • The Orion Platform
      • Forum
      • Scalability Engines (HA, APE, AWS)
      • Enterprise Operations Console (EOC)
      • Orion SDK
      • Alert Lab
      • Report Lab
    • Network Management
      • Network Performance Monitor (NPM)
      • NetFlow Traffic Analyzer (NTA)
      • Network Configuration Manager (NCM)
      • IP Address Manager (IPAM)
      • User Device Tracker (UDT)
      • VoIP & Network Quality Manager (VNQM)
      • Log Analyzer
      • Engineer’s Toolset
      • Network Topology Mapper (NTM)
      • Kiwi CatTools
      • Kiwi Syslog Server
      • ipMonitor
    • Systems Management
      • Server & Application Monitor (SAM)
      • Virtualization Manager (VMAN)
      • Storage Resource Monitor (SRM)
      • Server Configuration Monitor (SCM)
      • SolarWinds Backup
      • Web Performance Monitor (WPM)
    • Database Management
      • Database Performance Analyzer (DPA)
      • SQL Sentry
      • Database Performance Monitor (DPM)
      • Database Mapper
      • Task Factory
    • Application Management
      • AppOptics
      • Loggly
      • Papertrail
      • Pingdom
      • DevOps
    • IT Security
      • Access Rights Manager (ARM)
      • Identity Monitor
      • Security Event Manager (SEM)
      • Patch Manager
      • Serv-U FTP & MFT
    • IT Service Management
      • SolarWinds Service Desk (SWSD)
      • Web Help Desk (WHD)
      • DameWare Remote Support (DRS)
      • DameWare Remote Everywhere (DRE)
      • DameWare Mini Remote Control (MRC)
  • Resources
    • THWACK Command Center
      • Command Center
      • How to THWACK
      • THWACKster Search
    • DevOps
    • What We're Working On
    • Blogs
      • Community Announcements
      • Product Blog
      • Monitoring Central
      • Geek Speak
      • The DevOps Blog
    • THWACK Tech Tips
    • Movies and Mainframes
    • Support
      • Success Center
      • Documentation
      • Submit a Support Ticket
      • Customer Portal
      • Renew Maintenance
    • Community Groups
      • New To THWACK
      • Federal & Government
      • User Experience
      • EMEA Group
      • Japan Group
      • All Community Groups
  • Events, Missions, & Musings
    • Events
      • THWACK Livecast
      • THWACK Livecast Archive
      • SolarWinds Lab
      • SolarWinds Lab Archive
      • THWACKcamp 2022
      • SolarWinds User Groups
      • SolarWinds Events Calendar
    • Missions & Contests
      • Monthly Mission: Collect & Connect
      • THWACK 101
    • Musings
      • Water Cooler
      • Geek Tank
      • IT Tech Jobs/Careers
      • Monitoring for Managers
    •  
      •  
  • Content Exchange
    • The Orion Platform
      • Alerts
      • Custom HTML
      • Custom Queries
      • Modern Dashboards
      • Reports
      • Scripts
    • Network Performance Monitor
      • Device Pollers
      • Universal Device Pollers (UnDP)
    • Network Configuration Manager
      • Config Change Scripts
      • Device Templates
      • Firmware Upgrade Templates
      • Policy Documents
    • Server & Application Monitor
      • API Pollers
      • Application Monitor Templates
    • Server Configuration Monitor
      • Policies
      • Profiles
    • Database Performance Analyzer
      • Custom Alerts
      • Custom Metrics
      • Custom Queries
    • SQL Sentry
      • Advisory Conditions
    • Web Help Desk
      • Style Sheets
  • Academy
    • Newsroom
    • Forums
      • Classroom Discussions
      • SolarWinds Certified Professional (SCP)
    • Training & Certification
  • Free Tools & Trials
  • Store
The Orion Platform
  • Content Exchange
The Orion Platform
Modern Dashboards Overall Node Availability (Last 7 Days)
  • Tags
  • More
  • Cancel
Options
  • View all
  • Previous
  • Next
  • View slideshow
  • More
  • Cancel
fileName
Sign in to Download

Overall Node Availability (Last 7 Days)

This is a breakdown of node availability by Nines as inspired by Uptime Report SQL query - Report Lab - The Orion Platform - THWACK (solarwinds.com)

  • Orion 2020.2.6
  • node availability
  • Network Performance Monitor (NPM)
KMSigma.SWI
KMSigma.SWI
  • 7 Mar 2022
  • 228 Downloads
  • Share
  • More
  • Cancel
  • Sign in to reply
  • KMSigma.SWI
    KMSigma.SWI over 1 year ago in reply to Prineel

    Please post questions like this in the Orion SDK Forum,

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
  • Prineel
    Prineel over 1 year ago in reply to Prineel

    KMSigma.SWI

    Tried to edit another table widget with the following, hope you can assist?

    SELECT n.Caption AS [Node Name]
    , n.IP AS [IP Address]
    , n.StatusDescription AS [Status Description]
    , n.DetailsURL AS [Node Details URL]
    , n.ResponseTime AS [Response Time]
    , n.PercentLoss AS [Packet Loss]
    FROM Orion.Nodes n
    WHERE n.ResponseTimeHistory.DateTime BETWEEN GETDATE() - 1 AND GETDATE() -- this is where you define your time period
    HAVING AVG(n.ResponseTimeHistory.Availability) > 99.5

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
  • Prineel
    Prineel over 1 year ago

    KMSigma.SWI thanks for this, works really well!

    Would really like to list the nodes which are for example less than 95% in a table widget if possible?

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
  • KMSigma.SWI
    KMSigma.SWI over 1 year ago in reply to nadim.khan

    Your above question should be in the Orion SDK Forum, but I'll answer it here.

    You are asking for the last 1 hour in the text, but your filter is for the last month, so I'm not sure what you want.  I don't have that particular custom property defined, so I've commented it out of my responses.

    Your original query is fine, if you want the availability of all 'network' devices over the last month.

    SELECT CONCAT(ROUND(AVG(Availability), 2), ' %' ) AS [Network]
    FROM Orion.ResponseTime AS [RT]
    WHERE MONTHDIFF([RT].ObservationTimestamp, GETDATE() ) = 1
    --and [RT].Node.CustomProperties.device_type ='network'

    But you are asking for the last hour.  For that you'd just need to change the WHERE clause to only give you the times between one hour ago and "now."

    SELECT CONCAT(ROUND(AVG(Availability), 2), ' %' ) AS [Network]
    FROM Orion.ResponseTime AS [RT]
    WHERE [RT].ObservationTimestamp >= AddHour(-1, GetDate())
    --and [RT].Node.CustomProperties.device_type ='network'
    if you actually wanted the last month, but broken down by hour, then it's:
    SELECT CONCAT(ROUND(AVG([RT].Availability), 2), ' %' ) AS [%Avail]
         , DATETRUNC('hour', [RT].ObservationTimestamp) AS [Day]
    FROM Orion.ResponseTime AS [RT]
    WHERE MONTHDIFF( [RT].ObservationTimeStamp, GETDATE() ) = 1
    -- and [RT].Node.CustomProperties.device_type ='network' -- <-- this is where you define your custom property filter.
    GROUP BY DATETRUNC('hour', [RT].ObservationTimestamp)
    ORDER BY DATETRUNC('hour', [RT].ObservationTimestamp) DESC
    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel
  • nadim.khan
    nadim.khan over 1 year ago

    Could you please help to get average availability for last hour based on custom properties

    --AVG availability
    SELECT
    concat(round(avg(Availability), 2), ' %' ) as Network
    FROM Orion.ResponseTime rt
    where
    monthdiff(datetime,getdate())=1 and rt.Node.CustomProperties.device_type ='network'

    • Cancel
    • Vote Up 0 Vote Down
    • Sign in to reply
    • More
    • Cancel

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 190,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 Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.