This post is more than 5 years old
12 Posts
0
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?
jfrmilner
12 Posts
2
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