Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

1279

December 3rd, 2007 14:00

StorageScope Queries Available for Download

I'm trying to create a StorageScope report that will output total Storage Capacity in-use by BCV devices and how much are carved and how much are available.

I've been told to use StorageScope to do this, but whoa - I'm in a bit over my head. Anyone out there have some quick tips on how to go about this, or perhaps some SQL code I can snip and paste to accomplish this?

Thanks!

17 Posts

December 10th, 2007 12:00

In 6.0, from query builder, you can create query to get BCV information. The query will show you list of BCVs with their allocated/accessible and used information:

1. Go to SRM console, Analysis-> Queries
2. Click Create, Put whatever name you want to use, everything else use the default, then Next.
3. Choose objects, Arrays and LUNs, then Next.
4. Choose columns:
Arrays.Array Name
Luns.Lun Name
Luns.Lun Capacity
Luns.Raw Lun Capacity
Luns.Array Allocated?
Luns.Host Allocated?
Luns.Host Accessible?

Then Next
5. Choose filter Luns.Allocation Type equals Local Replica. This will only show you BCVs.
6. Save and Run it.

To get carved and uncarved capacity, you can create query by choosing object Arrays, then column configured and unconfigured.

2 Intern

 • 

5.7K Posts

December 4th, 2007 02:00

Which version of storage scope ? The new 6.0 or the one that comes with the old ECC 5.2 ?

2 Intern

 • 

146 Posts

December 4th, 2007 07:00

StorageScope 6. I've also installed the queries update that is on disk 4 of ControlCenter 6, but there aren't any queries/reports that are useful. My management has asked for a list of:

How much disk total in the box by tier (73, 146, 300, 500)
How much disk is carved by tier (73, 146, 300, 500)
How much disk is uncarved by tier (73, 146, 300, 500)
How much disk is replicated an by which tier

I find it baffling how complicated StorageScope is to create a report of this simplicity.

2 Intern

 • 

5.7K Posts

December 4th, 2007 08:00

The easiest way to do this is to ask you friendly local CE to give you a report on what's in your box.
He then will produce a list of disk groups. Each group has a certain number of disks, grouped by capacity, so for example group 1 is 50 x 73GB, group 2 is 256 x 146GB, group 3 is 128 x 146GB (yes, you can have multiple groups of the same sort of disks) and so forth.
Then he can easily produce a list of "normal" devices, BCVs, whatever you ask for. For him it's a matter of copy / paste from the service console.

So if your manager needs this info in a hurry, I'd suggest this way and work out another automated way after that.

I would also create storage pools in ECC and (manually) add devices in there, so you can easily view the free space in each storage pool (and what's used from each pool). You can for example have a pool of BCV which are located on 73GB disks, another pool of RAID5 standard devices based on 300GB disk and so on...

2 Intern

 • 

146 Posts

December 4th, 2007 10:00

The storage pool concept is exactly what I am using, the only problem is that it doesn't calculate RAW capacity. Another option I can use to calculate raw is symdisk -by_diskgroup, but again, doesn't make for "quick" calculation and chargeback.

Thanks for the response. It's good to know that I haven't missed anything in StorageScope.

2 Intern

 • 

5.7K Posts

December 5th, 2007 06:00

Well, I don't know if you can report unused RAW storage using SS. Contact your CE and he can tell you for sure !

8 Posts

January 11th, 2008 15:00

You seem very proficient with the 6.0 STS. I've been trying to re-create a 5.2 report (Connectivity:Switch Ports - Unidentified Ports) with the 6.0 query tool with no luck at all. Any ideas? Thanks.

2 Intern

 • 

385 Posts

January 23rd, 2008 05:00

Have you tried installing the 5.2 queries that come on Disk 4? Not sure if the specific report you want is on that CD, but there are some extra reports.

Still struggling a bit with the query tool myself though it does have a lot of potential.

13 Posts

January 25th, 2008 11:00

Hi Vince,

If Sarah's post resolved or helped resolve your issue, please mark "Answered" or "Helpful."

Thanks,

David D. Ward
EMC Resource Management Software Group
Forums Moderator/Host

17 Posts

January 30th, 2008 12:00

To see Switch ports connected to unidentified ports:
1. Go to Analysis -> SRM Views -> Switches
2. Click on the switch that you want to see
3. Click Tab "Switch Ports"
4. There is a drop down menu "Ports Connected to Unidentified Ports or Free Ports"

1 Rookie

 • 

28 Posts

July 16th, 2008 06:00

Hi,

I wanna know more about storagescope queries if you have samples like how to do them, please send them to pamulaparty@gmail.com. Please give me ur contact details so that i can contact you if so ever i have an issue.
No Events found!

Top