This post is more than 5 years old
5 Posts
0
724
March 5th, 2010 14:00
Custom Query for Array Utilization
Hi All,
I am trying to create a custom query for Array Utilization through STS FLR. Which column would give me the Total storage capacity configured in all the Raid Groups on the Array.. The closest I am leaning to is "Array - Accessible" but the numbers do not match..
Any Ideas ?
Thanks
Amit
No Events found!
SarahXu1
59 Posts
0
March 5th, 2010 14:00
You need to create custom query and get capacity from object Raid Group instead of array:
1. Select object Arrays and Raid Groups
2. Select columns:
Arrays.Array Name
RAID Groups.Raw Raid Group - This is total raw capacity for Raid Group
RAID Groups.Usable Raid Group - This is usable capacity for raid group (exclude raid protection)
RAID Groups.Lun Capacity - This is sum of all lun capacity for raid group
and add more columns if you want.
3. Add any filter if you only want to see report for specific array or simply Next
4. Subtotal by Array Name - This will give you sum of all raid group capacity for each array
5. Save and Run
This custom query should give you the total storage configured for all the raid groups on each array.
Sarah
vigholt
3 Posts
0
March 9th, 2010 01:00
Hi Sarah
SarahXu1
59 Posts
0
March 9th, 2010 09:00
To get capacity for each host on array, please select objects: Hosts, Host Arrays and Arrays, then select columns:
Arrays.Array Name
Hosts. Host Name
Host Arrays.Allocated
Host Arrays.Accessible
To get capacity for each storage group on array, please select objects: Arrays, Luns, Storage Groups and select columns:
Arrays.Array Name
StorageGroup.Storage Group Name
Luns:Lun Name
Luns:Assignable Device Capacity - Raw
Luns:Assignable Device Capacity
Subtotal by Array Name and Storage Group Name