win2008R2 using gnu grep/awk to find only inactive files

[nextreme]

Ok, running tsm on 2008R2, and I have the gnu awk and grep installed...I want to only capture inactive files inside of the backup...I can get this to work on linux, but because windows interprets " ' ` differently, i can't get it to print out right...Here's what I have:

so basically here's the command

F:\Program Files\Tivoli\TSM\baclient>dsmc q backup f:\* -subdir=yes -ina | grep "0 B" | awk "$1<=0"



0 B 06/11/2012 13:55:09 STANDARD A \\virttsm\f$\db001
0 B 06/11/2012 16:08:16 STANDARD A \\virttsm\f$\FILES
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES
0 B 06/11/2012 13:55:09 STANDARD A \\virttsm\f$\db001\SERVER1
0 B 06/11/2012 13:55:09 DEFAULT A \\virttsm\f$\db001\SERVER1\SQLCRT.FLG
0 B 06/11/2012 16:08:16 DEFAULT A \\virttsm\f$\FILES\dsmc
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (10)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (11)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (12)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (13)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (14)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (15)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (16)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (17)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (18)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (19)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (2)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (20)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (21)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (3)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (4)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (5)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (6)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (7)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (8)
0 B 06/11/2012 13:03:39 DEFAULT A \\virttsm\f$\FILES\file_1888 - Copy (9)


then inside of unix i would just print where field 6 == I, any ideas inside of windows so that I only capture the I column

thxs in adv

 

[moon-buddy]

dsmc q backup f:\* -subdir=yes -ina | grep "0 B" | awk '{print $7}'

 

[nextreme]

I forgot to mention that I need the file and it's state...IE, i need to know what files are 0bytes, and in the inactive state..

Here's the output I need:
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES1
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES2
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES3
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES4

etc etc

Here's the command to get the 0 byte files, but I need a way to key off of the Inactive column...

dsmc q backup f:\* -subdir=yes -ina | grep "0 B" | awk "$1<=0"

 

[nextreme]

Here ya all go, remember this is for windows...
Here it is, found on another forum, then modified...
dsmc q backup f:\* -subdir=yes -ina | grep "0 B" | awk "$1<=0" | awk "{ if ($6 ~ /I/) print $0}"
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES1
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES2
0 B 06/11/2012 13:03:39 STANDARD I \\virttsm\f$\FILES3