Programmatically Reporting Volume Tier Usage

Question

The gridview at  'Compellent Enterprise Manager > Storage > Storage Types > Assigned Redundant > Volumes' displays separated tier usage for each volume. As I need to be able to report on the tier split at the volume level (same information in this view) but I don’t see an option for this in reports. I’m aware that this can be collected manually via Compellent Enterprise Manager (http://en.community.dell.com/support-forums/storage/f/4427/t/19621614) but I will need to do this frequently so I’m looking for a programmatic solution.What I’ve tried:1. I have already investigated the PowerShell module but the information is not available there. 2. I have looked in the database, the [compmsadb].[compmsauser].[StorageVolume] table looked promising at first as contains the following headers:  Column                 | Type-------------------------------------SystemSN               | intTimeStmp               | datetimeIsArch                 | intIsLong                 | intVolIndex               | bigintSnapHist               | varchar(64)Name                   | varchar(64)Type                   | varchar(16)NumPitcs               | intConfigSizeMB           | bigintUsedSizeMB             | bigintReplayMB               | bigintTotalMB                | bigintActualSizeMB           | bigintTier1Raid10            | intTier1Raid55            | intTier1Raid59            | intTier2Raid10            | intTier2Raid55            | intTier2Raid59            | intTier3Raid10            | intTier3Raid55            | intUnknownTier            | int Yet all the Tier entries are 0. – Assume this is normal?3. I have tried the Storage Center Command Utility (java -jar compcu.jar -c 'volume show') and the information is not there either anyone know how to get this information?

jfrmilner · Accepted Answer

I took a long look at the DellStoragePowerShellSDK_v2_0_1_327B that was released with EM 2015 and am pleased to report the 'Get-DellScVolumeConfigurationStorageTypeClassDistributionListAssociation' cmdlet (and possibly the longest named cmdlet I've seen!) outputs the distribution of volume space across storage type classes.

Sample output example (1type):

DiskSpaceActive : 0 MB

DiskSpaceCompressed : 0 MB

DiskSpaceReplay : 147.73 GB

DiskSpaceSavedByCompression : 0 MB

DiskTierNumber : 3

DiskTrack : FastTrack

PercentCompressed : -1

RaidLevel : RaidSixTen

StorageTypeClass : 30715.1.15 ScStorageTypeClass Assigned - Redundant - 2 MB - Tier 3 RAID 6-10 - Fast

UncompressedToCompressedPageRatio : -1

Volume : 30715.5 ScVolume pdc1_01

VolumeSpaceActive : 0 MB

VolumeSpaceCompressed : 0 MB

VolumeSpaceReplay : 118.18 GB

ObjectName : ScVolumeStorageTypeClassDistribution

Compellent

Was this post helpful?