Subscribe
Accepted Solution

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

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?

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?

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?

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?

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?

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?

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?

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?

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?

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