How to create a job report with job name start & stop times and tape label from backup exec 2012

[RMullis]

I have looked through all of the stock reports and tried to create a custom report to list Job Name, Date, Start Time, End Time, Duration and Media (Tape Label) but I am unsucessful. The closest report is Media Required for Recovery but it doesn't show that actual job name. I don't want to have to print out each Job Log that is emailed to me and look through that every time. We are bound by Sarbanes-Oxley (SOx) regulation and therefore are required to print a log list of our backup jobs sorted by Job Name, then by Backup Date. Can anyone assist me with this?

Thanks,

[pkh]

You can use the following BEMCLI command to get what you want

Get-BEJobHistory | Select-Object JobName, StartTime, EndTime, StorageName

The date is included in the start time.  The above command get all the job history.  You might want to use the Where-Object to filter the jobs that are included

You might want to read my articles on BEMCLI first

https://www-secure.symantec.com/connect/articles/preparing-your-powershell-environment-run-bemcli-and-scripts

https://www-secure.symantec.com/connect/articles/how-send-bemcli-results-e-mails

[RMullis]

WOW, great information. I love the powershell info from your 2 links too. I will give this a try and let you know. Thank you very much.

Rick

[RMullis]

Close but it does not display the media name. Trying to grab info from Get-BEJobHistory & Get-BEMedia but can't figure oput how to merge above list command and get-bemedia info into one log file. Any ideas?

Rick

[pkh]

Give me some screenshot/more info on what information that you are trying to get?  What do you mean by not displaying the media name?  What is shown in the Storagename column in the job history?