Aggregating Storage Space Sizes

Question

I've recently talked with support on chat and have received the answer most people don't like to here... "no that's not possible." I've been tasked within my org to gather the details for storage space for all the different departments. We currently have our CX700 setup where each storage group represents a department, and in fact multiple storage groups can represent a single department. I thought there would be a way in Navisphere or ECC to give me total drive usage and free space for each storage group. I've been told that the system doesn't do this and there's nothing in the system that can.

With that said, I'm now looking for a way to export the details to spreadsheets and then aggregate the data using MS Access. I believe there's a way, but I'm just wondering if anyone else has done anything like this and could share their steps before I embark down this path?

I will continue to find a way until I hear any answer and if I do find a way I will post my findings.

Until then, wish me luck!

Parks2 · Answer

Your best bet is to look at this from the hosts point of view as to what is used and what is not

RyanP2 · Answer

I just read your post like 3 times and I am a little confused. Are you looking for used/free space in regards to a single lun ( as you would see form a host ), or are you looking to find out how much space is bound in a RG and how much free space there is to bind more luns?

If it is the second, then have you used the reporting tool in the taskbar in Navisphere? It may be what you are looking for (just maybe not the form).

-Ryan

pwhyton · Answer

From the Clariion perspective, you can if you have access to it, use the Clariion Array Properties (CAP) tool to convert the SP collects into a viewable format that will show freespace on a per Raid Group basis, this will allow you to see what you have potentially available however it won't drill down into the Host perspective of what is actually used only what is assigned.

What you will get is FreeSpace & Max Contiguos FreeSpace but then again you can get this from the properties of each Raid Group within Navisphere this will just save a bit of time if your 700 is fully stacked and there are 20 + raid groups.

I haven't come across anything that will do the Array and Host in a single tool i'm affraid, if it's out there let us all know.

regards

Paul

Matt_Harms · Answer

That's fine from one perspective, but we're looking more from the perspective of what we can afford to issue/redistribute/take back.  Nonetheless, that doesn't really answer my question of how I best gather and aggregate the data.  But thanks for your input.

Matt_Harms · Answer

Thank you all for your contributions. What I ended up doing worked for my needs.

I simply logged into ECC, expanded the array and dragged teh 'Storage Groups' folder to the properties window. I was then able to see all of the LUNs that are connected to each storage group. From there I highlighted the entire table and exported the data to CSV. I opened the CSV in Excel and created a pivot table to total each storage group's 'Actual User Capacity'. This is th einfo I need to report on. Of course I have to massage the data a little because some of the storage groups (multiple) have a single department.

So I guess what I was asking wasn't what I really needed. More so, I needed just the total user capacities of each storage group, no free space.

My apologies for any confusion I created.

rix3 · Answer

Paul, Do you know how can I get this CAP tool? Is there a link for download it? Thanks for your help. Luiz

christopher_ime · Answer

CAP tool is no longer being developed; however, even when it was in active development it was an internal tool.  Instead, you can generate a similar System Configuration report from within Unisphere Service Manager by either uploading existing Storage System Configuration Files or by generating them by first logging into the array.

CLARiiON

Aggregating Storage Space Sizes

Was this post helpful?