Single report for LUN / Volume size and host it's mapped to?

If you are using Unisphere Report Wizard, I reckon there is no option which gives the desired output.

However, I am unaware if it can be received by any sort of custom script.

if information can be retrieved with naviseccli (which this information can)  it can scripted and molded into customer reports.

LUN size can be obtained: naviseccli -h SPA IP getlun -capacity

Again, I dont' believe there's a switch with this command which can be added to get the host assigned to particular LUN.

I wonder, if a single comamnd can be used to get the output like:

Host Name, LUN, LUN Size, Total Space, Available Space and Used Space.

At the mo?! I can just hope so!

Right Now, SingleTrackMind I do not think it is possible.

i am not sure how you are going to get host based info like available space, used space using naviseccli.

LUN usage on host side cannot be reported as the array doesn't aware this higher layer (LVM, FS, etc) behaviour, only host side reporting tools could be able to provide the answer i believe.

On the array, you can only get the left capacity of a RAID Group.

from EMC there is EMC ControlCenter (although it's way overkill for what you are trying to do). Look at DPA as well ..it might have some host based reporting.

Thanks for taking the time to think about this. Is there any reporting software out there that can get this information? Just wondering if anybody ever has to provide these sorts of metrics and how they go about it. I'm digging through scripts other people have posted to see if there is some solution. Otherwise, I will have to manually go through each storage group and manually document the disk assigned and LUN size, used, and available. Yeah...

Thank you Dynamox, I'm not familiar with DPA. Wish there was a way to script this. This report is just ridiculous. The info is all there under reporting. It's just in two different XML files. One has servers and LUNs in a single field comma separated. The other only has the luns with the sizes in there own fields. So, I would need to somehow export the XML file, copy the comma separated data to a text file (per cluster / attached server) import into excel, break it up and correlate with the attached server section.

you don't care about meta members, you just care about the total size  presented to your host ?

Would it help! I can't even begin to explain how much it would help. I have about 10 arrays to get this info from.

I did find this:

This is what I'm trying to accomplish using the Celerra LUNS as example:

Yes,

I just realized that I have meta luns to contend with now as well. Ugg. But yest that's exactly what I'm trying to achieve plus the meta luns..

i can write something in perl and write output into csv, will that work ?

The formatting can be anything, just need to get this data into a spreadsheet somehow.