jfrmilner

updated

12 years ago

J

jfrmilner

12 Posts

0

30693

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?

  • jfrmilner

    12 Posts

    1254

    2

    Posted 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