2013-05-14 02:43 AM
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 22.214.171.12464 (5.0.1). Would appreciate any help. Thanks
Solved! SEE THE SOLUTION
2013-05-14 10:53 AM
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
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.
2013-05-15 07:12 AM
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|
2013-05-16 06:45 AM
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.
2013-06-14 12:49 AM
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.
2013-06-17 09:50 PM
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,
Edit: Updated ReadMe.doc in the ScriptPlugin.
2013-06-18 12:27 AM
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.
2013-06-18 04:19 AM
Happy that its really helping you and find it useful. Let us know if you have any ideas or improvements needed in the script.
2013-06-18 08:12 AM
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