Report on Protection Manager policy schedules for backups and replication

[MIP_GMT01]

I am trying to report on protection policies backup and replication schedules and retention. Is there an easy way of doing this? I have tried dfpm command and operations manager report but not able to get what I want. There is a command "dfpm policy schedule" but it only works for application policies. I am using version 5.0.1.7864 (5.0.1). Would appreciate any help. Thanks

[adaikkap]

Hi Muhammad,

     Unfortunately there is no canned report or catalog with this details. The easiest way to get this is via script using the dfpm policy schedule and connection cli.

Can you give me a temple report on what and how you want the report to be ? Is it just based on

• Each realtionship ?
• Each Dataset ?
• Each Protection Policy ?

If you can send us a simple report with column names and value that you are expecting then we can quickly get you a script plugin to generate this report. The same can later be scheduled, emailed and exported in various forms as well.

Regards

adai

[MIP_GMT01]

Hi Adai,

Thank you for reply.

We have all windows based infrastructure so it will be good to get a power shell based script. Below is what I am looking for.

I also tried to get a report of all members of all DataSets. I know you can get members for one DS with "dfpm dataset list -m" but there is no command to get members of all dataset?

Dataset	Policy	Node	Primary Backup Sched	Primary BP Retention	SV Backup sched	SV BP retention	mirror sched
DS_CIFS_PROD_ENOM	.Gold OnTap : Primary 00 Onsite Backup 05 Offsite Mirror 30	3	Hourly = Every hour, starting 00:00	Hourly = 1Day (24 BP)	Every hour, starting 00:05	Hourly = 1Day (24 BP) Daily = 32Days (32 BP)	Every hour, starting 00:30

Many Thanks,

Muhammad

[adaikkap]

Hi Muhammad,

     Thanks for the sample/ template of the report that you are looking for. But unfortunately we will not create it in powershell, instead in perl to make the script OS agnostic.

We will post a working script some time later mid next week.

Regards

adai

[NEILHOLMES]

Hi adai,

this sounds exactly what I am after as well. Did you manage to produce a script for Muhammad?. If so, could you link me to it please. I'm new to navigating the community forum.

Many thanks.

Neil.

[ppavagad · Accepted solution]

Hi Muhammad/ Neil Holmes,

Please find attached the Script Plugin with name: PM_Extractor.zip.

This script plugin should help you in extracting schedule and retention information related to all the datasets to which a policy has been assigned.

The final output will be a consolidated CSV file.

The instructions to install the script and to view the output are in a file inside the archive titled, ReadMe.doc.

Also, do note that it is a primitive version of the Script Plugin. If you find any errors, please do report it back to us and we will try to help.

Thanks & Regards,

Pavan

Edit: Updated ReadMe.doc in the ScriptPlugin.

[adaikkap]

Hi Muhammad & Niel,

                 The output would be stored in the following location. If the its a default installation.

C:\Program Files\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\ScriptOutput.csv

To generalise, in both windows or linux, you can find the output in the following location.

<installdir>/DFM/script-plugins\PM_Extractor\ScriptOutput.csv

Regards

adai

[NEILHOLMES]

Many thanks to you all for the reply. Excellent script.

[adaikkap]

Hi Neil,

     Happy that its really helping you and find it useful. Let us know if you have any ideas or improvements needed in the script.

Regards

adai

[MIP_GMT01]

Thank you for script. For some reason I keep getting following error message when scheduled from dfm. I installed ActivePerl and path variable for perl exist in system environment variable.  I can also manually browse to .pl script. Any idea?

C:\Perl64\bin\perl.exe "C:\Program Files (x86)\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\PM_Extractor.pl" failed.

Reason: The system cannot find the file specified

[ppavagad]

Hi Muhammad,

Thanks for your reply.

PM_Extractor.zip is a script plugin which needs to be installed via the Operations Manager. The detailed installation procedure for the same has been mentioned in the ReadMe.doc file inside the archive. Posting it again here for your convenience:

• Operations Manager (Ops-Mgr) can be reached by via your browser by typing http://< DFM Server IP Address>:8080/dfm/
• In your Ops-Mgr Go to Control Center => Management => Scripts
• You will get to the “Scripts” Page. Where you will find two options.
• Select the option “Path to ZIP file on your computer:” and point it to the zip file(PM_Extractor.zip).Then click the button “Add “ you will get to the “Scripts - Confirm Adding a Script” page and press “Add” again.
• Now you have successfully added the script to the script plug-in infrastructure of Ops-Mgr.
• To assign a schedule, if you wish to run this periodically then follows the steps below.
• In the “Scripts” page you will find under the scripts heading “PM_Extractor”
• Click on the like which will take you to “Script - Script Details” page. In that click on the link
• Named “none” against schedules.
• Which will take you to “Scripts - Add a Schedule”
• Give a name to the schedule, select the group, for which you want this to be run,
• The schedule type namely “Hourly, Daily, Weekly”
• Finally say “Add schedule”. Now you have successfully added a schedule to the script.

Once the Perl script has been executed on the DFM server, the information is collated into a CSV file named, ‘ScriptOutput.csv’. The output file can be located on the DFM Server in the following location:

• Windows: <installation directory>\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\ScriptOutput.csv

  Default Location: C:\Program Files\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\ScriptOutput.csv

• Linux: <installation directory>/NTAPdfm/script-plugins/PM_Extractor/ScriptOutput.csv

Default Location: /opt/NTAPdfm/script-plugins/PM_Extractor/ScriptOutput.csv

Please follow this procedure and let us know if you still have the issue.

Thanks & Regards,

Pavan

[NEILHOLMES]

Hello Adai,

I'm afraid Mohammed has a point with regards the execution of the script. I too get the following message:

Execution of 'perl C:\Program Files (x86)\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\PM_Extractor.pl' failed.

Reason: The system cannot find the file specified

I believe I know why, I'm just not sure where to rectify it. When ran at a cmd window (as admin), the following two syntax fail:

'perl C:\Program Files (x86)\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\PM_Extractor.pl'

perl 'C:\Program Files (x86)\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\PM_Extractor.pl'

whereas this syntax runs:

perl "C:\Program Files (x86)\NetApp\DataFabric Manager\DFM\script-plugins\PM_Extractor\PM_Extractor.pl'"

Based on other forum posts, it seems the failures are caused by the spaces in the path which the double quotes rectifies.

I got the ScriptOutput.csv created running it this way, but it would be nice to know what to change so that Ops Mgr schedules the file creation.

[ppavagad]

Hi Neil,

Are you extracting the .pl file from the archive and later executing the PM_Extractor.pl file?

You could directly schedule it from the Operations Manager as a script-plugin.

Thanks & Regards,

Pavan

[NEILHOLMES]

Hi Pavan,

Sorry, I should have been clearer. It is when the script is added into Operations Manager as a script that the problem occurs. Adding, scheduling and executing the script works fine. A jobs folder is created and a <job>.out file created when the job runs as scheduled.

The message previously mentioned is what the <job>.out file contains. Needless to say, a ScriptOutput.csv file is not created.

When I bypass Operations Manager and run the perl script manually in a cmd window, I can get it to work.

Regards,

Neil.

[ppavagad]

Hi Neil,

Thanks for your reply and your inputs.

Could you please run dfm about command on your DFM server and post the output here? I will try to investigate the same and will get back to you.

Thanks & Regards,

Pavan

[NEILHOLMES]

Pavan,

find attached the requested information. I have only changed the company system details to 'confidential' for security reasons.

By way of reference, here are some other reports of similar issues:

https://communities.netapp.com/thread/15270

https://communities.netapp.com/thread/27220

Regards,

Neil.