Please help me to obtain the start and end time of a package line in a package. either infrontend or by a qry in db.
Please clarify what you mean by the start and end time of a line?
Depending on the workflow, each line may be used to drive an execution several times (e.g. a migration to UAT, later followed by a migration to PROD).
Are you interested in the time the workflow steps (manual or automatic) were executed?
Or are you more interested in the time taken by the executions?
If you look at the line transaction history from the workbench you can get an indication of the former:
If you look at the package execution logs from the workbench you can get an indication of the latter:
From the different hyperlinked logs you can get execution start and end times.
Thanks for the note.
but we have nearly 200 lines in a package and the user wants the start and end time of each lines in a particular step commands!!
Note:we use ITG for other applications for thier deplyoment.
HP has provide "Package History Report", you can get all your details from this report.
It can be accessed from Create->Report>Deployment Management->Package History Report.
If you want the custom result, then you can view the SQL queries within this reports.
Thanks for the note. But still there is no information on start and end timeing of a command execution in a package lines :(
This report shows the "Execution step" start time.
In case you want to get individual command start and end time, then for this you need to "Grep" the log files...
The reason I m saying this is that in PPM the execution steps time is logged but the individual commnad execution time is not logged, the only way is to get it from the package logs.