This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Available capacity for Thick Provisioned LUNs? They are all showing 0% free.

How do we get the actual available capacity for Thick Provisioned LUNs? They are all showing 0% free.

Parents
  • This is what I ended up Using:

    SELECT 
    s.Caption AS Array_Name,
    p.DisplayName AS Pool_Name,
    p.CapacityUserUsedPercentage AS UsedPercent,
    p.CapacityUserFreePercentage AS FreePercent,
    ROUND((p.CapacityUserTotal / 1.0995e+12),3) AS Total_TB,
    p.thin,
    p.DetailsUrl AS [_LinkFor_Pool_Name],
    s.DetailsUrl AS [_LinkFor_Array_Name],
    CASE
        WHEN p.Status = 1 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_up.png'
        WHEN p.Status = 2 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_down.png'
        WHEN p.Status = 3 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_warning.png'
        WHEN p.Status = 9 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_unmanaged.png'
        WHEN p.Status = 14 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_critical.png'
        ELSE '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_unknown.png'
    END AS [_IconFor_Pool_Name],
    CASE
        WHEN s.Status = 1 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_up.png'
        WHEN s.Status = 2 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_down.png'
        WHEN s.Status = 3 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_warning.png'
        WHEN s.Status = 9 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_unmanaged.png'
        WHEN s.Status = 14 THEN '/Orion/iSRM/mages/StatusIcons/Small-Arrays_icon_critical.png'
        ELSE '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_unknown.png'
    END AS [_IconFor_Array_Name]
    
    FROM Orion.SRM.Pools p
    JOIN Orion.SRM.StorageArrays s ON p.StorageArrayID = s.StorageArrayID
    
    WHERE usedpercent > 80 AND p.displayname NOT LIKE '0000'
    
    ORDER BY array_name ASC,
    usedpercent DESC;

Reply
  • This is what I ended up Using:

    SELECT 
    s.Caption AS Array_Name,
    p.DisplayName AS Pool_Name,
    p.CapacityUserUsedPercentage AS UsedPercent,
    p.CapacityUserFreePercentage AS FreePercent,
    ROUND((p.CapacityUserTotal / 1.0995e+12),3) AS Total_TB,
    p.thin,
    p.DetailsUrl AS [_LinkFor_Pool_Name],
    s.DetailsUrl AS [_LinkFor_Array_Name],
    CASE
        WHEN p.Status = 1 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_up.png'
        WHEN p.Status = 2 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_down.png'
        WHEN p.Status = 3 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_warning.png'
        WHEN p.Status = 9 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_unmanaged.png'
        WHEN p.Status = 14 THEN '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_critical.png'
        ELSE '/Orion/SRM/images/StatusIcons/Small-Storage_Pools_icon_unknown.png'
    END AS [_IconFor_Pool_Name],
    CASE
        WHEN s.Status = 1 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_up.png'
        WHEN s.Status = 2 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_down.png'
        WHEN s.Status = 3 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_warning.png'
        WHEN s.Status = 9 THEN '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_unmanaged.png'
        WHEN s.Status = 14 THEN '/Orion/iSRM/mages/StatusIcons/Small-Arrays_icon_critical.png'
        ELSE '/Orion/SRM/images/StatusIcons/Small-Arrays_icon_unknown.png'
    END AS [_IconFor_Array_Name]
    
    FROM Orion.SRM.Pools p
    JOIN Orion.SRM.StorageArrays s ON p.StorageArrayID = s.StorageArrayID
    
    WHERE usedpercent > 80 AND p.displayname NOT LIKE '0000'
    
    ORDER BY array_name ASC,
    usedpercent DESC;

Children
No Data