Veritas-bu

Re: [Veritas-bu] bpdbjobs and just parent

2009-02-12 16:33:19
Subject: Re: [Veritas-bu] bpdbjobs and just parent
From: "Sweeney, Patrick" <Patrick.Sweeney AT axcelis DOT com>
To: "judy_hinchcliffe AT administaff DOT com" <judy_hinchcliffe AT administaff DOT com>, "VERITAS-BU AT mailman.eng.auburn DOT edu" <VERITAS-BU AT mailman.eng.auburn DOT edu>
Date: Thu, 12 Feb 2009 16:16:30 -0500
This will return the client, policy, schedule, start time, end time, and exit 
status of just parent jobs of type backup.  If you list the servers you want in 
a text file, prefixed with a ^ you could pipe this output to grep and evaluate 
it against that file as a set of regular expressions and just get the lines 
that begin with the server names you want.  (Probably sufficient to evaluate it 
as text if those server names appear anywhere on the line, but just in case.)

Line will probably wrap - but this is one line.
bpdbjobs -most_columns | gawk -F"," "{if($1 == $34 && $2 == 0) print 
$7,$5,$6,strftime(\"%m\\%d\\%y %H:%M:%S\",$9),strftime(\"%m\\%d\\%y 
%H:%M:%S\",$11),$4}"


The format string \"%m\\%d\\%y %H:%M:%S\" could be expressed more succinctly as 
\"%D %T\" but that isn't working with the version I have, while the example 
above is.  Also, if you really just want the start and end date as you 
specified you can obviously drop the %H:%M:%S from the output.

Patrick Sweeney
 (978) 787-4553
 patrick.sweeney AT axcelis DOT com
 I.T. Systems/Networks

For issues requiring immediate attention please contact the Solution Center
IT Solution Center
 (978) 787-7777
Beverly.Helpdesk AT axcelis DOT com
Axcelis Technologies

Have you searched here and here?

-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Sweeney, 
Patrick
Sent: Thursday, February 12, 2009 2:07 PM
To: judy_hinchcliffe AT administaff DOT com; VERITAS-BU AT mailman.eng.auburn 
DOT edu
Subject: Re: [Veritas-bu] bpdbjos and just parent

Download gawk and pipe the reulsts of bpdbjobs -mostcolumns to it.

I'llwrite the awk line for what you need when i get to work tonight, but 
basically gawk is going to do two things for you here - it will let you easily 
filter that output down to the jobs where the parent ID and the JobID match 
(just the parents)  and the systime() and strftime() functions will let you 
convert between the epoch style dating and something more human readable.

It's ultimately just a long one line command that way.
________________________________
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [veritas-bu-bounces AT 
mailman.eng.auburn DOT edu] On Behalf Of judy_hinchcliffe AT administaff DOT 
com [judy_hinchcliffe AT administaff DOT com]
Sent: Thursday, February 12, 2009 12:55 PM
To: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] bpdbjos and just parent

NB 6.5.3

I am trying to use this command to get just the parent jobs
in mm/dd/yy date formant and not unix epoch format.

(I will settle for all jobs if need be)

So I want to supply a list of servers in a for loop
Get the parent job for that client
What I am looking for is the active start and end times

But I am having issues getting that in mm/dd/yy format.

Anybody got any ideas or other commands I could use?


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu