SolarWinds THWACK
THWACK
  • Sign In
  • Search
  • Product Forums
    • Observability
      • SolarWinds Observability
      • Hybrid Cloud Observability
      •  
      • DevOps
    • 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
      •  
      • New on THWACK 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
    • DevOps
    • What We're Working On
    • Blogs
      • Community Announcements
      • Product Blog
      • Monitoring Central
      • Geek Speak
      •  
      • New on THWACK DevOps
    • THWACK Tech Tips
    • TechPod
    • 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
  • Events, Missions, & Musings
    • Events
      • THWACK Livecast
      • THWACK Livecast Archive
      • SolarWinds Lab
      • SolarWinds Lab Archive
      • THWACKcamp 2022 On Demand
      • SolarWinds User Groups
      • SolarWinds Events Calendar
    • Missions & Contests
      • Monthly Mission: What Killed Your Productivity?
      • 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
    • 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
  • More
The Orion Platform
Modern Dashboards SolarWinds Orion Platform Status Overview
  • Tags
  • More
  • Cancel
Options
  • View all
  • Previous
  • Next
  • View slideshow
  • More
  • Cancel
fileName

SolarWinds Orion Platform Status Overview

SolarWinds Orion Admin Dashboard

Purpose

To show Monitoring Engineers/Admins a high-level overview of what is happening within their monitoring environment.

Custom Properties Required

  • None

Orion Platform Version:

  • 2020.2.6 or higher

Features

  • Overall Environment Summary
  • Highest NPM/SAM Usage Percentage
  • Poller Information Status and Performance details
  • Quick Credential Lookup
  • Polling details
  • Alert History and Details
  • Nodes/Volumes/Interfaces with Polling issues details
  • Polling Intervals
  • Quick Custom Threshold Lookup

Contributors

  • jm_sysadmin
  • KMSigma

How to add the dashboard

  • Download the JSON file and then you can refer to this article from KMSigma on how to import the JSON.

Special Notes

  • Some of the widgets link out to other Modern Dashboards such as the Alert Dashboard which can be found on this content exchange as well.

Version History

Version Date Changes/Updates
1.0 2021-10-28 Initial Release
2.0 2021-11-09
  • New layout
  • New Alert Widget allows you to acknowledge the alert directly from the widget
  • Improved "Noisy Alert" widgets
2.5 2021-12-22
  • Updated URL links to make use within any environment better
  • Add Number of Alerts by Severity KPI Widget
  • Improved date display on "Alerts per Day" widget to only show Month and Year rather than a long timestamp.
  • Orion Status
  • Orion 2020.2.6
  • Server & Application Monitor (SAM)
  • Network Performance Monitor (NPM)
the_ben_keen
the_ben_keen
  • 28 Oct 2021
  • 494 Downloads
  • Share
  • More
  • Cancel
Anonymous

Top Comments

  • ecklerwr1
    ecklerwr1 over 1 year ago +1

    This looks pretty good I think.

  • MathieuJM
    MathieuJM 10 months ago in reply to dilbert1234 +1

    i had the same issue and i have changed the first join in the query 

    from

    LEFT JOIN Orion.NodeSettings ns ON n.NodeID = ns.NodeID and ns.SettingName like '%Credential%'

    to

    LEFT JOIN Orion.NodeSettings…

  • MathieuJM
    MathieuJM 10 months ago in reply to dilbert1234

    i had the same issue and i have changed the first join in the query 

    from

    LEFT JOIN Orion.NodeSettings ns ON n.NodeID = ns.NodeID and ns.SettingName like '%Credential%'

    to

    LEFT JOIN Orion.NodeSettings ns ON n.NodeID = ns.NodeID and ns.SettingName like '%Credential%'  and ns.SettingName not like '%InvalidCertificatesAccepted%'

    • Cancel
    • Up +1 Down
    • Reply
    • More
    • Cancel
  • fredz
    fredz 10 months ago

    Excellent, thank you very much.

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • stuartd
    stuartd 11 months ago

    Loving this dashboard but having a little issue with it that I'm hoping one of you / someone could advise on...

    The 'Orion Node Performance' widget works, but only shows 5 of our 14 active servers. I say active as not overly bothered if it doesn't show the state of the HA boxes, although it would make sense to have those here as well.

    So I've edited the code in the widget to remove reference to DPA as we don't have it. Other than that it is stock code but for completeness sake looks like:

    SELECT
    ---names server role within SolarWinds Environment---
    CASE
    	WHEN serv.HostName IS NOT null THEN serv.ServerType
    	WHEN e.ip IS NOT null THEN e.ServerType
    	WHEN env.SQLServer IS NOT null THEN 'SQL Database'
    --	WHEN dpa.DisplayName IS NOT null THEN 'DPA Server'
    	WHEN vm.settingvalue IS NOT null THEN 'VMAN'
    	WHEN pm.settingvalue IS NOT null THEN 'Patch Manager'
    	ELSE ''
    END AS [Server Type]
    	, caption AS [Server Name]
    	, n.Status AS [Server Status]
    	, n.detailsurl as [_linkfor_Server Name]
    	, IP_address
    	, CPULOAD AS [CPUStatusIcon]
    	, n.PercentMemoryUsed AS [MemoryUsed]
    	, n.ResponseTime
    	, n.PercentLoss AS [Packets Loss]
    
    FROM orion.nodes n 
    	LEFT JOIN orion.OrionServers serv on n.nodeid like serv.nodeid --or serv.hostname like n.caption 
    	LEFT JOIN orion.engines e on n.IP_Address = e.IP 
    	LEFT JOIN orion.Environment env on env.SqlServer like n.Caption + '%' or n.caption like env.sqlserver + '%' or env.sqlserver like n.ip_address+',%\%' or env.sqlserver like n.ip_address 
    --	LEFT JOIN orion.dpa.DpaServer dpa on dpa.displayname like n.Caption+'%' or dpa.displayname like '%'+n.IP_Address+'%' 
    	LEFT JOIN orion.WebSettings pm on pm.SettingName='PM-DataGridServerHost' and pm.SettingValue = n.IP 
    	LEFT JOIN orion.WebSettings vm on vm.SettingName='VManAddress' and vm.SettingValue = n.IP_Address 
    	LEFT JOIN (SELECT count(NodeID) as [CPU Count], nodeid 
    FROM Orion.CPUMultiLoadCurrent 
    
    GROUP BY nodeid) cpu on cpu.nodeid=n.nodeid 
     
    WHERE 
    	serv.HostName is not null 
    	OR e.ip is not null 
    	OR env.SqlServer is not null 
    --	OR dpa.DisplayName is not null 
    	OR vm.settingvalue is not null 
    	OR pm.settingvalue is not null

    If I just run a default query against Orion.OrionServers I get all of my servers. 

    As a matter of fiddling, I also removed the LEFT in the join for orionservers and that gives me zero results but if I make it a FULL JOIN it shows me 20 results - so my 14 servers plus 6 NULL entries in server name but the IP is right.

    Oh, and my SQL DB never shows up whatever.

    Any ideas please?

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • dilbert1234
    dilbert1234 over 1 year ago

    This is great but I have an error. Can someone help. There seems to be a syntax problem with one of my credentials that is being pulled. RunQuery failed, check fault information. Conversion failed when converting the nvarchar value 'SN:00CD19F05316AC5CCB;Issuer:E=support@paloaltonetworks.com, CN=localhost, OU=Support, O=Palo Alto Networks, L=Santa Clara, S=CA, C=US' to data type int.

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • dilbert1234
    dilbert1234 over 1 year ago

    Love the dashboard but I am getting an error hopefully comeone can help with.

    • Cancel
    • Up 0 Down
    • 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.