I'm trying to set up a Table Widget on a Modern Dashboard that displays unmanaged nodes filtered by a specific group of users
If there are unmanaged nodes that belong to the group the table displays them fine, however when there are no unmanaged nodes the widget displays an ugly graphic
How are other people getting around this? The classic dashboards allowed you to hide empty resources.
Is there a trick I'm not aware of that would at least display a Zero or None instead of the graphic? Or should I dig for that graphic and replace it with one that says 'No Data'
Any ideas?
Select N.Caption,
TOLOCAL(N.UnManageFrom) AS UnManageFrom,
TOLOCAL(N.UnManageUntil) AS UnManageUntil,
TOLOCAL(AE.ObservationTimestamp) AS UnManagedWhen,
CASE
WHEN AE.AccountID LIKE '23246578' THEN 'bobmarley'
--WHEN AccountID LIKE '' THEN ''
--WHEN AccountID LIKE '' THEN ''
ELSE AE.AccountID
END AS [Name]
FROM Orion.Nodes N
LEFT JOIN (
SELECT A.NetworkNode, MAX(A.AuditEventID) AS AuditEventID,
count (1 ) as eventaudit
FROM Orion.AuditingEvents A
WHERE A.AuditingActionType.ActionType='Orion.NodeUnmanaged'
GROUP BY A.NetworkNode
) AE1 ON N.NodeID = AE1.NetworkNode
LEFT JOIN Orion.AuditingEvents AE ON AE1.AuditEventID=AE.AuditEventID
WHERE AE.AccountID NOT LIKE NULL AND n.customproperties.SupportGroup LIKE 'ServerEngineering'
ORDER BY UnManagedWhen DESC
