linux

51 Topics

OpsCenter Daily Failure Report
I have the following report but it seems to only display the first 50 lines. I cant seem to find a reason as to why it would do that. I have also tryed changing from a select distict to select 500 starting at 1, but that did not make a difference. Here is the code i am using: SELECT DISTINCT B.friendlyName as 'Master Server', A.clientName as 'Client Name', A.policyName as 'Policy Name', LIST( DISTINCT A.statuscode) as 'Status Code', ( select DATEDIFF(DAY,UtcBigIntToNomTime(MAX(CKP.endTime)),GETDATE()) as 'Days since Last successful' from domain_JobArchive CKP where CKP.masterServerId = A.masterServerId AND CKP.id = CKP.parentJobId AND CKP.clientId = A.clientId AND CKP.policyId = A.policyId AND CKP.policyName = A.policyName AND CKP.policyType = A.policyType AND ( CKP.statusCode = 0 OR CKP.statusCode = 1 ) ), ( select UtcBigIntToNomTime(MAX(BKP.endTime)) as 'Last successful' from domain_JobArchive BKP where BKP.masterServerId = A.masterServerId AND BKP.Id = BKP.parentJobId AND BKP.clientId = A.clientId AND BKP.policyId = A.policyId AND BKP.policyName = A.policyName AND BKP.policyType = A.policyType AND ( BKP.statusCode = 0 OR BKP.statusCode = 1 ) ) FROM "domain_JobArchive" A , "domain_masterserver" B WHERE A.masterServerId = B.id AND A.id = A.parentjobid AND DATEDIFF(hour,UtcBigIntToNomTime(A.endTime), GETDATE()) <= 24 AND ( select DATEDIFF(DAY,UtcBigIntToNomTime(MAX(CKP.endTime)),GETDATE()) as 'Days since Last successful' from domain_JobArchive CKP where CKP.masterServerId = A.masterServerId AND CKP.id = A.parentJobId AND CKP.clientId = A.clientId AND CKP.policyId = A.policyId AND CKP.policyName = A.policyName AND CKP.policyType = A.policyType AND CKP.scheduleType = A.scheduleType AND ( CKP.statusCode = 0 OR CKP.statusCode = 1 ) ) > 0 AND A.statusCode not in (0,1,190,199,230,239,240,800,1000) AND A.policyName NOT LIKE 'SLP_%' AND A.type IN (0,22,28) AND A.scheduletype not in (-1,2) Group by A.clientName,A.masterServerId,A.policyName,B.friendlyName,policyType,scheduleType,clientid,policyid ORDER BY B.friendlyName, 'Days since Last successful'
Solved
nbritton
9 years ago Place OpsCenter
3.1KViews
0likes
11Comments
Get deduplication ratio per DiskPool
I am looking for an OCA report that shows the dedup ratio that you find in the "Deduplication Ratio" field using the method below: NetBackup Administration Console, expand Media and Device Management > Credentials > Storage Server Do I need to code something in SQL to achieve this? There are a couple reports templates like dedup space savings, but I just need the ratio like 9.8, no fancy stuff. Second prize would be a command that I can just cronjob. Like an nbdevquery, I've come up with nothing so far. Thanks
Solved
Chris_W
9 years ago Place OpsCenter
1.4KViews
0likes
3Comments
Opcenter Atutil
Hi, I am planing to upgrade Netbackup Ops center from 7.6.0.2 to 7.6.1.2. I have a doubt with AT. I don't have LDAP or AD authentication is my environment, Do I still need to export the authentication settings using atutil before the upgrade and import back after the upgrade?
Solved
jmane
9 years ago Place OpsCenter
2.1KViews
0likes
3Comments
OpsCenter Report generating slow
I'm running OpsCenter 7.7.1 on RHEL 6.7. It's a VM running in ESXi 5.5. We only have 1 RHEL 6 master server and 4 media appliances. The rest of the environment is running 7.6.1.2. This was set up by someone else over a year ago I inherited it. We have a quarterly report we run for all backup jobs. It's part of our compliance process. We haven't had any issues until the recent Q4 report. I've only got it to successfully run twice but couldn't export or email it. The export failed with a 0 byte file even though I could see the data on the screen. I notice that it takes forever to run, just get the working cursor and it spins forever. One time it ran for 20 minutes and produced data. Most times nothing and I adjusted the timeout value for the GUI so I can let it run. So far other reports I try run OK. But I did notice earlier when I emailed a different report it took a really long time. Roughly 15 -20 minutes. I've gone through the Performance and Tuning guide and changed heap sizes for OpsCenter service, OpsCenter web service, and db cache. I didn't find an agent. I defrag'ed the database too. I adjusted the VM and gave it 4 CPU's and 16G of RAM. The database files are only around 1.5G. I do notice that the OpsCenterDBd process consumes all the CPU's and pegs them at 100%. I was running OpsCenter 7.6.1.2 but I updated it hoping that it would fix it. No luck. Any ideas?
Solved
BeardedOne
9 years ago Place OpsCenter
969Views
0likes
2Comments
Opscenter Integartion with Netcool alerting tool
need help in understanding the way to configure the snmp alerts in Opscenter and how these can be passed to Netcool alerting tool. In a simpler way how can we integarte Opscenter with Netcool.
Jivitesh
9 years ago Place OpsCenter
661Views
0likes
2Comments
Netbackup OPS center reporting for EMC Networker
Can we use Netbackup 7.7 OPS center for reporting of EMC Networker 8.1.8.2. I have not found any procedure in Netbackup OPS center 7.7 administrator guide how I can configure ops center with Networker Do i required to install netbackup client on Networker Server? Is there anyprerequisites?
Solved
sumitgree
10 years ago Place OpsCenter
536Views
0likes
1Comment
How to export all policy attributes,config,and others such as throughput using the sql query?
Our backup system has been on line for a long time,many demands have changed,so we want to optimize all policy, We tried to use bppllist command to export all policy attributes and config,but the result is not intuitiveusing,so we want to using the sql query to export all policy attribute,config,also contain the throughput last month,Who can help me to design the right sql query? Thank you!
Solved
zhuqingedu
10 years ago Place OpsCenter
2.1KViews
2likes
11Comments
Upgrade of Ops Center Analytics from v7.5.0.7 to v7.6.x.x
Hello All, We are planning to upgrade our ops center analytics from v7.5.0.7 to v7.6.x.x. Please suggest to which latest version we need to upgrade ops center too. Also please provided some steps that we need to follow.
nbu123
10 years ago Place OpsCenter
1.6KViews
0likes
9Comments
oracle job duration is not correct
hi friends i use netbackup 7.5 and opscenter for reporting. type of some of policies are oracle database. and they have several channels to do the backup. when i use job duration report for the policy it sum measure of all channels. for example i know job duration must be 40 hours but becouse of 5 channles it show me 200 hours. is there a way to count exaclt measure of this kind of policy? Thanks Best Regards
kms11
10 years ago Place OpsCenter
1.1KViews
0likes
9Comments
CSV delimiter in opscenter 7.6.1.2
Hello, I need to change CSV delimiter "," in my reports. How can I proceed ?
touldavl
10 years ago Place OpsCenter
504Views
0likes
2Comments