SolarWinds Orion Platform Status Overview

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?

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.

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

No sure about highlighting but you could add a status symbol that if an alert is X days old a critical symbol can show next to the trigger time. 

How did you add this dashboard to your environment?