SQL query - Backup policy report
Hi, I'm trying to get a report with the following fields "Policy Name" "GB Written" "Master Server" I tried to get the report by 2 ways SELECT distinct d.policyName AS "Policy Name", CAST(SUM(d.sizeOfImageInKBytes)/1024/1024/1024 AS DEC(8,2)) AS "GB Written", m.masterServerName AS "Master Server" FROM domain_image d, nom_NBJob m WHERE DATEDIFF(day,UTCBigIntToNomTime(d.writeEndTime), GETDATE()) <= 1 AND d.masterServerId=nom_NBJob.masterServerId GROUP BY d.policyName, m.masterServerName ORDER by 1 SELECT distinct d.policyName AS "Policy Name", CAST(SUM(d.sizeOfImageInKBytes)/1024/1024/1024 AS DEC(8,2)) AS "GB Written", m.masterServerName AS "Master Server" FROM domain_image d INNER JOIN nom_NBJob AS m ON d.masterServerId=m.masterServerId AND DATEDIFF(day,UTCBigIntToNomTime(d.writeEndTime), GETDATE()) <= 1 AND d.backupStatus=0 GROUP BY d.policyName, m.masterServerName ORDER by 1 But both queries are taking much time to get the information, is there a way to improve the performance of the query or another query to get the required information?
Custom Query in Ops Center
Hello there, I'm attempting to create a query in Ops Center to accomplish the following report: Client name, policy name, backup window, retention period The problem is that I know jack about SQL queries and I don't see any way of creating this report outside of a custom query. Any advice or pointers here are appreciated. Thank you.
OPS center - documentation for table of DB
Hello, i'm new on NBU. I have tried to do some reports using OPSCenter but the template reports does not contain the info i need. I have looked in the documentation if there is a list of table/columns for report based on my SQL. I haven't found anything ... I have read in a post that when report is displayed i can see the sql with a button... i haven't found the button! Can anyone help me? OPSCenter 7.0 running on windows system. Thanks, Sergio
Veritas Backup Reporter and SQL
I've got a few SQL related questions about Veritas Backup Reporter if anyone can help me! First question: Is it possible to setup VBR to utilise a Microsoft SQL database server instead of the ianywhere database? Second Question: We are after an SQL query to determine the day of the month with the biggest amount of volume, then show which Netbackup Clients and policies, etc that contributed towards the biggest amount of volume used. Has anyone written a query for this currently or know of a way to automate this using the current reporting scripts? We are currently using Version: 6.6.2 (Build 20091213)
