Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

773

May 29th, 2009 03:00

Arrays by User Defined Group reporting

Hi,

I have split our device into a three tier folder structure, ie All Groups\Sites\London\SAP and have all NAS file systems, raid groups, hosts added to the relevent folder.

When I run the built in report "Arrays by Group" in Storage Scope I can see the three tiers under the filter options but the report only comes back with data as far down as Array Group: \All Groups\Sites\Heathrow\

Is there any reason why it would be doing this?

Many Thanks
Adam

41 Posts

July 14th, 2009 12:00

The built in "Array By Group" Crystal report should be showing all the groups which have Arrays under it. In your grouping structure, does Heathrow have a sub-group under it which you have added arrays to that group? If so, it should be picked up by the built in crystal report.

To view the group totals for NAS FileSystem, please use the built in query "5.2 NAS - File System Group List" which will give you the Nas related group totals for all the NAS Filesystems you have added into groups.

If you need to find out which groups the NAS FileSystems belong to, you would need to create a custom query with objects "NAS FileSystems", "All Objects in a Group" and "All Groups", then pick the columns you are interested in. You can use the built in query "Hosts in a Group" as a template to arrive at "NAS FileSystems in a Group".

Hope this helps.

Anu

17 Posts

May 29th, 2009 07:00

StorageScope only reports Array by Group and Host by Group. There is no support for NAS by group now. So even though you put NAS filesystem in the group, you won't see data for that.

If you want to use Array by Group, you need to put arrays (not raid group) into user defined group. Array by group only shows the group containing arrays.

7 Posts

June 1st, 2009 04:00

Thankyou for the quick response

So I take it it isn't possible to report down to LUN level either, with the Arrays by Group report?
Is the only to report on LUNS by user defined group by running a custom query on the user defined group to include LUN information or to use crystal repports ot create a customer report?

27 Posts

July 6th, 2009 09:00

You need to use Crystal Reports. I'm using version 10. The User Defined Groups are in a table that has a primary key in its row, referring it to its parent group. The Primary Key, SRMGROUP.GROUPKEY is found in SRMGROUP.PARENTGROUPKEY. Create a "Blank Report" and connect to your repository. Select SRMGroups as your table. Insert a Group. Group on "GROUPNAME". Add some data like "GROUPPATH" in your "Details" section. Go up to your menu, select "Report" and "Heirarchical Grouping Options". Hopefully you'll see "SRMGROUP.GROUPKEY" as the Available Group. Select the Checkbox to the right that says "Sort Group Heirarchically". The "Instance ID" field should be "SRMGROUP.GROUPKEY" and the "Parent ID Field" should be "SRMGROUP.PARENTGROUPKEY".

Give it a try and send me a note if you need more help. Figuring this out took me too long to not share with you all. Have a great day!

Mike
No Events found!

Top