03-02-2017 02:50 PM
Hello Folks,
I have attached an OPS Centre Analytics (7.7.3) SQL report which I think I convieniently picked up from one of these forums sometime ago. It shows the backup policy details (Policy Name, Client Name, Schedule, Backup Windows, Start Time, and Duration) for an NBU master server.
I'm not a great SQL person, but does anyone know how to add the details of the Backup Selections and the Storage Unit into this report?
Thanks
03-16-2017 01:47 PM
I have created Custom Report, i am not sure if my query will help you. I will draft what I have done, hope it will works for you. Login to OpsCenter and create a custom report manually. Don't use any report templates.
Reports->Custom Report-> Category(Backup/Recovery), SubCatergory(Job/Image/..), Type - Tabular -> Select Time Frame (select granularly if you prefer) -> Choose Columns : Client Name, Policy Name,
Job Directory,Job Size,Job File Count,Job Start Time,Job End Time,Job Status,Job Duration, Schedule Name, Storage Unit -> Run Report
Let me know if this works for you.