The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Filters don't return results

VMUNOZ_NTT

Hi,

I'm testing WFA at very basic level.

I can't found how to Filters return results. I have the ONTAP controllers added and connectivity test works. I'm using root credentials and controller has 3 aggrs.

Any help is more than welcome?

2012-09-19 12:51:00,845 BST DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-0.0.0.0-80-3) Executing local filter 'aggregate in array by array ip' , parameters '{array_host=192.168.145.16}' , query 'SELECT

    aggr.name, array.ip AS 'array.ip'

FROM

    storage.aggregate AS aggr, storage.array AS array

WHERE

    aggr.array_id = array.id AND (array.ip = '192.168.145.16' OR array.name = '192.168.145.16')'

2012-09-19 12:51:00,845 BST DEBUG [com.netapp.wfa.finders.execution.impl.FindersExecutorImpl] (http-0.0.0.0-80-3) Local filter 'aggregate in array by array ip'successfully executed , rows affected '0'

1 ACCEPTED SOLUTION

hland

Did you configure your OnCommand/DFM server as a data source and aquired data successfully? The WFA cache is filled from this, it doesn't need any controller credentials in order to make filters work.

Regards

Hendrik

View solution in original post

3 REPLIES 3

VMUNOZ_NTT

Hi,

the DFM data source was configured with wrong credentials.

thanks for your quick answers!

hland

Did you configure your OnCommand/DFM server as a data source and aquired data successfully? The WFA cache is filled from this, it doesn't need any controller credentials in order to make filters work.

Regards

Hendrik

View solution in original post

hill

To add a little more to what Hendrik pointed out:

  • WFA Filters and Finders run against the WFA Cache.  This is the database where we store information we pull in from different sources of data:
    • OnCommand Unified Manager / Operations Manager - this gives WFA a complete view of your environment
    • vCenter - this give WFA a good view of your VMware envrionment
    • other - other sources of data can be pulled into WFA to be leveraged in a workflow

The filters are simply SQL queries like you've used in your examples.  However the "FROM" statements are referencing the WFA DB Tables.

You can add new datasources in the following manner:

  • log into your WFA 1.1.x system as admin
  • click on the 'Execution' tab
  • click on 'Data Sources'
  • click on 'Actions' in the top menu and select 'New'
  • Add your OnCommand Datasource

Also to ensure proper communication between WFA and OnCommand you will need to follow the information in Appendix D of the Install & Setup guide.

Hope this helps,

Kevin

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public