Total poll count of servers or objects by color or nodes.....

SalemTech

Code to get a color status, but I want it for a select number of servers and or specific nodes no tall

SELECT
--NodeID as id,
DisplayName as NodeName,
Status as NodeStatus,
VendorIcon as NodeVendor,
DetailsUrl as NodeUrl,
CASE
WHEN Status = 1 THEN 'green'
ELSE 'default_color'
END as color
FROM Orion.Nodes

WHERE (DisplayName LIKE '%%') ((This area I can find the systems, but they display the text and what I want is a count if they are GREEN Only and show how many there are

Thanks for any help with this

Deltona

SELECT
--NodeID as id,
DisplayName as NodeName,
Status as NodeStatus,
VendorIcon as NodeVendor,
DetailsUrl as NodeUrl,
CASE Status
WHEN 1 THEN '<b><p style="color:green">Nice one!</p></b>'
ELSE ToString(Status)
END as [Status]
FROM Orion.Nodes