Options

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.

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

  • 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

  • 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

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

  • over 1 year ago in reply to jm_sysadmin

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

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.