Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

987

August 6th, 2009 14:00

need StorageScope query for showing mapped but not masked volumes on a symm

I know there has to be a way to do this, but I cant figure it out, anyone know how? thanks!

41 Posts

August 10th, 2009 06:00

In Query Builder section create a new query using the "Create" button -> Next
In the "Area of Interest" window, select the objects "Arrays" and "Luns" -> Next
In the Available Columns list select the columns you are interested in -> Next
In the "Create Filters" window
Pick "("
Select Column LUNs.LUN Masked
Select Operator "equal to"
Type in value - No
On the next row
Pick "and"
Select Column LUNs.Mapped
Select Operator "equal to"
Type in value - Yes
On the next row
Pick "and"
Select Column Arrays.Array Type
Select Operator "contains"
Type in value - Symm
Pick ")"

Go through the rest of the QB wizard to create the query to view the results

46 Posts

August 26th, 2009 14:00

I did all of that but I get no results. Thank you for the reply.

4 Operator

 • 

2.1K Posts

August 28th, 2009 12:00

So, I hate to ask the obvious question (actually I don't, but I can pretend can't I?)...

If you don't know how to find them, and you run a report that should find them and doesn't, how do you know you actually have any to find?

This may sound like a silly question, but it's a good starting point (since the query isn't working for you).

Also, what version of CC are you running (including UB and patches).

41 Posts

September 11th, 2009 12:00

Please post the sql query that QB constructed for the custom query you have created. I will check that out. If the query is right, there is most probably no data that meets your criteria in the database. The next steps would be to open a case with engineering, and get us a dump to check it out.

Hope that helps.
Anu Shivnath.
No Events found!

Top