Forum Discussion

2013's avatar
2013
Level 5
9 years ago

Need Script on Cleaning Count Remaining

I checked the below  Post but script is not in place.

 

https://www-secure.symantec.com/connect/forums/report-cleaning-tapes

Martin mentioned:

Script it ...

nbemmcmd -listmedia -mediaid shows a field "Cleanings remaining" ....

Loop through each cleaning tape, pull out the single line containing 'Cleaings'.

vmquery I suspect (don't have a system to hand to check) .... has a cleaning remaining field, and has the option to give a single line output for each tape. This is even easier, as yo can id each line that is a ceaning tape by using the density type, and then just print the two fields that refer to the media id and the cleanings remaining

 

Need to know how....can you please give me exact command which will shows Cleaning Count.We have 4 libraries.

 

Looking for help...

7.6
Backup and Recovery
Linux
NetBackup
  • Andy_Welburn's avatar
    Andy_Welburn
    9 years ago

    Simplest thing to do would probably save something like the following as a script & schedule it via cron:

     

    vmquery -b -p 0 | grep CL |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}' > clean.out

mailx -s "Cleaning Tapes - uses left" someonewhocares@company.com < clean.out

     

22 Replies

Sort By
Show More
  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    This should work:

    vmquery  -b  -p 0  |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}' 

    (You will just need to clean up header output.)

  • Andy_Welburn's avatar
    Andy_Welburn
    Level 6
    9 years ago

    So immediate output (again per Stefanos' original post):

    vmquery -b -p 0 | grep CL |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}'

    gives the following output:

    tape:CLN001 robot:1 cleanings_Remaining:0
    tape:CLN002 robot:1 cleanings_Remaining:23
    tape:CLN003 robot:1 cleanings_Remaining:23
    tape:CLN004 robot:0 cleanings_Remaining:44
    tape:CLN005 robot:0 cleanings_Remaining:45
    tape:CLN006 robot:0 cleanings_Remaining:44
    tape:CLN007 robot:0 cleanings_Remaining:44
    tape:CLNU08 robot:2 cleanings_Remaining:38
    tape:CLNU09 robot:2 cleanings_Remaining:39

  • 2013's avatar
    2013
    Level 5
    9 years ago

    Andy and Marine,the command which you gave working good.Can you please tell me how can i put the same in script.

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago

    Similar to your other script:

    #!/usr/bin/ksh
    /usr/openv/volmgr/bin/vvmquery -b -rn 0 |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}' >/tmp/cleanings.txt

    cat /tmp/cleanings.txt | mailx -s "CLEANING TAPE COUNT " company.com

  • Andy_Welburn's avatar
    Andy_Welburn
    Level 6
    9 years ago

    Simplest thing to do would probably save something like the following as a script & schedule it via cron:

     

    vmquery -b -p 0 | grep CL |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}' > clean.out

mailx -s "Cleaning Tapes - uses left" someonewhocares@company.com < clean.out

     

  • 2013's avatar
    2013
    Level 5
    9 years ago

    i am trying to put it in script but no luck:

    see below:

    #!/bin/ksh
    Cleaning=`/usr/openv/volmgr/bin/vmquery -b -p 0 | grep CL |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}' > clean.out
    echo | mailx -s "Cleaning Tapes - uses left" somewhere@company.com < clean.out

    **********************************************************************************************************

    Its giving me syntax error at line2..can you please help me Andy

  • 2013's avatar
    2013
    Level 5
    9 years ago

    Hi Marianne/Andy/Experts,

    I tried the script which you gave me..it worked but its showing all Cleaning Media + All Media which needs Cleaning...I only want output of the command which You and Andy gave me 

    vmquery -b -p 0 | grep CL |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}'

    I want to put it in a script but its not working when i ran in script.

    ********************************************************************************

    #!/bin/ksh

    /usr/openv/volmgr/bin/vvmquery -b -rn 0 |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}'

    mailx -s "Cleaning Tapes - uses left" somewhere@.com

    ********************************************************************************

    Please help me...

  • Nicolai's avatar
    Nicolai
    Moderator
    9 years ago

    Line 2 & 3 should be one line like this, remember the | (pipe) sign between "$8}' and mailx

    /usr/openv/volmgr/bin/vvmquery -b -rn 0 |awk '{print "tape:"$1, "robot:"$4, "cleanings_Remaining:"$8}' | mailx -s "Cleaning Tapes - uses left" somewhere@.com

    The mail address somewhere@.com must be changed to your own email address.