SolarWinds THWACK
THWACK
  • Sign In
  • Search
  • Product Forums
    • Observability
      • SolarWinds Observability
      • Hybrid Cloud Observability
      •  
      • New on THWACK 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
    • New on THWACK 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
      • Mission: Survival Kit
      • 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 Team Summary Dashboard
  • Tags
  • More
  • Cancel
Options
  • View all
  • Previous
  • Next
  • View slideshow
  • More
  • Cancel
fileName

Team Summary Dashboard

This is the Dashboard template I use for 'Team' landing pages. I add to the SWQL in each widget a custom property filter that limits the results to the things the team cares about. My property is name 'Support_Group' so I add a Where statement (or add to it) like the line below.

Where N.CustomProperties.Support_Group like 'Team Name'

The Active Alerts is shamelessly borrowed from the_ben_keen and KMSigma because theirs was better than mine.

The Events are filtered to show Down events or restarts for devices, interfaces, or applications.

Use the scripts at: Importing/Exporting Modern Dashboards - Orion SDK - The Orion Platform - THWACK (solarwinds.com) to import the file. KMSigma has good instructions there how to use it.

  • Orion 2020.2.6
  • Server & Application Monitor (SAM)
  • Network Performance Monitor (NPM)
jm_sysadmin
jm_sysadmin
  • 10 Nov 2021
  • 250 Downloads
  • Share
  • More
  • Cancel
Anonymous

Top Comments

  • KMSigma
    KMSigma over 1 year ago +1

    I think that's what I like so much about Modern Dashboards.  Import them and totally "steal" widgets from other dashboards to craft your own.

  • dustin.wooldridge
    dustin.wooldridge over 1 year ago in reply to kevin.138

    Try this? I just added WHERE N.caption like '%ISE%' so it pulls any node name that contains ISE and it works for me
     

    SELECT
    
    	 N.caption AS [Server Name]
    	, n.Status AS [Server Status]
    	, n.detailsurl as [_linkfor_Server Name]
    	, N. IP_address
    	, CPULOAD AS [CPUStatusIcon]
    	, n.PercentMemoryUsed AS [MemoryUsed]
    	, n.ResponseTime
    	, n.PercentLoss AS [Packets Loss]
    
    FROM orion.nodes n 
    
    	LEFT JOIN (SELECT count(NodeID) as [CPU Count], nodeid 
     FROM Orion.CPUMultiLoadCurrent 
     GROUP BY nodeid) cpu on cpu.nodeid=n.nodeid
     WHERE N.Caption LIKE '%ISE%'

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • kevin.138
    kevin.138 over 1 year ago in reply to kevin.138

    So figured out that I could just add a WHERE statement to the bottom of the query and filter using NodeID. But I also wanted to try to figure out how to add an additional column to my chart from a different table. In this case, I'd like to add the Availability percent for the node as well. Any help with this would be greatly appreciated. 

    SELECT
    
    	 N.caption AS [Server Name]
    	, n.Status AS [Server Status]
    	, n.detailsurl as [_linkfor_Server Name]
    	, N. IP_address
    	, CPULOAD AS [CPUStatusIcon]
    	, n.PercentMemoryUsed AS [MemoryUsed]
    	, n.ResponseTime
    	, n.PercentLoss AS [Packets Loss]
    
    FROM orion.nodes n 
    
    	LEFT JOIN (SELECT count(NodeID) as [CPU Count], nodeid 
     FROM Orion.CPUMultiLoadCurrent 
     GROUP BY nodeid) cpu on cpu.nodeid=n.nodeid
     WHERE NodeID = 34 OR NodeID = 56

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • kevin.138
    kevin.138 over 1 year ago in reply to kevin.138

    Sorry, I accidentally hit enter before finishing. I took the SWQL from the widget on the dashboard and tried to add something like WHERE DisplayName LIKE %'ISE%', but no matter where I put it, the query doesn't run and return any results. If someone could possibly explain how to edit the SWQL below to only return servers with a specific name, I would greatly appreciate it. Thanks!

    SELECT
    
    	 N.caption AS [Server Name]
    	, n.Status AS [Server Status]
    	, n.detailsurl as [_linkfor_Server Name]
    	, N. IP_address
    	, CPULOAD AS [CPUStatusIcon]
    	, n.PercentMemoryUsed AS [MemoryUsed]
    	, n.ResponseTime
    	, n.PercentLoss AS [Packets Loss]
    
    FROM orion.nodes n 
    
    	LEFT JOIN (SELECT count(NodeID) as [CPU Count], nodeid 
     FROM Orion.CPUMultiLoadCurrent 
     GROUP BY nodeid) cpu on cpu.nodeid=n.nodeid

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • kevin.138
    kevin.138 over 1 year ago

    So for the Server Performance Widget, How would I edit the SWQL Query to only show stats for Servers with the String 'ISE' in the DisplayName?

    • Cancel
    • Up 0 Down
    • Reply
    • More
    • Cancel
  • Vinx
    Vinx over 1 year ago in reply to jm_sysadmin

    oh yes true, it's because all my tests were "private"

    • 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.