Opscenter SQL query for oracle and SQL Job Instance and Client name
Please provide with Opscenter SQL query for oracle and SQL Job Instance and Client name Client-nameJob-InstanceStatus codeStart Date and Time End Date and Time
Please provide with Opscenter SQL query for oracle and SQL Job Instance and Client name Client-nameJob-InstanceStatus codeStart Date and Time End Date and Time
I need to create a report that shows success rate\number of failures by policy. So on one policy I have 115 clients and need a report that shows me number of failures and percentage complet\failed by date. As an example I have 7 backup policies rang...
I am trying to find the OpsCenter equivalent to the Netbackup 7.6.x Recoevery Report. The issues is I need a Recovery Report from Oct. 2015. My Netbackup > Reports > Vault Reports > Recovery only goes back ~30 days. I have looked through the OpsC...
Hi All, Need steps/doc./requirements to upgrade OpsCenter server to version 7.7.3 Thanks
Updated a bunch of clients to NetBackup 7.7.2 and then ran this query to see which might have been missed. It's showing most of the updated clients as older version. Also lists some clients which were decommissioned years ago. Is there a way to ref...
Good Morning All, I am looking for two custom SQL Query's for OpsCenter 7.6 that will output all backup jobs that have been running for more than 16 hrs. This would cover all jobs in the privious 24 hrs. First query would be for all non-NDMP serve...
Hello, is there an easy way "how-to" to setup a daily email report on failed backups for each group like SQL, MySQL and/or Oracle using template? Thanks, BV
Hello, I,m trying to use this query : SELECT DISTINCT A.clientName as 'Client Name', A.policyName as 'Policy Name', A.scheduleName as 'Schedule name', LIST( DISTINCT A.statuscode) as 'Status Code', ( select DATEDIFF(DAY,UtcB...
Hello Im currently using the 'clients not backed up' template set to look at 7 days but it is reporting on deactivated as well as active policies so the report is huge and not suitable for what I need it for. Does anyone have an idea or solution to...
Hi, I have recently upgraded my OPSC from 7.6.0.3 to 7.7.1. I've tried to connect to database via 'dbisqlc' and recieved popup with "Database server not found" message. I think that I gave proper user/pass and database name: user: DBA pass: SQL ...
Hi, I am looking for solution how to prepare the report for backups of Oracle databases. I need the report which will have the columns: PolicyName | AvgWrittenSize | ClientName | MediaServerName | AvgTimeDuration I can get AvgTimeD...
Does anyone else have SQL DBA's asking for reports that show what databases have failed durring a backup. I am being asked to provide a report that will show the db that failed, not only the server, or instances but the database. How is anyone els...
Hello, I'm playing with SQL query in OpsCenter but I don't understand the difference between domain_*, nom_* and nb_* tables. For example we find many similar informations in domain_Policy, nom_NBPolicy and nb_Policy tables. It seems redundant... ...
Hello, My customer wish to figure how much storage is used per client on NetBackup. I guess that it is feasible via OpsCenter but I don't know how. Can someone help me ?
We are upgrading our OS....Currently i have Opscenter 7.5 installed on WIndows 2003 SP2 and is working fine. I installed Opscenter 7.6.1 on Windows 2012 VM environment. The installation was successful and I launched OpsCenter without error before re...
I need help writing a query that I assume needs a join or inner join that I cannot figure out, and my SQL knowledge is to be desired. So here is what I am trying to do...First the tables and columns. Tables and Columns that have the data I need. ...
Hi, I am having some issues with ops center, i am doing some alert testing with ops centre Version 7.6.0.1 and i have even created a problem on a server so that the ops centre will send an alert (aswell i have purposely not fixed the problem on th...
I currently am on Version 7.6.0.4 (Build 20141024) of OpsCenter and I have a query that gives a list of failed backups. I need to give the user date range functionality but imbedding that code within the Query itself is yeilding only error messages :...
Greetings, I have a business need to generate reports for each of my admin teams by Client OS, RHEL, AIX, HP-UX, Windows, etc...etc... The report would include the following columns. -------------------------------------------------------------...
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 c...