Regular expression in NBU 7.5

just a suggestion..

if that is the daily regular work.. why dont to try to automate it to .. using any script or reporting tool..

Just to be sure, are you trying to get all policy & schedule information using a single regular expression?

# bppllist -L -allpolicies | egrep "Policy Name|Schedule:"

 

Or are you trying to just get a list of those policy schedules you need from the activity monitor?

# bpdbjobs 

From the output of bpdbjobs you can try to filter out your policy and/or schedule name. Should not be too tough, but if you have complex filtering to do, consider using script.

Hi Guys,

This is Daily work, We need to give report to higer Management for BC backups. For that I have to filter the JAVA GUI as per my requirement.  JOB policy, I able to get the regular expressions, but for JOB schedule i am not able to get since I do not want hourly application-weekly ...etc

For Job policy I used pipe (|) symbole for combine policies,
 

But job Schedule I do not want schedules( No idea which regular expression I should use for this purpsose)

 

Thanks for your help

What. where, how?

I am totally unclear as to what it is you need exactly....

As it's a daily report one would think that this has got to do with jobs .... but .....

So where exactly are you doing this filtering? What is the report supposed to be showing?

 

***EDIT***

After a re-visit, not sure it would be possible other than what you are doing now as I cannot currently find any info on what regular expressions are accepted or allowed. I know "!" is a common one for "is not" but not sure if that could be incorporated & cannot test.

Maybe a simple script could produce this same formatted output as already intimated above?

Not sure if you use grep for your "job policy" filter or not, but if you did, you can do exclusion by doing:

egrep -v "hourly|weekly|monthly"   

That means do not search for lines matching those 3 schedules

Hi Guys,

 

I am clearly saying my first update, I Need solution for JAVA GUI not from Command line. I am explaining again, where I facing problem.

 

Right click on Java GUI goto filter click advance then goto Job Policy here I am entered all policies which required as below.

Since I am using pipe (|) symbol ( which means OR operation ). So, I am getting all my required information.

 

 

Job Policy        regular expression    oradb.*|sqldb.*|exdb.*   ................it is working for me

 

I need same reguler expression. which not required in Job Schedule. No idea how to do here.

Eg:- schedule which starts from Application-weekly , Application-daily,Application-hourly ...etc

SO, I AM DOING EVERY DAY AS BELOW

I am doing the above things as below

 

Job schedule    not equal to        application-hourly

Job chedule    not equal to        Application-Weekly

Job schedule    not equal to         client-hourly

after that I am using start Date from previous day from 6 PM .

Why I need Job schedule. Same DB have two or three policies. using DB name, hourly archive backup and some time weekly or monthly archive backups..

So, I will get BC ( Business critical) backups which are still running @ 10 AM ( Since I am using this filter at that time) and will give those backups to Management for keep the backups or kill backups before next schedule.

 

I hope I have explained clear. If not please mention where you doubt.

 

If any one give solution by using Java GUI or command/script to collect BC backups still running @ 10 AM. that is good idea.

 

 

Thanks for the clarification - think I got there earlier!

Unless someone can confirm otherwise with the required "regular expression" for the schedule part of the filter, I think a more suitable option (& my personal preference) would be to go for what's already been suggested - simply script it using the bpdbjobs command with "grep" & "grep -v" to 'filter' your results & you could schedule this in to occur at 10am each day to look specifically for "Active" jobs.

So, I will get BC ( Business critical) backups which are still running @ 10 AM ( Since I am using this filter at that time) and will give those backups to Management for keep the backups or kill backups before next schedule.

 

This filter would be easier:

  State  equal to   Active

 

 

Hey Watsons,

Thank you for good information about filter for required job policies from bpdbjobs,

Eg:- Done here

/usr/openv/netbackup/bin/admincmd/bpdbjobs -report -t 07/30/2013  -U |egrep 'ora.*|sql.*|nas.*....etc

But I want how to filter which I do not wnat schedule type like 

 

Eg:- Waiting information here

application-hourly, application-2hours, Ora-mds-hourly ....etc

 

Thanks for help here