Assistance with Dashboard Widget and clickable value

spencerwaller

I have a widget on a dashboard i downloaded off here which is great.  How can i make these labels clickable to take me to said servers in warning state ?  I have tried a few things and cannot figure it out. Any help would be really appreciated

SELECT N.TheCount
, CASE WHEN D.Link is null then NULL
ELSE CONCAT(D.Link,'?filters=', d.InstanceSiteId, '_Orion.Nodes_Status:eq:3')
END AS Link
FROM
(SELECT COUNT(1) as TheCount FROM Orion.Nodes WHERE Category=2 AND Status = 3) 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

KMSigma.SWI

You need ALL of the Server or Network dashboards installed in your system.  The link is based on the other dashboards referenced therein.  It's explained in All in on Modern Dashboards