topic Re: awk or something else in Operating System - HP-UX

awk or something else

Igor Sovin — Tue, 19 Sep 2006 04:07:35 GMT

I need to get EP2 and 2006/09/19-3 from
omnidb output:
#omnidb -session -user root -last 3 -type backup -detail

SessionID : 2006/09/19-3
Backup Specification: EP2
Session type : Backup (full)
Started : Tue Sep 19 05:00:00 2006
Finished : Tue Sep 19 09:21:47 2006
Status : Completed
Number of warnings : 0
Number of errors : 0
User : root
Group : sys
Host : lev

How can I do that using awk or some different way?

Re: awk or something else

Peter Godron — Tue, 19 Sep 2006 04:11:08 GMT

Igor,
Using the output of your omnidb command:
head -2 | awk -F':' '{print $2}'

Re: awk or something else

H.Merijn Brand (procura — Tue, 19 Sep 2006 04:21:11 GMT

or

# omnidb -session -user root -last 3 -type backup -detail | perl -ne'm/^(SessionID|Backup Specification)\b/&&s/.*?:\s*//&&print'

Enjoy, Have FUN! H.Merijn

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 04:43:39 GMT

Hi Peter!

I need to get two fields Session ID an Backup Specification simultaneosly, not only Session ID.
Or if it is not possible, how to get Session ID that belongs to Backup Specification EP2?
The output of omnidb could be different than that I've posted, depending on number of sessions.

Re: awk or something else

Peter Nikitka — Tue, 19 Sep 2006 04:48:44 GMT

Hi,

you need pure awk only:
omnidb -session -user root -last 3 -type backup -detail |
awk '/^SessionID/ {print $NF}
/^ Backup Specification/ {print $NF;exit}'

or in Peter G.'s solution:
... | awk -F: 'NR>3 {print $2}'

mfG Peter

Re: awk or something else

Peter Nikitka — Tue, 19 Sep 2006 04:49:53 GMT

Sorry,

must use '<' and not '>':

##
or in Peter G.'s solution:
... | awk -F: 'NR<3 {print $2}'
##

mfG Peter

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 04:51:21 GMT

omnidb -session -user root -last 3 -type backup -detail | perl -ne'm/^(SessionID|Backup Specification)\b/&&s/.*?:\s*//&&print '

doesn't work

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 05:09:46 GMT

Actually there are several sessions.
The full output is:

root@lev /opt/omni>omnidb -session -user root -last 3 -type backup -detail

SessionID : 2006/09/16-2
Backup Specification: EP2
Session type : Backup (full)
Started : Sat Sep 16 05:00:01 2006
Finished : Sat Sep 16 09:22:00 2006
Status : Completed
Number of warnings : 0
Number of errors : 0
User : root
Group : sys
Host : lev

SessionID : 2006/09/16-16
Backup Specification: DMProd
Session type : Backup (full)
Started : Sat Sep 16 23:45:00 2006
Finished : Sun Sep 17 02:23:52 2006
Status : Completed
Number of warnings : 1
Number of errors : 0
User : root
Group : sys
Host : lev

SessionID : 2006/09/17-1
Backup Specification: ServiceDesk
Session type : Backup (full)
Started : Sun Sep 17 03:00:01 2006
Finished : Sun Sep 17 04:40:24 2006
Status : Completed
Number of warnings : 0
Number of errors : 0
User : root
Group : sys
Host : lev

SessionID : 2006/09/17-2
Backup Specification: EP2
Session type : Backup (full)
Started : Sun Sep 17 05:00:00 2006
Finished : Sun Sep 17 09:21:42 2006
Status : Completed
Number of warnings : 0
Number of errors : 0
User : root
Group : sys
Host : lev

SessionID : 2006/09/17-14
Backup Specification: DP Database
Session type : Backup (full)
Started : Sun Sep 17 20:00:01 2006
Finished : Sun Sep 17 20:30:17 2006
Status : Completed
Number of warnings : 0
Number of errors : 0
User : root
Group : sys
Host : lev

How to get the following?:

SessionID : 2006/09/16-2
Backup Specification: EP2

SessionID : 2006/09/17-2
Backup Specification: EP2

Re: awk or something else

Peter Godron — Tue, 19 Sep 2006 05:15:30 GMT

Igor,
"The output of omnidb could be different than that I've posted, depending on number of sessions." - Can you please post a file with all the formats you want to analyse ?

"I need to get two fields Session ID an Backup Specification simultaneosly, not only Session ID. Or if it is not possible, how to get Session ID that belongs to Backup Specification EP2?" - Can you please give an example of what you want as an output, given the input as requested above.

For example my solution assumed no blank leading line in input and that you wanted the ouput on two lines.

Re: awk or something else

Alfredo Garcia Martino — Tue, 19 Sep 2006 05:21:30 GMT

The simpliest way:

omnidb -session -user root -last 3 -type backup -detail | grep -e "^Backup Specification" -e "^SessionID"

Re: awk or something else

H.Merijn Brand (procura — Tue, 19 Sep 2006 05:21:51 GMT

Can you expand on "doesn't work"?
Does it give an error message?

Taking your last paste, and using that as input:

lt09:/home/merijn 102 > perl -ne'm/^(SessionID|Backup Specification)\b/&&s/.*?:\s*//&&print' omni.out
2006/09/16-2
EP2
2006/09/16-16
DMProd
2006/09/17-1
ServiceDesk
2006/09/17-2
EP2
2006/09/17-14
DP Database

looks perfectly fine to me.
What is the perl you use?

# perl -v

Enjoy, Have FUN! H.Merijn

Re: awk or something else

Alfredo Garcia Martino — Tue, 19 Sep 2006 05:27:24 GMT

Using awk:

omnidb -session -user root -last 3 -type backup -detail |
awk '/^SessionID/ {print $0}
/^Backup Specification/ {print $0;exit}'

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 05:32:28 GMT

procura

root@lev /Ignite_Bckp>perl -v

This is perl, v5.8.0 built for IA64.ARCHREV_0-thread-multi
(with 1 registered patch, see perl -V for more detail)

Copyright 1987-2002, Larry Wall

Binary build 803 provided by ActiveState Corp. http://www.ActiveState.com
Built 16:06:31 Nov 24 2002

Perl may be copied only under the terms of either the Artistic License or the
GNU General Public License, which may be found in the Perl 5 source kit.

Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.

I dont understand how to use your construction.. Could you post the whole command?

Re: awk or something else

Peter Nikitka — Tue, 19 Sep 2006 05:40:31 GMT

Hi,

to get the output for multiple sessions, just leave the 'exit'; to get one-liner info additionally, use:

omnidb -session -user root -last 3 -type backup -detail |
awk '/^SessionID/ {id=$NF}
/^ Backup Specification/ {print id,$NF}'

mfG Peter

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 05:45:46 GMT

Peter Nikitka,

I do not get any output using your last command

Re: awk or something else

H.Merijn Brand (procura — Tue, 19 Sep 2006 05:46:47 GMT

Uh, that *is* the whole command, assuming omni.out was the collected output:

root@lev /opt/omni>omnidb -session -user root -last 3 -type backup -detail >omni.out
root@lev /opt/omni>perl -ne'm/^(SessionID|Backup Specification)\b/&&s/.*?:\s*//&&print' omni.out

or, without the file

root@lev /opt/omni>omnidb -session -user root -last 3 -type backup -detail | perl -ne'm/^(SessionID|Backup Specification)\b/&&s/.*?:\s*//&&print' omni.out

I've just tried perl5.8.0 on a HP-UX 10.20 box, and that also runs fine:

d3:/u/usr/merijn 105 > perl5.8.0 -ne'm/^(SessionID|Backup Specification)\b/&&s/.*?:\s*//&&print' omni.out
2006/09/16-2
EP2
2006/09/16-16
DMProd
2006/09/17-1
ServiceDesk
2006/09/17-2
EP2
2006/09/17-14
DP Database

Enjoy, Have FUN! H.Merijn

Re: awk or something else

Alfredo Garcia Martino — Tue, 19 Sep 2006 05:51:51 GMT

Peter's solution has a blank space that I don't see in my output.

This works for me (without blank space between ^ and Backup):

omnidb -session -user root -last 3 -type backup -detail |
awk '/^SessionID/ {id=$NF}
/^Backup Specification/ {print id,$NF}'

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 05:54:07 GMT

procura
hmm .. dont know what's the problem
I get only SessionID fields:

2006/09/16-2
2006/09/16-16
2006/09/17-1
2006/09/17-2
2006/09/17-14
2006/09/17-17
2006/09/18-2
2006/09/18-19
2006/09/19-1
2006/09/19-3

Re: awk or something else

H.Merijn Brand (procura — Tue, 19 Sep 2006 06:21:13 GMT

Which probably means that there is more whitespace than the forum shows.
Can you *attach* the output, instead of paste it?

For the next time you paste data that is to be parsed, please tick the '[ ] Retain format (spacing)' checkbox under the input text box, so the spaces are preserved.

Enjoy, Have FUN! H.Merijn

Re: awk or something else

Igor Sovin — Tue, 19 Sep 2006 06:26:24 GMT

Here is the attachment