modern view volumes

Orionmaster

I have the following view which is fine, but I would like that in volumes it indicates an alarm of some disk that is alarmed and is shown in the table in the same row

SELECT TOP 10 n.IP_Address,n.NodeName,n.CPULoad,n.PercentMemoryUsed,aggSub1._count AS Orion_Volumes_Status_count 
FROM Orion.Nodes n 
LEFT JOIN ( 
 SELECT i.NodeID,i.InstanceSiteId 
 , count(i.Status) AS _count FROM Orion.Volumes i
 GROUP BY i.NodeID,i.InstanceSiteId
) aggSub1 ON aggSub1.NodeID=n.NodeID AND aggSub1.InstanceSiteId=n.InstanceSiteId 
WHERE (IP_Address LIKE '%')

SteveK

So for our teams I ended up seperating out to different widgets.  Most of our teams just want to know if stuff is over threshold, so instead of returning back a list of all nodes and their general stats, I just return back rows that have exceeded threshold for the specific widget (CPU, Memory, etc...).

I went ahead and included what I did for our volumes (removed the custom properties piece that I use to limit the view).

With the columns presented, the widget is setup using:
Node - Orion Entity - using Node_Status, Node_DetailsURL, Node_Caption
Volume - Orion Entity - Using Status, DetailsURL, Caption
GB_Remaing - no format - VolumeSPaceAvbailable
%_Available - Simple Number - VolumePercentAvailable

SELECT [V].Caption
    ,[V].DetailsUrl
    ,[V].Type
    ,Round([V].VolumePercentAvailable, 2) AS VolumePercentAvailable
    ,Round (([V].VolumeSpaceAvailable/(1073741824)), 2) AS VolumeSpaceAvailable
    ,[V].Status
    ,[V].StatusIcon
    ,[V].Node.Caption AS Node_Caption
    ,[V].Node.DetailsUrl AS Node_DetailsUrl
    ,[V].Node.Status AS Node_Status
FROM Orion.Volumes [V]
    LEFT OUTER JOIN Orion.VolumesThresholds [T] on [V].VolumeID = [T].InstanceId
WHERE [V].Node.Unmanaged != 'True'
    AND ([V].VolumePercentUsed > [T].Level1Value
        OR [V].VolumePercentUsed > [T].Level2Value)
ORDER BY [V].VolumePercentAvailable

You could also do one for iOPS if needed