Opscenter/netbackup - SQL query to have a weekly report: Policy with start Time and End Time
Hello, The goal is to have a gantt diagramm (made with excel)for the last weekthat show for each policy the start time and the end time. I found some report on opscenter to have this kind of information but only by client. I would like to have a SQL query that give me these informations on a policy basis. Exemple: Policy name Start Time End Time (or duration) Policy 1 27.07.2015 22:00 27.07.2015 23:18 Policy 2 27.07.2015 22:30 27.07.2015 23:01 Policy 1 28.07.2015 22:00 28.07.2015 23:19 .... Do you have any idea on the best/easiest way to do that? Regards JaySolved4.2KViews0likes12CommentsLooking for custom OpsCenter Analytics SQL Script
Looking for custom OpsCenter Analytics SQL Scripts that was used during the Symantec Vision 2010. I have attached the document were it references the scripts text files that contain the script information. This might be a hard find but if any one could share those scripts I would appreciate...Thxs OCA Custom SQL 1.txt andOCA Custom SQL 2.txtSolved3.9KViews1like10CommentsHow to generate a report on all Backup jobs/policies with schedule,start time and retention
Dear All, We have recently implemented Netbackup 7.5 as our enterprise backup solution. I need a report for managers with the below columns Netbackup Policy Name Job name Schedule (daily/weekly/monthly) Start time retention Please advise how i can i acheive this. Regards, Mohamed Sahal3.6KViews1like3CommentsOPS ANALYTICS CUSTOM REPORT (SQL QUERY)
We need help in order to create a custom report at OPS , attached you will find a template of the report as our Management team asked to be created. We have bought Analytics License and all our efforts for the creation of the custom reports have failed. Is there a way to add the retention period at a report ?Solved3.5KViews0likes14CommentsOpsCenter - "Fatal error during installation" (upgrade from clean 7.5 to 7.5.0.4)
Hello, I have searched for any information about this but only found basic information and not real solution. The problem is with upgrading OpsCenter 7.5 to 7.5.0.4 Maintenance Pack. I am installing a clean OpsCenter software (basic version, not Analytics), version 7.5. Then I try to upgrade to 7.5.0.4 version but it always fails at Database Schema Upgrade stage and rolls back to 7.5 version with “Fatal error during installation”. The log does not give me any useful information. In the past I had issues upgrading from OpsCenter 7.0.1 to 7.5 (I had to scratch the database and install it clean, then I was able to “upgrade” – now I cannot even upgrade from a clean version of 7.5 to 7.5.0.4). A fragment of the log: 10-16-2012,13:20:47 : Started Service: SQLANYs_VERITAS_OPSCENTER 10-16-2012,13:20:47 : Started Service: OpsCenterServer 10-16-2012,13:20:47 : Started Service: OpsCenterWebServer 10-16-2012,13:20:47 : SRVRCustAct[Exit]::StartOpsCenterServerServices 10-16-2012,13:20:47 : GetLastErrorStringEntering Function GetLastErrorString 10-16-2012,13:20:47 : GetLastErrorStringExiting Function GetLastErrorString With return value Fatal error during installation. on Line No. 272 10-16-2012,13:20:47 : Return value for the Install action is : 1603 Error String : Fatal error during installation. 10-16-2012,13:20:47 : Call the API for Post Install configuration 10-16-2012,13:20:47 : CDlgInstallProgressBase::InstallProductExiting Function CDlgInstallProgressBase::InstallProduct With return value 1603 on Line No. 158 10-16-2012,13:20:47 : CDlgInstallProgressBase::OnInstallStopEntering Function CDlgInstallProgressBase::OnInstallStop 10-16-2012,13:20:47 : GetLastErrorStringEntering Function GetLastErrorString 10-16-2012,13:20:47 : GetLastErrorStringExiting Function GetLastErrorString With return value Fatal error during installation. on Line No. 272 10-16-2012,13:20:47 : Fatal error during installation. Operating System: Windows Server 2008 Standard SP2 x64 Has anyone ever found any real solution for this?3.3KViews1like21CommentsCustom OpsCenter SQL Queries needed.
Hi everyone, We are using Netbackup 7.6.1.2 and OpsCenter Analytics 7.6.1.2 In NBU Admin Console, under Reports there are 2 reports that I would like to customize if theunderlying data is available in the OpsCenter DB andI can get the SQL Queries for those reports. Report1: Images on Tape (under Tape Reports) Report2: Images on Disk (under Disk Reports, can be filtered by disk type) If the reports are fetching the data from the OpsCenter DB would it be possible to obtain the executing sql statements by Tracing ? Any help will be appreciated. Regards, Sezgin2.8KViews3likes5CommentsOpsCenter report export discrepencies
Morning, I'm having very basic, but irritating issues with OpsCenter included with out NetBackup 7.1.0.2 installation. OpsCenter is the free version. I have daily reports of backups that succeed or fail. On a daily basis I export these and use them for reporting. When I export, I like to do so via CSV as it allows me to remove the parent jobs that I cannot remove through the report configuration itself. However, when exporting to CSV, there seems to be a limit of 266 rows. As the report extends beyond 266 rows I end up losing a small amount of report data. When exporting to PDF I get all data, but can't edit it as I can with a CSV in Excel. I initially assumed it would be an Excel issue, however the imported CSV shows the "report generated on" line on 266. The same issue applies to XML exports. Does anyone know how to fix this issue? If I could exclude the parent jobs this wouldn't even be an issue, which is possibly the most annoying aspect of this. Thanks, Jason2.8KViews1like14CommentsOpsCenter is not connecting with the Master Servers
Hey guys I had OpsCenter setup with two Master Servers. All was working fine until suddenly two days ago OpsCenter stopped showing the reports and started showing that it is not connected to the master servers. The network connection is up. Any suggestions are welcome. P.S. If anyone have a guide to get the most out of OpsCenter that'd be great.2.7KViews0likes8CommentsTabular Custom Report OpsCenter from Image Information
Hi Everyone! We are using Netbackup 7.6.0.4 and OpsCenter 7.7. We are working with custom report but we are having problems to create report. We need a report like BPIMAGELIST but using VIEWS, because there are many groups of clients that we need create these reports. I need client name and Total Job Protected Size or sizeInBytes from images. We had to create a new OpsCenter so we don´t have history jobs only information from Images from catalog. I´m trying to create a report from images but OpsCenter does not show what I want from tabular custom report. I am trying to create: Custom Report > Tabular > No Time Basis / Image Copy Expiration Time or Image Expiration Time > Select Client Name and Job Protected Size. Any help will be appreciated! Thanks! Regards, TominagaSolved2.5KViews0likes11Comments