Recent Discussions
NBU IT Analytics Success rate graphs for Host/Server Groups
Currently, we are utilising the standard Backup SLA graph in IT Analytics, which includes job columns, volume, success SLA, and success rate. However, this graph tends to be rather cluttered and confusing. Has anyone made a success rate graph on that uses aline graph or any other format that clearly depicts this metric for the host groups without the additional data points such as # of job columns and volumes or SLA line. Is there a graph that comes standard in IT analytics that has the above or if anyone is willing to share one?
Aptare SQL query question
I need help with the following SQL query to generate a report for backup jobs that had failed more than 2 days so I can feed the results to our automation ticketing system. (the query used to work before but now it does not)...If anyone can point out what could be wrong.... WITH get_var AS ( SELECT TRUNC(sysdate) - TRUNC(sysdate-2) nbr_of_days FROM apt_v_dual ) , get_last_backup_date AS ( SELECT client_id, TRUNC(sysdate)-TRUNC(MAX(finish_date)) last_backup FROM apt_v_job WHERE summary_status < 2 AND finish_date > sysdate-45 GROUP BY client_id ) --select * from get_last_backup_date; ,get_counts AS ( SELECT to_char(start_date,'MM/DD/YYYY') the_date, client_id, server_id, rtrim(lower(client_name),'.') client_name, MAX(vendor_status) max_vendor_status, NVL(SUM(DECODE(summary_status,0,1,0)),0) success_count, NVL(SUM(DECODE(summary_status,1,1,0)),0) partial_count, NVL(SUM(DECODE(summary_status,2,1,0)),0) failed_count FROM apt_v_job WHERE start_date BETWEEN sysdate-2 AND sysdate AND client_id <> server_id AND job_type IN ('101','102') AND vendor_status NOT IN ('90','129','150','99','230','239','240','245','196','999999') AND rtrim(lower(client_name), '.') NOT IN (select distinct lower(media_server_name) from apt_v_nbu_media_server) AND client_name NOT like 'nbum%' GROUP BY to_char(start_date,'MM/DD/YYYY'), client_id, server_id, rtrim(lower(client_name), '.') ) -- select * from get_counts; , get_sums AS ( SELECT c.client_id, c.server_id, s1.display_name client, s1.os_platform, s2.display_name master, MAX(lb.last_backup) last_backup, MAX(c.max_vendor_status) max_vendor_status, SUM(c.success_count) success_count, SUM(c.partial_count) partial_count, SUM(c.failed_count) failed_count FROM get_counts c INNER JOIN apt_v_server s1 ON s1.server_id = c.client_id INNER JOIN apt_v_server s2 ON s2.server_id = c.server_id LEFT JOIN get_last_backup_date lb ON lb.client_id = c.client_id WHERE s1.os_platform IS NOT NULL GROUP BY c.client_id, c.server_id, s2.display_name, s1.os_platform, s1.display_name ) --select * from get_sums; SELECT nbr_of_days, max_vendor_status, master, os_platform, trim(both ' ' from client) client, NVL(last_backup,45) last_backup FROM get_sums, get_var -- WHERE failed_count >= nbr_of_days -- AND -- (last_backup >= nbr_of_days OR last_backup IS NULL) ORDER BY 1,2,3,4
What are pre-requisites to send SNMP traps from Alta IT analytics to On-premises servicenow
Hi Team, We are having Backup infrastructure built on-premises and integrated with Alta view for manage and monitor backup jobs. I need help on sending Alerts via SNMP traps instead of mail. I am unable to find pre-requisites such as what ports need to open between Alta IT Analytics to on-premises servicenow I am unable to find Alta IT Analytics SNMP integration guide, pre-requisites, level of access, any software to install in servicenow etc. appreciate if anyone can help
Flex Appliances with MFA and NBITA
In my production environments I currently have NetBackup 10.x instances running on 2 x 5360HA Flex appliances using a single data collector sat on VMware collecting from 4 NetBackup domains spread over both appliances. MFA is due to be turned on the Flex appliances and for NetBackup instances. It's similar in a developer environment also. I'm having a bit of a moment here, the documentation for NBITA seems all over the place with vital potentially solution breaking information just dropped into a single place / a side note. Will turning on MFA break my NBITA deployment irreparably given that once MFA is on in the way we want it to be, you can’t turn it off again? Does anyone have any experience with this? The two items that are causing me concern are both from NBITA Systems Admin Guide Appendix C: "Note: Remote data collection from Netbackup primary server cannot be configured when multi-factor authentication is configured on Netbackup Appliance" On the subject of making a primary server running on Flex into a data collector - “On a Flex appliance, connect to the primary server pod first and then switch to the root user” - unpicking this is proving tricky one, switching to root on the Flex host is long winded and needs a support ticket and I wasn't aware you could on the instances. Is this saying that I need to follow these very less than clear instructions for everyone one of my NetBackup primary servers (currently 4 but 16 planned by the end of the year) or is using MFA just out of the question for Flex and NetBackup if I continue to use NBITA?Install Oracle 19c without Veritas wrapper for NBITA
Hi All, Due to DB compliance, Oracle team using their own method installed 19c on a dedicated server for Portal without using the Veritas wrapper for DB installation "itanalytics_dbinstaller_xx.iso". So now installing Portal component, installer is not able to communicate to the Oracle that's already installed on the same system. Portal installer doesnt ask anything for Oracle user but requires SID, port to be entered and communication fails. User Aptare and tomcat, data01 through 06 are all created. Please assist/guide to fix this.Thanks in advance.
