Saturday, May 11, 2024 8:19:07 PM

Storage Home

Help

All Storage Objects

GROUPED BY Vendor

Widget is hidden on dashboard,
there is no data to show now.

Help

Storage Objects by Performance Risk

SELECT [_NetObjectPrefix], [_ObjectId], [Resource], [_IconFor_Resource], 
	                                    [Type], [_LinkFor_Resource], [Array], [_LinkFor_Array], [_IconFor_Array], [Latency], [IOPS], [Throughput], 
		                                [_IOPSError], [_LatencyError], [_ThroughputError], [_TotalErrors]
                                        FROM (
SELECT 'SMSP' AS [_NetObjectPrefix], [_ObjectId], [Resource], [_IconFor_Resource], 
	    'Storage Pool' AS [Type], 
	    [_LinkFor_Resource], 
		[Array], [_LinkFor_Array], [_IconFor_Array], 
		[Latency], [IOPS], [Throughput], 
        ISNULL(_IOPSError, 0) AS [_IOPSError], ISNULL(_LatencyError, 0) AS [_LatencyError], ISNULL(_ThroughputError, 0) AS [_ThroughputError],  
        ISNULL(([_IOPSError] + [_LatencyError] + [_ThroughputError]), 0) AS _TotalErrors
FROM  (
	SELECT PoolID as [_ObjectId], [StorageArrayId], [Resource], [_IconFor_Resource], [_LinkFor_Resource], [Throughput], [IOPS], [Latency], 
		SUM([_IOPSError]) AS [_IOPSError], SUM([_LatencyError]) AS [_LatencyError], SUM([_ThroughputError]) AS [_ThroughputError]
	FROM (
	  SELECT PoolID,
		 StorageArrayID as [StorageArrayId],
		 DisplayName as [Resource],
		 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Pools&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
		 DetailsUrl AS [_LinkFor_Resource],
		 BytesPSTotal AS [Throughput],
		 IOPSTotal AS [IOPS], 
		 IOLatencyTotal AS [Latency],
		 CASE WHEN Pools.IOPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN Pools.IOPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_IOPSError],
		 0 AS [_LatencyError],
		 0 AS [_ThroughputError]
	  FROM Orion.SRM.Pools
	  UNION ALL (
		SELECT PoolID,
			 StorageArrayID as [StorageArrayId],
			 DisplayName as [Resource],
			 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Pools&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
			 DetailsUrl AS [_LinkFor_Resource],
			 BytesPSTotal AS [Throughput],
			 IOPSTotal AS [IOPS], 
			 IOLatencyTotal AS [Latency],
			 0 AS [_IOPSError],
			 0 AS [_LatencyError],
			 CASE WHEN Pools.BytesPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN Pools.BytesPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_ThroughputError]
		FROM Orion.SRM.Pools
	   ))
	GROUP BY [PoolID], [StorageArrayId], [Resource], [_IconFor_Resource], [_LinkFor_Resource], [Throughput], [IOPS], [Latency] 
) PoolsThresholds
LEFT JOIN (
SELECT StorageArrayID, 
       DisplayName as [Array],  
       concat('/Orion/View.aspx?NetObject=SMSA:', StorageArrayID) AS [_LinkFor_Array],
       concat('/Orion/StatusIcon.ashx?entity=',
                CASE WHEN IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                ,'&status=', ISNULL(Status, 0)) AS [_IconFor_Array],
       TemplateID,
       PollerType
FROM Orion.SRM.StorageArrays
WHERE Unmanaged = FALSE 
) SA ON SA.StorageArrayID = PoolsThresholds.StorageArrayId WHERE SA.TemplateID NOT IN ('cd2bdf87-56a4-4918-bcf5-1d24433f0564') OR SA.PollerType IS NOT NULL UNION ALL ( SELECT 'SML' AS [_NetObjectPrefix], 
        L.LUNID AS [_ObjectId],
        L.DisplayName as [Resource],
        concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.LUNs&status=', ISNULL(L.Status, 0)) AS [_IconFor_Resource],
        'LUN' AS [Type], 
        L.DetailsUrl AS [_LinkFor_Resource],
	    [Array], [_LinkFor_Array], [_IconFor_Array], 
        L.IOLatencyTotal AS [Latency],
        L.IOPSTotal AS [IOPS],
        L.BytesPSTotal AS [Throughput],	                    
        ISNULL(_IOPSError, 0) AS [_IOPSError], ISNULL(_LatencyError, 0) AS [_LatencyError], ISNULL(_ThroughputError, 0) AS [_ThroughputError],  
        ISNULL(([_IOPSError] + [_LatencyError] + [_ThroughputError]), 0) AS _TotalErrors
FROM Orion.SRM.LUNs L
    LEFT JOIN (
        SELECT LUNID as [_ObjectId], SUM([_IOPSError]) AS [_IOPSError], SUM([_LatencyError]) AS [_LatencyError], SUM([_ThroughputError]) AS [_ThroughputError]
        FROM (
            SELECT LUNID,
			     CASE WHEN LUNs.IOPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN LUNs.IOPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_IOPSError],
			     0 AS [_LatencyError],
			     0 AS [_ThroughputError]
            FROM Orion.SRM.LUNs (nolock=true)
            WHERE LUNs.IOPSTotalThreshold.IsLevel2State = true OR LUNs.IOPSTotalThreshold.IsLevel1State = true
            UNION ALL (
                SELECT LUNID,
				    0 AS [_IOPSError],
				    CASE WHEN LUNs.IOLatencyTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN LUNs.IOLatencyTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_LatencyError],
				    0 AS [_ThroughputError]
				FROM Orion.SRM.LUNs (nolock=true)
	            WHERE LUNs.IOLatencyTotalThreshold.IsLevel2State = true OR LUNs.IOLatencyTotalThreshold.IsLevel1State = true
            ) UNION ALL (
                SELECT LUNID,
					0 AS [_IOPSError],
					0 AS [_LatencyError],
					CASE WHEN LUNs.BytesPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN LUNs.BytesPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_ThroughputError]
				FROM Orion.SRM.LUNs (nolock=true)
	            WHERE LUNs.BytesPSTotalThreshold.IsLevel2State = true OR LUNs.BytesPSTotalThreshold.IsLevel1State = true
			)
        ) GROUP BY [LUNID]
    ) LUNsThresholds ON L.LUNID = LUNsThresholds._ObjectId
LEFT JOIN (
SELECT StorageArrayID, 
       DisplayName as [Array],  
       concat('/Orion/View.aspx?NetObject=SMSA:', StorageArrayID) AS [_LinkFor_Array],
       concat('/Orion/StatusIcon.ashx?entity=',
                CASE WHEN IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                ,'&status=', ISNULL(Status, 0)) AS [_IconFor_Array],
       TemplateID,
       PollerType
FROM Orion.SRM.StorageArrays
WHERE Unmanaged = FALSE 
) SA ON SA.StorageArrayID = L.StorageArrayId WHERE SA.TemplateID NOT IN ('cd2bdf87-56a4-4918-bcf5-1d24433f0564') OR SA.PollerType IS NOT NULL ) UNION ALL ( SELECT [_NetObjectPrefix], 
         [_ObjectId], 
         [Resource], 
         [_IconFor_Resource], 
         [Type],
         [_LinkFor_Resource],          
         [Array], 
         [_LinkFor_Array], 
         [_IconFor_Array],
         [Latency], 
         [IOPS], 
         [Throughput], 
         ISNULL(_IOPSError, 0) AS [_IOPSError], ISNULL(_LatencyError, 0) AS [_LatencyError], ISNULL(_ThroughputError, 0) AS [_ThroughputError],  
         ISNULL(([_IOPSError] + [_LatencyError] + [_ThroughputError]), 0) AS _TotalErrors
 FROM (
        SELECT StorageArrayID AS [_ObjectId], 
                 DisplayName as [Resource], 
                 concat('/Orion/StatusIcon.ashx?entity=',
                        CASE WHEN sa.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                        ,'&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
                 DetailsUrl AS [_LinkFor_Resource],
                 'Storage Array' as [Type], 
                 DisplayName as [Array], 
                 concat('/Orion/View.aspx?NetObject=SMSA:', StorageArrayID) AS [_LinkFor_Array],
                 concat('/Orion/StatusIcon.ashx?entity=',
                        CASE WHEN sa.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                        ,'&status=', ISNULL([Status], 0)) AS [_IconFor_Array],
                 BytesPSTotal AS [Throughput],
                 IOPSTotal AS [IOPS], 
                 0 AS [Latency],
                 CASE WHEN sa.IOPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN sa.IOPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_IOPSError],
                 0 AS [_LatencyError],
                 CASE WHEN sa.BytesPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN sa.BytesPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_ThroughputError],
                 'SMSA' AS [_NetObjectPrefix],
                 TemplateID,
                 PollerType
        FROM Orion.SRM.StorageArrays (nolock=true) sa
        WHERE sa.Unmanaged = FALSE AND SA.TemplateID NOT IN ('cd2bdf87-56a4-4918-bcf5-1d24433f0564') OR SA.PollerType IS NOT NULL
) ) UNION ALL ( SELECT 'SMVS' AS [_NetObjectPrefix], [_ObjectId], [Resource], [_IconFor_Resource], 
	    'Vserver' AS [Type], 
	    [_LinkFor_Resource], 
	    [Array], [_LinkFor_Array], [_IconFor_Array], 
	    [Latency], [IOPS], [Throughput],
        ISNULL(_IOPSError, 0) AS [_IOPSError], ISNULL(_LatencyError, 0) AS [_LatencyError], ISNULL(_ThroughputError, 0) AS [_ThroughputError],  
        ISNULL(([_IOPSError] + [_LatencyError] + [_ThroughputError]), 0) AS _TotalErrors
FROM  (
SELECT VServerID as [_ObjectId], [StorageArrayId], [Resource], [_IconFor_Resource], [_LinkFor_Resource], [Throughput], [IOPS], [Latency], 
		SUM([_IOPSError]) AS [_IOPSError], SUM([_LatencyError]) AS [_LatencyError], SUM([_ThroughputError]) AS [_ThroughputError]
	FROM (
	  SELECT VServerID,
		 StorageArrayID as [StorageArrayId],
		 DisplayName as [Resource],
		 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.VServers&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
		 DetailsUrl AS [_LinkFor_Resource],
		 BytesPSTotal AS [Throughput],	                         
		 IOPSTotal AS [IOPS], 	                
		 0 AS [Latency],
		 CASE WHEN VServers.IOPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN VServers.IOPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_IOPSError],
		 0 AS [_LatencyError],
		 0 AS [_ThroughputError]
	  FROM Orion.SRM.VServers
	  UNION ALL (
		SELECT VServerID,
			 StorageArrayID as [StorageArrayId],
			 DisplayName as [Resource],
			 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.VServers&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
			 DetailsUrl AS [_LinkFor_Resource],
			 BytesPSTotal AS [Throughput],	                         
			 IOPSTotal AS [IOPS], 	                
			 0 AS [Latency],
			 0 AS [_IOPSError],
			 0 AS [_LatencyError],
			 CASE WHEN VServers.BytesPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN VServers.BytesPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_ThroughputError]
		FROM Orion.SRM.VServers
	   ))
	GROUP BY [VServerID], [StorageArrayId], [Resource], [_IconFor_Resource], [_LinkFor_Resource], [Throughput], [IOPS], [Latency] 
) VServersThresholds
LEFT JOIN (
SELECT StorageArrayID, 
       DisplayName as [Array],  
       concat('/Orion/View.aspx?NetObject=SMSA:', StorageArrayID) AS [_LinkFor_Array],
       concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Clusters&status=', ISNULL(Status, 0)) AS [_IconFor_Array],
       TemplateID,
       PollerType
FROM Orion.SRM.StorageArrays
WHERE Unmanaged = FALSE 
) SA ON SA.StorageArrayID = VServersThresholds.StorageArrayId WHERE SA.TemplateID NOT IN ('cd2bdf87-56a4-4918-bcf5-1d24433f0564') OR SA.PollerType IS NOT NULL ) UNION ALL ( SELECT 'SMV' AS [_NetObjectPrefix], [_ObjectId], [Resource], [_IconFor_Resource], 
	    'NAS Volume' AS [Type], 
	    [_LinkFor_Resource], 
		[Array], [_LinkFor_Array], [_IconFor_Array], 
		[Latency], [IOPS], [Throughput], 
        ISNULL(_IOPSError, 0) AS [_IOPSError], ISNULL(_LatencyError, 0) AS [_LatencyError], ISNULL(_ThroughputError, 0) AS [_ThroughputError],  
        ISNULL(([_IOPSError] + [_LatencyError] + [_ThroughputError]), 0) AS _TotalErrors
FROM  (
	SELECT VolumeID as [_ObjectId], [StorageArrayId], [Resource], [_IconFor_Resource], [_LinkFor_Resource], [Throughput], [IOPS], [Latency], 
		SUM([_IOPSError]) AS [_IOPSError], SUM([_LatencyError]) AS [_LatencyError], SUM([_ThroughputError]) AS [_ThroughputError]
	FROM (
	  SELECT VolumeID,
		 StorageArrayID as [StorageArrayId],
		 DisplayName as [Resource],
		 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Volumes&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
		 DetailsUrl AS [_LinkFor_Resource],
		 BytesPSTotal AS [Throughput],	                    
		 IOPSTotal AS [IOPS], 
		 IOLatencyTotal AS [Latency],
	     CASE WHEN Volumes.IOPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN Volumes.IOPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_IOPSError],
	     0 AS [_LatencyError],
	     0 AS [_ThroughputError]
	  FROM Orion.SRM.Volumes (nolock=true)
	  UNION ALL (
		SELECT VolumeID,
			 StorageArrayID as [StorageArrayId],
			 DisplayName as [Resource],
			 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Volumes&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
			 DetailsUrl AS [_LinkFor_Resource],
			 BytesPSTotal AS [Throughput],	                    
			 IOPSTotal AS [IOPS], 
			 IOLatencyTotal AS [Latency],
			 0 AS [_IOPSError],
			 CASE WHEN Volumes.IOLatencyTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN Volumes.IOLatencyTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_LatencyError],
			 0 AS [_ThroughputError]
		FROM Orion.SRM.Volumes (nolock=true)
	  ) UNION ALL (
		SELECT VolumeID,
			 StorageArrayID as [StorageArrayId],
			 DisplayName as [Resource],
			 concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Volumes&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
			 DetailsUrl AS [_LinkFor_Resource],
			 BytesPSTotal AS [Throughput],	                    
			 IOPSTotal AS [IOPS], 
			 IOLatencyTotal AS [Latency],
			 0 AS [_IOPSError],
			 0 AS [_LatencyError],
			 CASE WHEN Volumes.BytesPSTotalThreshold.IsLevel2State = true THEN 10 ELSE 0 END + CASE WHEN Volumes.BytesPSTotalThreshold.IsLevel1State = true THEN 1  ELSE 0 END AS [_ThroughputError]
		FROM Orion.SRM.Volumes (nolock=true)
	   ))
	GROUP BY [VolumeID], [StorageArrayId], [Resource], [_IconFor_Resource], [_LinkFor_Resource], [Throughput], [IOPS], [Latency] 
) VolumesThresholds
LEFT JOIN (
SELECT StorageArrayID, 
       DisplayName as [Array],  
       concat('/Orion/View.aspx?NetObject=SMSA:', StorageArrayID) AS [_LinkFor_Array],
       concat('/Orion/StatusIcon.ashx?entity=',
                CASE WHEN IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                ,'&status=', ISNULL(Status, 0)) AS [_IconFor_Array],
       TemplateID,
       PollerType
FROM Orion.SRM.StorageArrays
WHERE Unmanaged = FALSE 
) SA ON SA.StorageArrayID = VolumesThresholds.StorageArrayId WHERE SA.TemplateID NOT IN ('cd2bdf87-56a4-4918-bcf5-1d24433f0564') OR SA.PollerType IS NOT NULL
)
)
WHERE 1=1

Widget is hidden on dashboard,
there is no data to show now.

Help

Storage Objects by Capacity Risk

SELECT [_ObjectId], 
       [Resource],
       [_IconFor_Resource], 
       [_LinkFor_Resource], 
       [Type], 
       [Array], 
       [_LinkFor_Array],        
       '' AS [Last7Days],
       90 AS [Warning], 
       95 AS [Critical], 
       100 AS [ATCapacity], 
       [_TotalCapacity], 
       CASE WHEN [_UsedCapacityPercentage] > 100 THEN 100 ELSE [_UsedCapacityPercentage] END AS _UsedCapacityPercentage,
       [_CapacityRunoutOffset],
       [_CapacityRunoutSlope],
       [_IconFor_Array]
FROM (
	    SELECT LUNID AS [_ObjectId],
               DisplayName as [Resource], 
               concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.LUNs&status=', ISNULL(Status, 0)) AS [_IconFor_Resource],
               [DetailsUrl] AS [_LinkFor_Resource],
               'LUN' AS [Type], 
               LUNs.StorageArray.DisplayName as [Array],  
               LUNs.StorageArray.DetailsUrl AS [_LinkFor_Array],
               concat('/Orion/StatusIcon.ashx?entity=',
                                    CASE WHEN LUNs.StorageArray.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                                    ,'&status=', ISNULL(LUNs.StorageArray.Status, 0)) AS [_IconFor_Array],
               CapacityTotal AS [_TotalCapacity], 
	           ((CapacityAllocated * 1.0 / CapacityTotal) * 100) AS [_UsedCapacityPercentage],
               CapacityRunoutSlope AS [_CapacityRunoutSlope],
               CapacityRunoutOffset AS [_CapacityRunoutOffset]
        FROM Orion.SRM.LUNs (nolock=true)
        WHERE [Thin] = true
          AND [CapacityTotal] > 0
          AND LUNs.StorageArray.Unmanaged = FALSE

UNION ALL (

SELECT PoolID AS [_ObjectId], 
               DisplayName as [Resource], 
               concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Pools&status=', ISNULL(Status, 0)) AS [_IconFor_Resource],
               [DetailsUrl] AS [_LinkFor_Resource],
               'Storage Pool' as [Type], 
               Pools.StorageArray.DisplayName as [Array], 
               Pools.StorageArray.DetailsUrl AS [_LinkFor_Array], 
               concat('/Orion/StatusIcon.ashx?entity=',
                                    CASE WHEN Pools.StorageArray.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                                    ,'&status=', ISNULL(Pools.StorageArray.Status, 0)) AS [_IconFor_Array],
               CapacityUserTotal AS [_TotalCapacity], 
               ((CapacityUserUsed * 1.0 / CapacityUserTotal) * 100) AS [_UsedCapacityPercentage],
               CapacityRunoutSlope AS [_CapacityRunoutSlope],
               CapacityRunoutOffset AS [_CapacityRunoutOffset]
        FROM Orion.SRM.Pools (nolock=true)
        WHERE [Thin] = true
          AND [CapacityUserTotal] > 0
          AND Pools.StorageArray.Unmanaged = FALSE)

UNION ALL (

SELECT VolumeID AS [_ObjectId],
               DisplayName as [Resource],
               concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Volumes&status=', ISNULL(Status, 0)) AS [_IconFor_Resource],
               [DetailsUrl] AS [_LinkFor_Resource],
               'NAS Volume' as [Type], 
               Volumes.StorageArray.DisplayName as [Array],  
               Volumes.StorageArray.DetailsUrl AS [_LinkFor_Array],
               concat('/Orion/StatusIcon.ashx?entity=',
                                    CASE WHEN Volumes.StorageArray.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                                    ,'&status=', ISNULL(Volumes.StorageArray.Status, 0)) AS [_IconFor_Array],
               CapacityTotal AS [_TotalCapacity],
               ((ISNULL(CapacityFileSystem, 0) * 1.0 / CapacityTotal) * 100) AS [_UsedCapacityPercentage],
               CapacityRunoutSlope AS [_CapacityRunoutSlope],
               CapacityRunoutOffset AS [_CapacityRunoutOffset]
        FROM Orion.SRM.Volumes (nolock=true)
        WHERE [CapacityTotal] > 0
          AND Volumes.StorageArray.Unmanaged = FALSE)

UNION ALL (

SELECT StorageArrayID AS [_ObjectId], 
               DisplayName as [Resource], 
               concat('/Orion/StatusIcon.ashx?entity=',
                                    CASE WHEN sa.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                                    ,'&status=', ISNULL([Status], 0)) AS [_IconFor_Resource],
               [DetailsUrl] AS [_LinkFor_Resource],
               'Storage Array' as [Type], 
               DisplayName as [Array], 
               [DetailsUrl] AS [_LinkFor_Array],
               concat('/Orion/StatusIcon.ashx?entity=',
                                    CASE WHEN sa.IsCluster = true THEN 'Orion.SRM.Clusters' ELSE 'Orion.SRM.StorageArrays' END
                                    ,'&status=', ISNULL([Status], 0)) AS [_IconFor_Array],
               CapacityUserTotal AS [_TotalCapacity], 
               ((CapacityUserUsed * 1.0 / CapacityUserTotal) * 100) AS [_UsedCapacityPercentage],
               CapacityRunoutSlope AS [_CapacityRunoutSlope],
               CapacityRunoutOffset AS [_CapacityRunoutOffset]
        FROM Orion.SRM.StorageArrays (nolock=true) sa
        WHERE [CapacityUserTotal] > 0
          AND sa.Unmanaged = FALSE)

UNION ALL (
  SELECT VServerID AS [_ObjectId], 
               DisplayName as [Resource], 
               concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.VServers&status=', ISNULL(Status, 0)) AS [_IconFor_Resource],
               [DetailsUrl] AS [_LinkFor_Resource],
               'Vserver' as [Type], 
               VServers.StorageArray.DisplayName as [Array], 
               VServers.StorageArray.DetailsUrl AS [_LinkFor_Array], 
               concat('/Orion/StatusIcon.ashx?entity=Orion.SRM.Clusters&status=', ISNULL(VServers.StorageArray.Status, 0)) AS [_IconFor_Array],
               CapacitySubscribed AS [_TotalCapacity], 
               ((CapacityAllocated * 1.0 / CapacitySubscribed) * 100) AS [_UsedCapacityPercentage],
               CapacityRunoutSlope AS [_CapacityRunoutSlope],
               CapacityRunoutOffset AS [_CapacityRunoutOffset]
        FROM Orion.SRM.VServers (nolock=true)
        WHERE [CapacitySubscribed] > 0
          AND VServers.StorageArray.Unmanaged = FALSE
)
)
WHERE 1=1

UNION ALL (

Widget is hidden on dashboard,
there is no data to show now.

Storage Atlas

Widget is hidden on dashboard,
there is no data to show now.

Help

Array Raw Disk Capacity Summary

Widget is hidden on dashboard,
there is no data to show now.

Help

Array Usable Capacity Summary

Widget is hidden on dashboard,
there is no data to show now.

Help

Aggregated NAS Volume Capacity

Widget is hidden on dashboard,
there is no data to show now.

Help

All Active Alerts on Storage Objects

All Unacknowledged Alerts

Widget is hidden on dashboard,
there is no data to show now.

Help

Supported Storage Arrays

Search for your vendor

SELECT [Storage Array], [Monitoring Details] FROM 
	(SELECT Name AS [Storage Array], CONCAT('Arrays ',SUBSTRING(Description,8,1000) ) AS [Monitoring Details], 1 as rn FROM Orion.SRM.DeviceGroups WHERE Name IN ('EMC Unity') AND ([Name] LIKE '%${SEARCH_STRING}%' OR [Description] LIKE '%${SEARCH_STRING}%')
	UNION ALL
	(SELECT Name AS [Storage Array], CONCAT('Arrays ',SUBSTRING(Description,8,1000) ) AS [Monitoring Details], 2 as rn FROM Orion.SRM.DeviceGroups WHERE Name IN ('Nimble Storage') AND ([Name] LIKE '%${SEARCH_STRING}%' OR [Description] LIKE '%${SEARCH_STRING}%'))
	UNION ALL
	(SELECT Name AS [Storage Array], CONCAT('Arrays ',SUBSTRING(Description,8,1000) ) AS [Monitoring Details], 3 as rn FROM Orion.SRM.DeviceGroups WHERE Name IN ('InfiniBox') AND ([Name] LIKE '%${SEARCH_STRING}%' OR [Description] LIKE '%${SEARCH_STRING}%'))
	UNION ALL
	(SELECT Name AS [Storage Array], CONCAT('Arrays ',SUBSTRING(Description,8,1000) ) AS [Monitoring Details], 4 as rn FROM Orion.SRM.DeviceGroups WHERE Name NOT IN ('EMC Unity', 'Nimble Storage', 'InfiniBox') AND Name NOT LIKE 'Generic %' AND ([Name] LIKE '%${SEARCH_STRING}%' OR [Description] LIKE '%${SEARCH_STRING}%'))) order by rn

Widget is hidden on dashboard,
there is no data to show now.

Help

Last 25 Events

Last 24 Hours

	Count	Event
	6	LUN Up
	42	LUN Warning
	27	LUN Critical

Widget is hidden on dashboard,
there is no data to show now.

Customize Page

Page Settings

Storage Home

GROUPED BY Vendor

All Unacknowledged Alerts

Search for your vendor

Last 24 Hours

SolarWinds Demo Feedback