Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

2068

February 1st, 2016 03:00

Question about filtering on NOP formula result

Hello,

I have a question about filtering on availability on a property 'pushed' via NOP formula. I have a report table that is showing for a given array the list of all LUNs and the datastore associated with the LUN (in our env 1 LUN = 1 DS), and as sub report for each Datastore the VM's that are using it. The structure looks like that:

  • Main report  Expansion on device with filter devtype=='Array'
    • Expansion on part with filter parttype=='LUN'     +  NOP formula to push up the datastore name (DSName)
      • Complex expansion on "partsn join on partsn" to create the link between the LUN and the DS   + NOP formula to push up the datastore name (DSNAME)
        • expansion on device with filter devtype=='Datastore'    + NOP formula with empty parameter and device property attached to it (Result name of formula : DSName)
          • Complex expansion towards VMs linked to the datastore
            • ...

In the Main report I have the following columns:

Name: Arrays SID              property= 'device'

Name: LUN                        property= 'part'

Name: Datastore name     property='device' with Selected Value= 'DSName'

This is working fine we have the match between the LUNs and the datastores. But the problem is as we do an expansion on LUN we have all of them even the ones where there is no datastore attached.

How could I do a filter to say "Show me only the LUN's where the property device of the formula result DSName is not empty" ?

Thanks,

Jean-Michel

2 Intern

 • 

166 Posts

February 15th, 2016 00:00

Here it is.

The trick is to add a "value" column which count if there is a datastore connected ; then filter on that particular column.

We can not filter on "property" column.

HTH

1 Attachment

2 Intern

 • 

166 Posts

February 11th, 2016 03:00

Hi Jean-Michel,

Can you attach your report template please ?

I'm not sure but maybe we can do something with the expansion policy (aka expansion & selection).

Thx

20 Posts

February 11th, 2016 23:00

Hello,

Here is in attach the report definition,

In the Array report the Datastore name(device) is coming from DSName, which is a NOP formula result.

What I would like it so show only the LUNs where the field datastore name is not empty.

Regards,

Jean-Michel

1 Attachment

20 Posts

February 24th, 2016 01:00

Thanks a lot for you help !

No Events found!

Top