Backup Image Retention Summary by Client Report Needed
Report that shows the retentions to avoid or identify retentions that deviate from standards of tapes held more than 90 days. If backup is still active, fields include: Server Name;Client Name;Policy Name;Schedule Name;Retention in days for different schedules-->[Daily;Weekly;Monthly:Yearly:Others;] Retention is based on a policy not a client;Report that shows the retentions to avoid or identify retentions that deviate from standards of tapes held more than 90 days.
Custom report to show Deactivated Policy(ies) needed ASAP please!
I'm totally new to Backup Reporter and while I've done *some* in the past, it's not my forte. I'm going to see what tutorial(s) are available to help me become proficient, but right now, time is precious. What I need to create is a report for my VP of IT that shows what Backup Policy or Policies are currently deactivated. Thanks!!
NetBackup Master or Media Server Unreachable Report
I haven't been able to create a report which provides a history of when a Master or Media Server was unreachable. we get pages when a Master or Media Server is unreachable, but for looking back in time it would be helpful to have a report showing when a Master or Media Servery was unreachable. I have started investigating using Alerts information and writing some SQL; is there an easier way? This report would be particularly helpful when auditing backups and identifying any missed backups.We have approximately 60 Master Servers. Thank you for any advice or suggestions! Steve
Opscenter: Report to retrive old policy configuration
Hi, is it possible to pull out old policies information(Policy type, storage unit(what i need)) just to make comparison between the current configuration with the old configuration? i tried using the policy comparison function on the opscenter but it didnt show what i want which is the previous storage target. Please advise.OPScenter report on servers top 20 biggest consumer.
Hi, i wish tohave a report that shows up the top 20 biggest (in data and backup size) servers for over the last 2 years (interval 1 month). is there a template because i couldnt find it or can anyone help meby providing the SQL query? any help will be very appreciated. thanks. Regards. Aris.
OpsCenter SQL query problem
Hi I have a SQL query im using to generate a report showing last succesful back up after a failure on all clients, looking at data from the last 7 days. The report is perfect except I want it to not include entries where the last succesfull back was less than 2 days ago. This is what im using at the moment SELECT DISTINCT B.friendlyName as 'Master Server', 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,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.scheduleName = A.scheduleName AND CKP.statusCode = 0 ), ( 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.scheduleName = A.scheduleName AND BKP.statusCode = 0 ) FROM "domain_JobArchive" A , "domain_masterserver" B WHERE A.masterServerId = B.id AND A.id = A.parentjobid AND DATEDIFF(day,UtcBigIntToNomTime(A.endTime), GETDATE()) <= 7 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 ) >1 AND A.scheduleName != 'user_backup' AND A.statusCode not in (0,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,A.scheduleName,B.friendlyName,policyType,scheduleType,clientid,policyid ORDER BY B.friendlyName , A.clientName I have tried changing >1 to >2, I have also tried != (0,1), i have also tried not in (0,1). The problem is as far as i can tell the section i have changed to bold below is doing nothing. I can even remove this section from the query and it makes no difference to the report. This is the section i believe i can use to filter out 0 and 1 from the last succefull back up field but as it does nothing im not getting very far! WHERE A.masterServerId = B.id AND A.id = A.parentjobid AND DATEDIFF(day,UtcBigIntToNomTime(A.endTime), GETDATE()) <= 7 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 ) >1 AND A.scheduleName != 'user_backup' AND A.statusCode not in (0,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,A.scheduleName,B.friendlyName,policyType,scheduleType,clientid,policyid ORDER BY B.friendlyName , A.clientName Every thing I have tried has failed to remove entries where the last succesful back up was less than 2 days. Has anyone get any suggestions or fixes for this. I have next to no sql knowledge and have only delved into this to create a very specific report that can run every day and be sent out to our ops team. Any help will be greatly appreciated. Thanks in advance for any help Matt
