topic Re: OnCommand 5.0: Can reports show Protection Manager job start & end times? in Active IQ Unified Manager Discussions

OnCommand 5.0: Can reports show Protection Manager job start & end times?

reide — Thu, 05 Jun 2025 06:36:10 GMT

I have a customer who wants to run a report in OnCommand 5.0 that shows the start and end time for Protection Manager jobs. Using the CLI, I can find this information on a per-job basis (dfpm job detail <job-id>).So I know its in the database somewhere. However, I cannot find any catalog that allows me to show this information in a DFM custom report. Is there any way in Operations Manager 5.0 or the newer OnCommand 5.0 Console reporting engine (based on BIRT) to show the job id #, start-time & end-time of Protection Manager jobs?

I'm not aware of anything in the Protection Manager GUI interface itself that would show this information. True, you can look at an individual job in PM, but I want to see all jobs listed in a report format.

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

kjag — Tue, 31 Jan 2012 03:23:09 GMT

Hi,

You can refer the below report to get Start and End time of a data transfer. But this is reported at relationship level(we cannot see the details for each Job) for all the data transfers.

[root@mei-rhel5u6x32-179-96 ~]# dfm report view dp-transfer-mirror-individual help

DP Transfer Mirror, Individual Report (dp-transfer-mirror-individual)

DP Transfer Mirror, Individual

Columns:

objId Relationship ID

srcName Source Name

dstName Destination Name

status Status

transStart Transfer Start

transEnd Transfer End

transTimeSeconds Duration

transKBs Bytes Transferred

transRate Transfer Rate /sec

SImilarly this report available for Backup relationships also.

# dfm report list|grep -i transfer

dp-transfer-backup-individual DP Transfer Backup, Individual

dp-transfer-backup-daily DP Transfer Backup, Daily

dp-transfer-backup-weekly DP Transfer Backup, Weekly

dp-transfer-backup-monthly DP Transfer Backup, Monthly

dp-transfer-backup-quarterly DP Transfer Backup, Quarterly

dp-transfer-backup-yearly DP Transfer Backup, Yearly

dp-transfer-mirror-individual DP Transfer Mirror, Individual

dp-transfer-mirror-daily DP Transfer Mirror, Daily

dp-transfer-mirror-weekly DP Transfer Mirror, Weekly

dp-transfer-mirror-monthly DP Transfer Mirror, Monthly

dp-transfer-mirror-quarterly DP Transfer Mirror, Quarterly

dp-transfer-mirror-yearly DP Transfer Mirror, Yearly

dp-transfer-dataset-daily DP Transfer Dataset, Daily

dp-transfer-dataset-weekly DP Transfer Dataset, Weekly

dp-transfer-dataset-monthly DP Transfer Dataset, Monthly

dp-transfer-dataset-quarterly DP Transfer Dataset, Quarterly

dp-transfer-dataset-yearly DP Transfer Dataset, Yearly

If the JobId is must, then we can write a script plugin to report the JobId, Start Time and End Time.

-KJag

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

adaikkap — Tue, 31 Jan 2012 04:33:35 GMT

The Data-Jobs page of NMC shows the start and end time of dataset. Pls find the attached screen shots.

Regards

adai

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

reide — Tue, 31 Jan 2012 14:55:03 GMT

Kjag,

A script plug-in for this would be greatly appreciated. None of the responses to-date provide what the customer is looking for. I also suspect this won't be the last time someone asks for this information.

Thanks.

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

reide — Tue, 31 Jan 2012 15:01:42 GMT

Adai,

True. The jobs page shows all the information the customer is looking for. However, it still doesn't provide what the customer wants. They want to be able to run this as a report just like other DFM reports, e-mail it to their inbox, in a format that they can import into Excel (.csv, or .xls). In the NMC, it appears you can't export the data from the Data->Jobs page. You can only look at it.

It would be great to see a "dfpm jobs" catalog added to the custom reporting feature of DFM 5.x, or a new report added to the OnCommand 5.0 BIRT engine to report on Protection Manager jobs.

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

marlon — Tue, 31 Jan 2012 15:14:13 GMT

You can try the following

dfpm job list -x | sed -n -e '/Job Id/p' -e '/Start/p' -e '/Completed/p'

When I ran it I got this output

Job Id: 3

Started Timestamp: 30 Jan 2012 03:43:20

Completed Timestamp: 30 Jan 2012 03:52:48

Job Id: 2

Started Timestamp: 30 Jan 2012 03:43:17

Completed Timestamp: 30 Jan 2012 03:52:48

Job Id: 1

Started Timestamp: 30 Jan 2012 03:43:14

Completed Timestamp: 30 Jan 2012 03:52:27

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

reide — Tue, 31 Jan 2012 15:39:37 GMT

marlon,

Thanks. Again, this is useful, but doesn't deliver what the customer is looking for. They want a tabular report listing each job on a single line, much like other DFM reports. They'd have to write a Perl script to extract all this data, massage it into a single line, and format it as a report. I'm trying to help them avoid that.

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

kjag — Tue, 31 Jan 2012 16:23:49 GMT

sure. I will provide you a script plug-in by tomorrow.

-KJag

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

kjag — Wed, 01 Feb 2012 15:21:06 GMT

Please find the script plugin from the below location.

Go through the ReadMe Document for adding them into DFM and viewing the report.

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

-KJag

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

reide — Thu, 02 Feb 2012 17:05:12 GMT

kjag,

Thank you for the quick turnaround! This will work. Eventually, it would be great to see this type of report available within OnCommand with the full reporting functionality (formatting, scheduling, e-mailing, etc...)

Reid

Re: OnCommand 5.0: Can reports show Protection Manager job start & end times?

kjag — Thu, 02 Feb 2012 17:29:45 GMT

Its possible to crate a report, even my initial script does the same

But the problem here is the comment field is not available as a custom "field" for the object type "Dataset". So we need to stick to "datasets, comments" canned report available in OnCommand to populate the JobId, Starttime,etc.Its having two issues.

1. We can't change the coloumns order

2. The report by default having fields "dataset name","description" ,etc. We cannot delete this fields.

Please find the attached image to see how the report look likes. If you are still interested i will share that script too.

-KJag