Using LogParser for this task is a bit like using a hammer to break eggs. It may work, but it's a lot more force than you need. You can filter your file with this simple command:
FIND/V "1/49" mac-address-table_report.txt
(This assumes you have saved your report to mac-address-table_report.txt)
hg363
67 Posts
HELP!!!!!!!!!!!!!
Dec 30, 2009 06:43 PM|LINK
Please can some one help me.
I have a text file holding this data
login : *******
password : *******************
Welcome to the Alcatel OmniSwitch 6000
Software Version 5.4.1.540.R01 Service Release, August 17, 2009.
Copyright(c), 1994-2005 Alcatel Internetworking, Inc. All Rights reserved.
OmniSwitch(TM) is a trademark of Alcatel Internetworking, Inc. registered
in the United States Patent and Trademark Office.
SwitchH173-> show mac-address-table
show mac-address-table
Legend: Mac Address: * = address not valid
Vlan Mac Address Type Protocol Operation port
------+-------------------+--------------+-------------+------------+-----------
224 00:16:17:31:04:b0 learned 10800 bridging 1/2
224 00:22:64:1c:5c:02 learned 10800 bridging 1/3
224 00:08:02:bb:33:67 learned 10800 bridging 1/4
224 00:18:71:7c:e1:28 learned 10800 bridging 1/7
224 00:00:74:9a:78:5a learned 10800 bridging 1/8
224 00:19:bb:4d:93:e2 learned 10800 bridging 1/25
224 00:21:85:cb:65:f2 learned 10800 bridging 1/30
224 00:08:02:5e:e0:ce learned 10800 bridging 1/32
224 00:c0:b7:6c:4f:6b learned 10800 bridging 1/37
1 00:07:9a:92:a3:68 learned 10800 bridging 1/49
1 00:18:b1:87:eb:00 learned 10800 bridging 1/49
1 00:18:b1:89:18:00 learned 10800 bridging 1/49
1 00:c0:b7:6c:de:ea learned 10806 bridging 1/49
1 00:c0:b7:6c:df:01 learned 10806 bridging 1/49
1 00:d0:95:8a:e2:ae learned 10000 bridging 1/49
1 00:d0:95:94:61:f6 learned 10000 bridging 1/49
1 00:e0:b1:6a:27:a0 learned 10806 bridging 1/49
12 00:d0:95:89:60:fe learned 10806 bridging 1/49
12 00:d0:95:9a:60:d8 learned 10806 bridging 1/49
12 00:d0:95:a1:b1:50 learned 10806 bridging 1/49
12 00:d0:95:f4:f9:f0 learned 10806 bridging 1/49
12 00:d0:95:fb:d6:ea learned 10806 bridging 1/49
12 00:d0:95:fd:c9:28 learned 10806 bridging 1/49
12 00:d0:95:fe:02:02 learned 10806 bridging 1/49
12 00:d0:95:fe:99:96 learned 10806 bridging 1/49
12 00:d0:95:fe:a0:08 learned 10806 bridging 1/49
12 00:d0:95:fe:b3:88 learned 10806 bridging 1/49
12 00:d0:95:fe:c5:e4 learned 10806 bridging 1/49
12 00:d0:95:ff:4a:86 learned 10806 bridging 1/49
12 00:d0:95:ff:61:2a learned 10806 bridging 1/49
12 00:e0:b1:65:f2:d4 learned 10806 bridging 1/49
12 00:e0:b1:66:49:06 learned 10806 bridging 1/49
12 00:e0:b1:6a:27:ab learned 10800 bridging 1/49
12 00:e0:b1:75:8b:e4 learned 10800 bridging 1/49
12 00:e0:b1:75:da:9e learned 10806 bridging 1/49
12 00:e0:b1:77:18:4e learned 10806 bridging 1/49
12 00:e0:b1:79:4d:54 learned 10806 bridging 1/49
12 00:e0:b1:79:50:5c learned 10806 bridging 1/49
12 00:e0:b1:7d:66:58 learned 10806 bridging 1/49
12 00:e0:b1:7d:6c:98 learned 10806 bridging 1/49
12 00:e0:b1:83:52:06 learned 10806 bridging 1/49
12 00:e0:b1:8f:81:a8 learned 10806 bridging 1/49
12 00:e0:b1:8f:8a:da learned 10806 bridging 1/49
12 00:e0:b1:8f:8c:6a learned 10806 bridging 1/49
12 00:e0:b1:90:3d:5c learned 10806 bridging 1/49
12 00:e0:b1:90:3e:2c learned 10806 bridging 1/49
204 00:00:74:86:30:77 learned e0e08137 bridging 1/49
204 00:00:74:9b:0a:ed learned 10800 bridging 1/49
204 00:00:74:9b:16:e2 learned 10800 bridging 1/49
204 00:00:74:9b:41:54 learned 10800 bridging 1/49
204 00:00:74:9b:8b:af learned 10800 bridging 1/49
204 00:00:74:9f:b8:ee learned 10800 bridging 1/49
204 00:00:74:a0:84:f3 learned 10800 bridging 1/49
204 00:00:74:c6:a2:e3 learned 10800 bridging 1/49
204 00:00:74:e0:4b:37 learned 10800 bridging 1/49
204 00:00:74:e0:57:d3 learned 10800 bridging 1/49
204 00:04:00:ee:15:9c learned 186dd bridging 1/49
204 00:04:00:f5:d2:dc learned e0e08137 bridging 1/49
204 00:07:32:06:bc:4d learned 10800 bridging 1/49
204 00:07:32:0f:59:52 learned 10800 bridging 1/49
204 00:07:4d:22:02:71 learned 8137 bridging 1/49
204 00:08:02:a8:a9:17 learned 10800 bridging 1/49
204 00:08:02:aa:84:6c learned 10800 bridging 1/49
204 00:08:02:c8:0d:fb learned 10800 bridging 1/49
204 00:0b:cd:a1:72:7e learned 10800 bridging 1/49
204 00:0b:cd:c3:16:ae learned 10800 bridging 1/49
204 00:0b:cd:f8:e1:90 learned 10800 bridging 1/49
204 00:0b:cd:fc:0e:6e learned 10800 bridging 1/49
204 00:0d:9d:4a:62:93 learned 10800 bridging 1/49
204 00:0d:9d:9d:c1:d4 learned 10800 bridging 1/49
204 00:0d:9d:9e:00:19 learned 10800 bridging 1/49
204 00:0e:7f:e0:d7:e3 learned 8137 bridging 1/49
204 00:0e:7f:f0:d9:81 learned 10800 bridging 1/49
204 00:0f:fe:ea:b4:d3 learned 10800 bridging 1/49
204 00:11:0a:96:5d:2b learned 10800 bridging 1/49
204 00:11:85:7d:fc:d8 learned 10800 bridging 1/49
204 00:11:85:82:7e:61 learned 10800 bridging 1/49
204 00:11:85:df:b2:5d learned 10800 bridging 1/49
204 00:12:79:ac:23:8c learned 10800 bridging 1/49
204 00:12:79:ae:40:37 learned 10800 bridging 1/49
204 00:12:79:ae:47:6f learned 10800 bridging 1/49
204 00:12:79:ae:4c:be learned 10800 bridging 1/49
204 00:12:79:ae:50:a2 learned 10800 bridging 1/49
204 00:12:79:db:0e:1c learned 10800 bridging 1/49
204 00:13:21:5c:17:16 learned 10800 bridging 1/49
204 00:13:21:5e:a5:81 learned 10806 bridging 1/49
204 00:14:c2:c5:c8:71 learned 10800 bridging 1/49
204 00:16:01:0a:f9:7a learned 10800 bridging 1/49
204 00:16:17:27:67:b3 learned 10800 bridging 1/49
204 00:16:17:2a:cd:e7 learned 10800 bridging 1/49
204 00:16:17:2a:d7:3a learned 10800 bridging 1/49
204 00:16:17:2f:fd:37 learned 10800 bridging 1/49
204 00:16:17:31:02:76 learned 10800 bridging 1/49
204 00:16:17:a7:64:87 learned 10800 bridging 1/49
204 00:16:35:0a:db:2e learned 10800 bridging 1/49
204 00:17:a4:14:4d:32 learned 10800 bridging 1/49
204 00:17:a4:f2:98:66 learned 10800 bridging 1/49
204 00:17:a4:f3:91:b5 learned 10800 bridging 1/49
204 00:19:bb:48:85:56 learned 10800 bridging 1/49
204 00:19:bb:49:1b:8c learned 10800 bridging 1/49
204 00:19:bb:e0:7b:6c learned 10800 bridging 1/49
204 00:19:d1:58:2d:72 learned 10800 bridging 1/49
204 00:19:db:71:dd:f9 learned 10800 bridging 1/49
204 00:19:db:71:e2:22 learned 10800 bridging 1/49
204 00:19:db:71:e2:cd learned 10800 bridging 1/49
204 00:19:db:71:e3:a0 learned 10800 bridging 1/49
204 00:19:db:71:e3:bc learned 10800 bridging 1/49
204 00:1b:78:3b:d1:07 learned 10800 bridging 1/49
204 00:1b:78:3c:d1:27 learned 10800 bridging 1/49
204 00:1b:78:80:6c:67 learned 10800 bridging 1/49
204 00:1b:78:80:6c:8e learned 10800 bridging 1/49
204 00:1c:c4:63:18:12 learned 10800 bridging 1/49
204 00:1c:c4:63:22:d3 learned 10800 bridging 1/49
204 00:1c:c4:64:20:b9 learned 10800 bridging 1/49
204 00:1c:c4:64:21:83 learned 10800 bridging 1/49
204 00:1e:0b:3f:49:28 learned 10800 bridging 1/49
204 00:1e:0b:3f:49:56 learned 10800 bridging 1/49
204 00:1f:29:db:36:d5 learned 10800 bridging 1/49
204 00:1f:29:db:37:e0 learned 10800 bridging 1/49
204 00:21:5a:18:62:94 learned 10800 bridging 1/49
204 00:21:5a:19:60:5e learned 10800 bridging 1/49
204 00:21:5a:1a:82:00 learned 10800 bridging 1/49
204 00:21:85:69:aa:0c learned 10800 bridging 1/49
204 00:21:85:ca:df:b7 learned 10800 bridging 1/49
204 00:21:85:cb:65:cf learned 10800 bridging 1/49
204 00:21:85:cb:65:f4 learned 10800 bridging 1/49
204 00:21:85:cb:66:42 learned 10800 bridging 1/49
204 00:21:85:cb:66:48 learned 10800 bridging 1/49
204 00:21:85:cb:66:51 learned 10800 bridging 1/49
204 00:21:85:cb:6c:d2 learned 10800 bridging 1/49
204 00:22:64:1c:61:58 learned 10800 bridging 1/49
204 00:22:64:a8:07:ad learned 10800 bridging 1/49
204 00:22:64:a8:0a:2b learned 10800 bridging 1/49
204 00:22:64:a8:64:a0 learned 10800 bridging 1/49
204 00:22:64:a8:69:e0 learned 10800 bridging 1/49
204 00:22:64:a8:6b:46 learned 10800 bridging 1/49
204 00:22:64:a8:6f:62 learned 10800 bridging 1/49
204 00:22:64:a8:b2:72 learned 10800 bridging 1/49
204 00:22:64:a9:21:b0 learned 10800 bridging 1/49
204 00:22:64:a9:21:f0 learned 10800 bridging 1/49
204 00:22:64:a9:28:48 learned 10800 bridging 1/49
204 00:22:64:a9:28:f4 learned 10800 bridging 1/49
204 00:22:64:a9:2d:fc learned 10800 bridging 1/49
204 00:22:64:aa:0a:60 learned 10800 bridging 1/49
204 00:22:64:aa:11:f0 learned 10800 bridging 1/49
204 00:22:64:aa:16:60 learned 10800 bridging 1/49
204 00:22:64:aa:16:7e learned 10800 bridging 1/49
204 00:24:21:7f:8e:ba learned 10800 bridging 1/49
204 00:24:21:7f:8e:bc learned 10800 bridging 1/49
204 00:24:21:7f:c5:d1 learned 10800 bridging 1/49
204 00:24:81:a0:1a:76 learned 10800 bridging 1/49
204 00:d0:95:8a:e2:c8 learned 10800 bridging 1/49
204 00:d0:95:94:61:f6 learned 10806 bridging 1/49
204 00:d0:95:96:32:be learned 10806 bridging 1/49
204 00:d0:95:97:04:02 learned 10806 bridging 1/49
204 00:d0:95:a4:67:42 learned 10806 bridging 1/49
204 00:e0:b1:6a:27:b3 learned 10000 bridging 1/49
204 00:e0:b1:75:8b:e4 learned 10800 bridging 1/49
216 00:00:60:dd:24:30 learned 10800 bridging 1/49
216 00:04:23:b5:18:ce learned 10800 bridging 1/49
216 00:07:e9:23:c6:2a learned 10800 bridging 1/49
216 00:07:e9:31:ec:8c learned 10800 bridging 1/49
216 00:07:e9:9d:bd:4d learned 10800 bridging 1/49
216 00:0a:5e:56:06:ea learned 10800 bridging 1/49
216 00:0d:9d:95:a4:77 learned 10800 bridging 1/49
216 00:12:79:db:0d:8b learned 10800 bridging 1/49
216 00:12:79:db:0d:ad learned 10800 bridging 1/49
216 00:12:79:db:24:02 learned 10800 bridging 1/49
216 00:12:79:db:24:b8 learned 10800 bridging 1/49
216 00:12:79:db:25:de learned 10800 bridging 1/49
216 00:13:20:3a:79:23 learned 10800 bridging 1/49
216 00:13:20:4f:b0:d4 learned 10800 bridging 1/49
216 00:13:72:36:d3:02 learned 10800 bridging 1/49
216 00:16:01:0a:73:5e learned 10800 bridging 1/49
216 00:16:35:75:46:14 learned 10800 bridging 1/49
216 00:17:a4:19:af:09 learned 10800 bridging 1/49
216 00:18:fe:26:8e:70 learned 10800 bridging 1/49
216 00:18:fe:26:eb:0b learned 10800 bridging 1/49
216 00:19:bb:5f:0b:00 learned 10800 bridging 1/49
216 00:19:bb:e2:7d:6d learned 10800 bridging 1/49
216 00:19:d1:00:cd:55 learned 10800 bridging 1/49
216 00:1b:78:b3:ba:cc learned 10800 bridging 1/49
216 00:1b:78:b3:c3:61 learned 10800 bridging 1/49
216 00:1d:73:27:c2:05 learned 10800 bridging 1/49
216 00:1e:0b:27:ee:0b learned 10800 bridging 1/49
216 00:1e:0b:27:fa:8c learned 10800 bridging 1/49
216 00:1e:4f:a3:fa:c0 learned 10800 bridging 1/49
216 00:1e:4f:c7:89:8c learned 10800 bridging 1/49
216 00:22:64:a9:2d:f2 learned 10800 bridging 1/49
216 00:22:64:af:03:68 learned 10800 bridging 1/49
216 00:22:64:af:06:f3 learned 10800 bridging 1/49
216 00:22:64:af:08:6a learned 10800 bridging 1/49
216 00:22:64:af:08:79 learned 10800 bridging 1/49
216 00:22:64:af:08:7a learned 10800 bridging 1/49
216 00:24:21:7f:c5:d3 learned 10800 bridging 1/49
216 00:80:42:18:55:7e learned 10806 bridging 1/49
216 00:d0:95:8a:e2:cb learned 10000 bridging 1/49
216 00:d0:95:a4:67:42 learned 10806 bridging 1/49
216 00:e0:b1:6a:27:b6 learned 10000 bridging 1/49
216 00:e0:b1:75:8b:e4 learned 10000 bridging 1/49
216 08:00:66:80:84:ad learned 10806 bridging 1/49
224 00:00:74:a5:77:bf learned 10800 bridging 1/49
224 00:00:74:e0:8b:c1 learned 10800 bridging 1/49
224 00:08:02:f9:56:0c learned 10800 bridging 1/49
224 00:0b:cd:63:ab:58 learned 10800 bridging 1/49
224 00:0b:cd:72:97:ce learned 10800 bridging 1/49
224 00:0b:cd:a0:fa:44 learned 10800 bridging 1/49
224 00:11:85:78:6a:ab learned 10800 bridging 1/49
224 00:12:79:db:0d:8e learned 10800 bridging 1/49
224 00:12:79:db:24:d0 learned 10806 bridging 1/49
224 00:12:79:db:25:2c learned 10800 bridging 1/49
224 00:13:21:5e:a5:92 learned 10800 bridging 1/49
224 00:14:38:ba:02:2c learned 10800 bridging 1/49
224 00:16:17:27:67:b2 learned 10800 bridging 1/49
224 00:16:17:2a:a6:34 learned 10800 bridging 1/49
224 00:16:17:2f:fc:d7 learned 10800 bridging 1/49
224 00:16:17:31:02:bb learned 10800 bridging 1/49
224 00:16:17:31:06:19 learned 10800 bridging 1/49
224 00:16:17:31:07:20 learned 10800 bridging 1/49
224 00:16:17:80:c0:d2 learned 10800 bridging 1/49
224 00:17:a4:4d:0b:c9 learned 10800 bridging 1/49
224 00:19:bb:5f:6a:5f learned 10800 bridging 1/49
224 00:1a:4b:c3:a0:e9 learned 10800 bridging 1/49
224 00:1b:78:3b:d1:0c learned 10800 bridging 1/49
224 00:1b:78:3b:d1:20 learned 10800 bridging 1/49
224 00:1b:78:47:a3:04 learned 10800 bridging 1/49
224 00:1b:78:47:a3:10 learned 10800 bridging 1/49
224 00:1b:78:47:a3:1a learned 10800 bridging 1/49
224 00:1b:78:80:62:ab learned 10800 bridging 1/49
224 00:1b:78:80:69:0a learned 10800 bridging 1/49
224 00:1b:78:80:6c:71 learned 10800 bridging 1/49
224 00:1b:78:b4:70:12 learned 10800 bridging 1/49
224 00:1c:c4:1a:48:58 learned 10800 bridging 1/49
224 00:1c:c4:1a:48:68 learned 10800 bridging 1/49
224 00:1c:c4:1a:48:74 learned 10800 bridging 1/49
224 00:1c:c4:1a:48:76 learned 10800 bridging 1/49
224 00:1c:c4:1a:4a:a1 learned 10800 bridging 1/49
224 00:1c:c4:63:22:55 learned 10800 bridging 1/49
224 00:1c:c4:64:20:fc learned 10800 bridging 1/49
224 00:1c:c4:66:ec:1d learned 10800 bridging 1/49
224 00:1e:0b:3f:49:31 learned 10800 bridging 1/49
224 00:1e:0b:3f:49:9c learned 10800 bridging 1/49
224 00:1f:29:db:37:4c learned 10800 bridging 1/49
224 00:1f:29:db:38:31 learned 10800 bridging 1/49
224 00:21:85:69:aa:12 learned 10800 bridging 1/49
224 00:22:64:a8:05:25 learned 10800 bridging 1/49
224 00:22:64:a8:07:9f learned 10800 bridging 1/49
224 00:22:64:a8:64:5e learned 10800 bridging 1/49
224 00:22:64:a8:69:ac learned 10800 bridging 1/49
224 00:22:64:a9:9e:02 learned 10800 bridging 1/49
224 00:22:64:aa:0a:4e learned 10800 bridging 1/49
224 00:22:64:aa:0e:ea learned 10800 bridging 1/49
224 00:22:64:aa:11:c6 learned 10800 bridging 1/49
224 00:24:21:80:08:1d learned 10800 bridging 1/49
224 00:c0:b7:6c:4e:e9 learned 10806 bridging 1/49
224 00:d0:95:a1:aa:90 learned 10806 bridging 1/49
224 00:e0:b1:6a:27:b8 learned 10806 bridging 1/49
Total number of Valid MAC addresses above = 257
SwitchH173-> exit
And I would like LP to examine this file and only pull out all those ROWS where PORT is not equal to 1/49.
In other words if any row in this file has 1/49 under the port heading, LP should ignore it
Kind regards Mr Ghelani
qbernard
5016 Posts
MVP
Moderator
Re: HELP!!!!!!!!!!!!!
Dec 31, 2009 07:15 AM|LINK
Mm.. textfile, so what you can do is just focus on text row criteria.. something like.
"select * from textlog.txt where text like '%bridging%' and text not like '%1/49'"
tweak a bit to fit your needs.
Bernard Cheah
cjturner
2 Posts
Re: HELP!!!!!!!!!!!!!
Jan 03, 2010 04:14 PM|LINK
Using LogParser for this task is a bit like using a hammer to break eggs. It may work, but it's a lot more force than you need. You can filter your file with this simple command:
FIND/V "1/49" mac-address-table_report.txt
(This assumes you have saved your report to mac-address-table_report.txt)
qbernard
5016 Posts
MVP
Moderator
Re: HELP!!!!!!!!!!!!!
Jan 04, 2010 05:19 AM|LINK
LOL.. indeed...
Bernard Cheah