Active IQ Unified Manager Discussions

SQL Query for Cluster Name

raovolvoadmin
5,627 Views

Hello,

I was trying to list of available cluster which are available.I used the below SQL queries.Query was sucessful but not giving any output.Don't know exactly where i m doing the mistake:-(.Can some one help me?.

SELECT

    Name AS 'Name',

    Primary_Address AS 'Primary Address',

    version AS 'Version'

FROM

    cm_storage.cluster

ORDER BY

    Name ASC

Output i have attached here..

BR

Rao.

1 ACCEPTED SOLUTION

abhit
5,627 Views

Hi Rao:

Is a cache acquisition done in WFA?

It is better to use a tool like SQLYog, connect to the DB using wfa/Wfa123,

run the query and see if you are getting any results.

I can the query in SQLYog and it is returning the results.

Regards

Abhi

View solution in original post

5 REPLIES 5

abhit
5,628 Views

Hi Rao:

Is a cache acquisition done in WFA?

It is better to use a tool like SQLYog, connect to the DB using wfa/Wfa123,

run the query and see if you are getting any results.

I can the query in SQLYog and it is returning the results.

Regards

Abhi

raovolvoadmin
5,627 Views

Thanks abhi,It was probl with acquisition.

One more question...

If I add individual filer/cluster to WFA instead of DFM,is it Possible to do the acquisition?.

adaikkap
5,627 Views

Hi Rao,

     Below is the answer to your question

If I add individual filer/cluster to WFA instead of DFM,is it Possible to do the acquisition?.

  1. The simple answer is NO, there is no canned datasource defined to acquire data from filer out of the box in WFA.
  2. But as you know wfa is a framework and allows you to create and add your own data source. Here is an example for cluster as a datasource for snapshots. WFA 2.1+ CM Snapshot support with Unified Manager 6.0+

Rao, I would like to understand, more on why you want to add filer as a datasource directly, instead via a OCUM/DFM.

  • Is it because of lack of data being collected by OCUM/DFM ? Like the data your are looking for is not being collected by dfm ?
  • What you want to do by adding filer/cluster as data source ?

Regards

adai

raovolvoadmin
5,627 Views

Thanks Adai

We are in the phase of validating the WFA for cluster mode.So I was just varifying  "filer/cluster as datasource" for documentation purpose.

Regards

Rao.

abhit
5,627 Views

Hi Rao:

You can take a look at this post.

https://communities.netapp.com/docs/DOC-33054#comment-20099

Regards

Abhi

Public