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  and  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.  has good instructions there how to use it.

Anonymous
Parents
  • 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?

  • 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

  • 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

  • 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%'

Comment
  • 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%'

Children
No Data