Forum Discussion

DPeaco's avatar
DPeaco
Moderator
24 days ago

NetBackup Policy & Schedule List

Greetings,
I've been trying to work on a script that would give me the following info:

Host name, Policy Name, Schedule Type, Full Backup Scheduled Day/Time and Incr/Diff Scheduled Day(s)/Time

This would be across
VMware Intelligent Policies
standard Linux/Unix and Windows Policies
Oracle/DB2/MS-SQL Policies

Basically....I want to feed a script a list of hosts and it give me the backup info as listed above.
Anybody know of a report or a way to do that?

host123    vmw_vip_mon     full,Mon,2000     Incr/Diff Tue-Sun,2100
or even this:
host123    vmw_vip_mon     full,Mon,2000     Incr/Diff Tue,2100
                                                                                               Wed,2100
                                                                                               Thu,2100   ----- and etc

Thoughts? Ideas?

4 Replies

  • quebek's avatar
    quebek
    Moderator
    24 days ago

    Hey

    It is doable but a lot of work/scripting... I am thinking of few approaches

    1. retrospectively - bpimagelist -client host1 -hoursago 168 -U and grepping piping etc
    2. proactively - nbpemreq -predict -date mm/dd/yyyy -client_filter host1 - but only like a day ahead
    3. proactively bppllist -byclient host1 |piping grepping etc... bpplinfo etc...

    These are the three which came to my mind... not sure how/if Vmware IP will give you needed info.... 

  • StefanosM's avatar
    StefanosM
    Level 6
    23 days ago

    The most difficult part is the extraction of VM systems from a VIP policy,
    unless you obtain the VM list from previous backups.

    I had done this before many years ago. It was for a customer and it was meant to run only once, so a lot of the work was done in Excel.
    I will try to find my work and post it here. It still needs a lot of work.

    • DPeaco's avatar
      DPeaco
      Moderator
      10 days ago

      Yea, I figured that it would be a lot of work. It's almost like the developers of NBU have never been a back admin that has to answer questions asked my upper management.

      We are frequently asked:
      When does the backup of this server run, include full and incr schedule for each day?
      when was the last full backup done for server or ms-sql db on serverxyz123?
      What's the retention of the backups for server xyz123?

      It's easy enough to get the schedule info for a single server but to be asked by several sysadmins across 1,600 servers? (not so easy)

      NBU IT Analytics is supposed to be the reporting engine for NBU but getting just the info you need OUT of NBUITA - That's the real challenge. :-) 

  • Miller_Time50's avatar
    Miller_Time50
    Level 2
    6 days ago
    select

apt_v_nbu_policy.policy_name as "Policy Name",
apt_v_nbu_policy_client.client_name as "Client",
apt_v_nbu_schedule.schedule_name as "Schedule",
apt_v_nbu_schedule.schedule_type_name as "Schedule Type",
apt_v_nbu_schedule.sun_start as "Sunday Start",
apt_v_nbu_schedule.mon_start as "Monday Start",
apt_v_nbu_schedule.tue_start as "Tuesday Start",
apt_v_nbu_schedule.wed_start as "Wednesday Start",
apt_v_nbu_schedule.thu_start as "Thursday Start",
apt_v_nbu_schedule.fri_start as "Friday Start",
apt_v_nbu_schedule.sat_start as "Saturday Start"



from

apt_v_nbu_policy,
apt_v_nbu_policy_client,
apt_v_nbu_schedule

where

apt_v_nbu_policy.policy_id = apt_v_nbu_schedule.policy_id
and apt_v_nbu_policy.policy_id = apt_v_nbu_policy_client.policy_id
and apt_v_nbu_policy.is_active like 'Y'

group by 

apt_v_nbu_policy.policy_name,
apt_v_nbu_policy_client.client_name,
apt_v_nbu_schedule.schedule_name,
apt_v_nbu_schedule.schedule_type_name,
apt_v_nbu_schedule.sun_start,
apt_v_nbu_schedule.mon_start,
apt_v_nbu_schedule.tue_start,
apt_v_nbu_schedule.wed_start,
apt_v_nbu_schedule.thu_start,
apt_v_nbu_schedule.fri_start,
apt_v_nbu_schedule.sat_start

order by 

apt_v_nbu_policy.policy_name

    You can use NITA for this. You can have a report show the following columns:

    Policy - Client - Schedule - Sun Start, Mon Start, Tue Start, Wed Start, Thu Start, Fri Start, Sat Start

    This is nice basic query to show this.