Community maintenance is complete. Thank you for your patience!

Active IQ Unified Manager Discussions

WFA - Query DFM and Protection policy from Workflow

sheelnidhig

Hello Guys,

We have approx 8 DFM servers acting as Protection manager servers.

I am looking for a possibility to query the DFM servers added as a Datasource, so that :

- I can select the DFM server where I would like create a dataset and add volumes to it.

- be able to list down the available protection policies which can be attached to a dataset.

I cannot find any item in Dictionary item regarding DFM components and be able to add or remove objects in DFM server.

Do we have any Workflow available which can do something like this ?

,Sheel

19 REPLIES 19

sheelnidhig

I have no luck so far

Anyone managed to get anything regarding this topic ?

,Sheel

abhit

Sheel:

We have prepared a sample for you for caching "Protection Policies".

However we have done with the current development version of WFA.

If you can tell which version of WFA you are using, we will create a dar with

that version and send it accross to you.

We will also provide some more pointers to you.

Regards

Abhi

sheelnidhig

Hello Abhi,

Any luck ?

,Sheel

abhit

Attached is a sample for Provisioning Policy.

You need to replicate in the same way for other tables.

In Dictionary, cache queries, data sources views, just look for "None Certified".

You can just clone the same and make it use for other tables.

How to know the tables in DFM?

http://www.sybase.com/detail?id=1087327

Download this tool from sybase.

Connect to DFM DB. Use the DB user name and password

which you have used in WFA.

You will be able to see all the tables.

In the DFM Table Details.msg, you can see the details of the DFM tables also.

Let me know if it helps. Apologies for taking time to reply.

Regards

Abhi


sheelnidhig

Hello Abhi,

I would need a little guidance, how can I make use of this .sql file.

I am not good with WFA yet 😞

,Sheel

abhit

Administration->BackUp Restore->Restore "Choose File"-->WFA_V2.2.0.2.6_B2416155_08_18_14__14_53_33.sql.gz.

The DB will get restored.

Regards

Abhi

sheelnidhig

The WFA version I am using is - 2.2.0.2.6-2416155

I think this is the current GA version.

Thanks,

Sheel

cscott

Hello Sheel,

     Does this workflow get you moving in the correct direction?  I created this using SQL queries rather than building dictionaries or using the playground DB.

The major drawback with this approach is that you cannot have the same controller/volume combinations in two DFM instances.

e.g.  filerA:vol1 in DFM1, and filerA:vol1 in DFM2.  This lead me down some bad paths, so I don't recommend it unless your DFM instances manage a dedicated set of controllers/volumes.

sheelnidhig

IS there a possibility to get other DFM's protection manager information by a SQL query and be able to create the DFM server objects in protection manager.

cscott

Hi Sheel,

     Digging deeper it doesn't appear that any of that appears in any form that WFA is currently pulling, and it may not be 100% available.  It appears that the following would be the set of tables needed in the playground DB.  I am trying to pull some of this into my test system currently to see what all is available.

"monitordb","DFM","dpSchedules","TABLE",""

"monitordb","DFM","dpScheduleHourlyEvents","TABLE",""

"monitordb","DFM","dpScheduleDailyEvents","TABLE",""

"monitordb","DFM","dpScheduleWeeklyEvents","TABLE",""

"monitordb","DFM","dpScheduleWeeklySubscheduleEvents","TABLE",""

"monitordb","DFM","dpScheduleMonthlyEvents","TABLE",""

"monitordb","DFM","dpScheduleMonthlySubscheduleEvents","TABLE",""

"monitordb","DFM","dpThrottleSchedules","TABLE",""

"monitordb","DFM","dpThrottleEvents","TABLE",""

"monitordb","DFM","dpPolicies","TABLE",""

"monitordb","DFM","dpPolicyNodes","TABLE",""

"monitordb","DFM","dpPolicyConnections","TABLE",""

And maybe

"monitordb","DFM","dpLockedStoragesets","TABLE",""

cscott

Adai,

     Am I wrong that since none of the "dp" tables includes a view, I don't have a way to pull the information in?  I have manipulated some of my other dictionaries and it always appears that there is a VIEW associated with the dictionaries that exist.  In this case querying for dp and VIEW return nothing.

- Scott

adaikkap

Hi Sheel,

     Before I come to your pointed questions, let me see if I understood what you are trying to achieve.

Are you trying to automate the dataset creation in your 8 DFM/ProtMgr Servers from WFA so that you dont have to login to individual  DFM/PM server.

If that's a right understanding, then the simple answer to all your questions is its possible,  but not completely out of the box.

You may have to write some custom command, for which there are sample out to the box as well as in the community.

Also there may be need to add a playground database with your 8 DFM server for the resource selection.

Now coming to your specific questions  Pls find some of my response below.

Do we have any Workflow available which can do something like this ?

Not out of the box, but there are sample in the communities.

We have approx 8 DFM servers acting as Protection manager servers.

I am looking for a possibility to query the DFM servers added as a Datasource, so that :

- I can select the DFM server where I would like create a dataset and add volumes to it.

- be able to list down the available protection policies which can be attached to a dataset.

First we have to see  if these are cached in WFA, from the DFM, if not either write a custom datasource or since many of these information are pretty static,  we may even use the playground database.

I cannot find any item in Dictionary item regarding DFM components and be able to add or remove objects in DFM server.

There are dictionary items to like Resource Groups, Resource Group Members, Resource Pools dataset. You can extend any of these are build new ones as well.

Also there are following commands

Create Dataset

Add volume to dataset

Create Resource Groups

Add members to Resource Groups

Regards

adai

sheelnidhig

Thanks Adai,

     Would it be possible to share one or two example which really puts some DFM Protection manager related data to a Playground database ?

,Sheel

abhit

There is some cached protection data already under the cm_storage scheme.

Please see the attached file.

What other data you are looking to cache?

Regards

Abhi

sheelnidhig

Hello Abhi,

I am looking for the DFM's Ptorection manager data for 7-mode environment like:

     - Dataset

     - Protection Policy

     - Provisioning Policy

     - Resource Pool

     - Schedule attached with Protection Policy

abhit

Thanks,

2 Options below. Option 2 will be easier in my opinion.

1.if you known the DFM 7-mode table names, and need help with playground.

please follow the document, mentioned in the following doc.

https://communities.netapp.com/docs/DOC-30504

You should be able to create without any issues.

2. Other easier way. This will require very minimal changes. Please follow these steps.

a) Clone a dictionary, dataset. Rename it to "Protection Policy", change name of attributes to suite "Protection Policy".

b) Goto "Designer->Data Source Type. Clone "UM 5.x 7-mode Data source".

c) Goto "cache queries", clone Dataset,  Rename it to "Protection Policy", Open the cache query to modify the sql query to get the data

from DFM 7-mode "Protection Policy" table.

Repeat the same for

     - Provisioning Policy

     - Resource Pool

     - Schedule attached with Protection Policy

Let me know if you need further help.

Regards

Abhi

abhit

Sheel:

Any luck with the options?

Regards

Abhi

sheelnidhig

Hello Abhi,

No luck so far, i am not able to modify the cloned dataset table -> protection policy dictionary,

     change name of attributes to suite "Protection Policy" ---> could not get any relevant attributes.

c) Goto "cache queries", clone Dataset,  Rename it to "Protection Policy", Open the cache query to modify the sql query to get the data

from DFM 7-mode "Protection Policy" table.

     - not much information available for the dfm database.

,Sheel

    


abhit

Thanks Sheel for your reply.

Will try to provide a few samples to you.


Regards

Abhi

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