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

[reide]

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.

[kjag]

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

[reide]

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.

[kjag]

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

-KJag

[kjag · Accepted solution]

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

[reide]

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

[kjag]

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

[adaikkap]

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

Regards

adai

[reide]

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.

[marlon]

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

[reide]

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.