2012-01-30 02:56 PM
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.
Solved! SEE THE SOLUTION
2012-01-30 07:23 PM
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
objId Relationship ID
srcName Source Name
dstName Destination Name
transStart Transfer Start
transEnd Transfer End
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.
2012-01-31 06:55 AM
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.
2012-01-31 07:01 AM
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.
2012-01-31 07:14 AM
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
2012-01-31 07:39 AM
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.
2012-02-02 09:05 AM
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...)