daver3

updated

17 years ago

D

daver3

46 Posts

0

1061

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!
  • AnuShivnath

    41 Posts

    585

    0

    Posted 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
  • daver3

    46 Posts

    585

    0

    Posted August 26th, 2009 14:00

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

    6 Operator

    •

    2124 Posts

    585

    0

    Posted 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).
  • AnuShivnath

    41 Posts

    585

    0

    Posted 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.