Filtering out rows

Shell Programming and Scripting
1 
# powermt display dev=all

.... snipped ...

Pseudo name=hdiskpower8
Symmetrix ID=000192602584
Logical device ID=059F
state=alive; policy=SymmOpt; priority=0; queued-IOs=0
==============================================================================
---------------- Host ---------------   - Stor -   -- I/O Path -  -- Stats ---
###  HW Path                I/O Paths    Interf.   Mode    State  Q-IOs Errors
==============================================================================
   0 fscsi0                    hdisk12   FA 10fA   active  alive      0      0
   0 fscsi0                    hdisk22   FA  8fA   active  alive      0      0
   1 fscsi1                    hdisk33   FA  7fA   active  alive      0      0
   1 fscsi1                    hdisk43   FA  9fA   active  alive      0      0

Pseudo name=hdiskpower1
Symmetrix ID=000192602584
Logical device ID=05BC
state=alive; policy=SymmOpt; priority=0; queued-IOs=0
==============================================================================
---------------- Host ---------------   - Stor -   -- I/O Path -  -- Stats ---
###  HW Path                I/O Paths    Interf.   Mode    State  Q-IOs Errors
==============================================================================
   0 fscsi0                    hdisk15   FA  8fA   active  alive      0      0
   1 fscsi1                    hdisk26   FA  7fA   active  alive      0      0
   1 fscsi1                    hdisk36   FA  9fA   active  alive      0      0
   0 fscsi0                    hdisk5    FA 10fA   active  alive      0      0

.... snipped ...

I have these outputs. Each block of the output can have 2, 3, 4 rows.
Each row must show active alive . If not, I want to entire block displayed, so I know which one has issues. If all shows active alive , then "No Issues Found" returned.

Please advise.

2

You could try something like this:

powermt display dev=all|
awk '
  BEGIN{
    m="No Issues Found"
    FS=RS
    RS=""
  }

  {
    for(i=NF; i>NF-4; i--) {
      if($i~/==/) next
      else if($i!~/active  alive/) {
        m=$0
        exit 1
      }
    }
  } 

  END{
    print m
  }
'
3 
 Syntax Error The source line is 10.
 The error context is
                      >>>  if($i~/= <<< 
 awk: 0602-502 The statement cannot be correctly parsed. The source line is 10.
 awk: 0602-502 The statement cannot be correctly parsed. The source line is 11.

I am getting this error. Please advise.

4

Try:

$i~/\=\=/
5 
powermt display dev=all|
awk '
  BEGIN{
    m="No Issues Found"
    FS=RS
    RS=""
  }

  {
    for(i=NF; i>NF-4; i--) {
      if($i~/\=\=/) next
      else if($i!~/active  alive/) {
        m=$0
        exit 1
      }
    }
  } 

  END{
    print m
  }
'

It fixed the syntax error, but it seems this script only scans the first block and doesn't scan the following blocks. There are many of blocks like shown above.
Please advise.

6

You could make a quick adaptation of the script by leaving out the exit 1 return code and instead of:

m=$0
exit 1

Use

m=""
print
next
7

Yes! It works perfect!
Appreciate it!

8

Good. Note that with something like this you are are always dependent on whether the output specification might change (for example if there is an empty line in between, without it the script would not work) and if it works now it may not work in a future version..