Someone on the Symmetrix Support Forums on the EMC Community Network was asking for a way to report on Tier Usage by Storage Group. That’s pretty simple and easy to see with the following command:

[box]symfast -sid xxxx list -demand –association[/box]

However that is raw output and even if output is XML it’s just not that easy to parse into Excel.  So I decide to write a quick perl script to parse the output and turn it into a CSV.

It’s fairly simple,  but you do need to edit the script to specify the name of all your tiers. That is done on line 15.

[box]my @tiers = (‘R5_SSD’, ‘R5_FC’, ‘R6_SATA’); [/box]

Each tier just needs to be added as an element to the array.  Then you just run the perl script passing the SID of the array in question and you’ll get a CSV showing the Storage Group, Demand, Usage, and Growth like this:

[box]SG, R5_FC Usage, R5_FC demand, R5_FC growth,R5_SSD Usage, R5_SSD demand, R5_SSD growth,R6_SATA Usage, R6_SATA demand, R6_SATA growth,
SG1_Test,0,275,+275,0,275,+275,258,275,+17,
SG2_Test,160,600,+440,0,600,+600,283,600,+317,
SG3_Test,3007,6121,+3114,0,6121,+6121,2325,6121,+3796,
SG4_Test,595,1428,+833,0,1428,+1428,600,1428,+828, [/box]

And that is it!  Hope this helps you all report tier usage. If you havnt been to the EMC Community Network recently check it out here!