How to get Backup Window Details for all Policies
fitrat
November 9th, 2009
Hi Guys
Need your help to find out the backup Window Details for all Policies
In our netbackup environment, we have around 1000+ backup policies and around 3000+ schedules for those backup policies- daily, weekly, monthly, yearly, ondemand, special...etc
I need to export the backup window details for each backup schedule in excel format
Like....
| Backup Policy | Schedule | Day | Start Time | End Time |
| sun_servers | Daily | Mon | 9:00 | 13:00 |
| sun_servers | Daily | Tues | 9:00 | 13:00 |
| sun_servers | Daily | Wed | 9:00 | 13:00 |
| sun_servers | Daily | Thur | 9:00 | 13:00 |
| sun_servers | Daily | Fri | 9:00 | 13:00 |
| sun_servers | Daily | Sat | 9:00 | 13:00 |
| sun_servers | Daily | All Sundays except first | 15:00 | 21:00 |
| sun_servers | Monthly | First Sunday of month | 15:00 | 21:00 |
| hp_servers | Daily | Mon | 10:00 | 14:00 |
| hp_servers | Daily | Tues | 10:00 | 14:00 |
| hp_servers | Daily | Wed | 10:00 | 14:00 |
| hp_servers | Daily | Thur | 10:00 | 14:00 |
| hp_servers | Daily | Fri | 10:00 | 14:00 |
| hp_servers | Daily | Sat | 10:00 | 14:00 |
| hp_servers | Daily | All Sundays except first | 16:00 | 22:00 |
| hp_servers | Monthly | First Sunday of month | 16:00 | 22:00 |
Please suggest me how can I get this type of details...either from command line OR from Netbackup GUI
Thanks in advance
Filed under: NetBackup, Basics, Best Practice, Features, Reporting, Tip/How to, Backup and Archiving
Hi, If you want all polices.
Hi,
If you want all polices. go to policy tab and click on summary and then click on polices. You can see all polices, select all ( Ctrl+ A) and export ( symbol floppy disk) . It will export as .txt file , you can export all through excel.
Open excel sheet , go to data tab , go to import and export. choose the txt file then next ..... after that you see all.
Note. you need to know how to import and export file ( Ms- office, Excel)
Hi Baski Thanks for the
Hi Baski
Thanks for the suggestion
But this export is not showing the backup window (Start Time , End Time ) etc etc.....
bppllist Testing -L Policy
bppllist Testing -L
Policy Name: Testing
Options: 0x0
template: FALSE
c_unused1: ?
Names: (none)
Policy Type: Standard (0)
Active: no
Effective date: 02/21/2008 10:33:12
Client Compress: no
Follow NFS Mnts: yes
Cross Mnt Points: yes
Collect TIR info: no
Block Incremental: no
Mult. Data Stream: no
Perform Snapshot Backup: no
Snapshot Method: (none)
Snapshot Method Arguments: (none)
Perform Offhost Backup: no
Backup Copy: 0
Use Data Mover: no
Data Mover Type: 2
Use Alternate Client: no
Alternate Client Name: (none)
Use Virtual Machine: no
Enable Instant Recovery: no
Policy Priority: 0
Max Jobs/Policy: 1
Disaster Recovery: 0
Collect BMR Info: no
Keyword: (none specified)
Data Classification: -
Residence is Storage Lifecycle Policy: no
Client Encrypt: no
Checkpoint: no
Residence: kwibsp03-hcart-robot0-1drive
Volume Pool: LTO4
Server Group: *ANY*
Granular Restore Info: no
Generation: 126
Client/HW/OS/Pri: ClientName RS6000 AIX5 0 0 0 0 ?
Include: /tmpexp/exports
Exclude: (none defined)
Schedule: Full_backup
Type: FULL (0)
Frequency: 7 day(s) (604800 seconds)
Maximum MPX: 8
Synthetic: 0
PFI Recovery: 0
Retention Level: 12 (6 months)
u-wind/o/d: 0 0
Incr Type: DELTA (0)
Alt Read Host: (none defined)
Max Frag Size: 0 MB
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Day Open Close W-Open W-Close
Sunday 000:00:00 000:00:00
Monday 000:00:00 000:00:00
Tuesday 000:00:00 000:00:00
Wednesday 000:00:00 000:00:00
Thursday 000:00:00 000:00:00
Friday 022:50:00 057:50:00 142:50:00 177:50:00 009:50:00
Saturday 000:00:00 000:00:00
Schedule: Daily
Type: FULL (0)
Frequency: 0+ day(s) (54000 seconds)
Maximum MPX: 1
Synthetic: 0
PFI Recovery: 0
Retention Level: 1 (2 weeks)
u-wind/o/d: 0 0
Incr Type: DELTA (0)
Alt Read Host: (none defined)
Max Frag Size: 0 MB
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Day Open Close W-Open W-Close
Sunday 000:00:00 000:00:00
Monday 000:00:00 004:00:00 024:00:00 028:00:00
Tuesday 000:00:00 004:00:00 048:00:00 052:00:00
Wednesday 000:00:00 004:00:00 072:00:00 076:00:00
Thursday 000:00:00 024:00:00 096:00:00 120:00:00
Friday 000:00:00 004:00:00 120:00:00 124:00:00
Saturday 000:00:00 000:00:00
Schedule: user
Type: UBAK (2)
Frequency: 7 day(s) (604800 seconds)
Maximum MPX: 1
Synthetic: 0
PFI Recovery: 0
Retention Level: 1 (2 weeks)
u-wind/o/d: 0 0
Incr Type: DELTA (0)
Alt Read Host: (none defined)
Max Frag Size: 0 MB
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Day Open Close W-Open W-Close
Sunday 000:00:00 000:00:00
Monday 019:00:00 025:00:00 043:00:00 049:00:00
Tuesday 019:00:00 025:00:00 067:00:00 073:00:00
Wednesday 019:00:00 025:00:00 091:00:00 097:00:00
Thursday 002:30:00 025:00:00 098:30:00 121:00:00
Friday 000:00:00 000:00:00
Saturday 000:00:00 000:00:00
I don't have to know how to spell....I work on Unix.
Also try bppllist -U (I
Also try bppllist -U (I personally find the -U option more 'readable'):
Example:
Schedule: Daily_Full
Type: Automatic Backup
Frequency: every 1 day
Maximum MPX: 5
Synthetic: 0
PFI Recovery: 0
Retention Level: 0 (1 week)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: Daily
Daily Windows:
Monday 18:50:00 --> Tuesday 04:00:00
Tuesday 18:50:00 --> Wednesday 04:00:00
Wednesday 18:50:00 --> Thursday 04:00:00
Thursday 18:50:00 --> Friday 04:00:00
For output of all policies: bppllist -U -allpolicies >c:\temp\policies.txt
Would you like to reply?
Login or Register to post your comment.