Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

30679

March 4th, 2015 01:00

Programmatically Reporting Volume Tier Usage

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               | int
TimeStmp               | datetime
IsArch                 | int
IsLong                 | int
VolIndex               | bigint
SnapHist               | varchar(64)
Name                   | varchar(64)
Type                   | varchar(16)
NumPitcs               | int
ConfigSizeMB           | bigint
UsedSizeMB             | bigint
ReplayMB               | bigint
TotalMB                | bigint
ActualSizeMB           | bigint
Tier1Raid10            | int
Tier1Raid55            | int
Tier1Raid59            | int
Tier2Raid10            | int
Tier2Raid55            | int
Tier2Raid59            | int
Tier3Raid10            | int
Tier3Raid55            | int
UnknownTier            | 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?

12 Posts

June 16th, 2015 15:00

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

No Events found!

Top