Dashboard with only status for one or multiple specific Applications?

SalemTech

Example I want to only track the statis in a dashboard for one specific application not all of them since they want a single dashboard for each application to show case any help with this would be greatly appreciated.

Her is the current code, but show for many servers and I only one or to be able to query one to many when needed..

SELECT N.TheCount
, CASE WHEN D.Link is null then NULL
ELSE CONCAT(D.Link,'?filters=', d.InstanceSiteId, '_Orion.Nodes_Status:eq:2')
END AS Link
FROM
(SELECT COUNT(1) as TheCount FROM Orion.Nodes WHERE Category=2 AND Status = 2) N
LEFT JOIN
(
SELECT TOP 1 InstanceSiteId, '/apps/platform/dashboard/' + TOSTRING(DashboardID) as Link
FROM Orion.Dashboards.Instances
WHERE DisplayName='Servers Summary - Server Status'
ORDER BY DashboardID
) D ON 1=1

SalemTech

Actually, to be more specific a group of applications or host with similar naming to query and get the status of them, so let's say there are 7 servers or nodes in the grouping and see their various status if that makes more sense?