I have a large number of text files outputted from various Netstumbler Wireless Scans; from which I need to extract the MAC addresses of the various Access Points.
The Text files look like this:
Code:
# $Creator: Network Stumbler Version 0.4.0
# $Format: wi-scan summary with extensions
# Latitude Longitude ( SSID ) Type ( BSSID ) Time (GMT) [ SNR Sig Noise ] # ( Name ) Flags Channelbits BcnIntvl DataRate LastChannel
# $DateGMT: 2008-01-16
N 0.0000000 E 0.0000000 ( belkin54g ) BSS ( 00:11:50:d7:c7:3c ) 16:44:39 (GMT) [ 19 68 49 ] # ( ) 0411 00000800 100 540 11
N 0.0000000 E 0.0000000 ( BUFVC Wireless ) BSS ( 00:03:93:ec:21:93 ) 16:44:39 (GMT) [ 33 82 49 ] # ( ) 0411 00000080 100 540 7
N 0.0000000 E 0.0000000 ( F-Wireless Zone ) BSS ( 00:19:e8:d8:c2:e0 ) 16:44:39 (GMT) [ 24 73 49 ] # ( ) 0421 00002000 100 540 13
What I would like to do is extract the MAC addresses into another text file so that it ends up looking like this:
I'm pretty new at this whole scripting thing, but I've managed to work our a couple of steps of this process.
1) I can use grep 'N 0.0' to get just the lines with MAC addresses
2) I can probably use tr -d to delete the () around the MAC addresses
What I'm failing to be able to do is basically everything else
1) how do I get just the MAC addresses out of that long line?
2) how do I swap the ":" separating the parts of the MAC addresses for "." ?
I realise this is probably fairly straight forward, and I've tried looking in the various man pages for the likes of awk, sed and grep, but to be honest they are a little confusing.
Any help getting my Wireless Scan text file to look like my hoped for Final text file would be greatly appreciated!
Initially it didn't work, and returned "command not found" but after a little research I realised that nawk is just "new awk" so subtituted awk, and it worked. (I don't think OS X has nawk installed)
Thank you very much.
Secondary question, if you have time, could you explain how it's working...
What are the various parts of that command doing? It would help me in the future to understand what is going on.
Interesting. I really like that way of doing it actually. And as you say, could be useful if NetStumbler changes their output format.
If anyone is interested, here is the finished script.
Code:
#!/bin/sh
# This script combines the Netstumbler wireless reports and trims and formats them for the monthly report.
# It needs to be run from the directory in which the text files are stored.
# There should NOT be any other files in the directory, and they should all have the file extension .txt
# Combines the files into one
cat *.txt > all0.txt
# Trims out only relevant lines
grep 'N 0.0' all0.txt > all1.txt
# Trims out the rubbish, and outputs the MACS only
awk -F'[()]' 'NR {print $4}' all1.txt > all2.txt
# Substitutes "." for ":" as the MAC address separators
sed -e 's/:/./g' all2.txt > MAC_addresses_from_wireless_scan.txt
# Removes the leftover text files.
rm all0.txt
rm all1.txt
rm all2.txt
I'm sure there is a neater way to do it, without the intermediate files, but as I'm fairly new at this scripting, and just wanted the job done, I went with the way I was sure I could do it.
Hy over there,
Lets make it simple :)
Using a bash script, how to grep only the ip address and the mac address and put them in a file:.
for example from the dhcp.conf file we got such things:
The script will end up with two columns IP's and MAC adresses as it is showed below:
... (9 Replies)
I have a problem with a script , i want to see my devices there are up in my network. I want as output the ip addresses of the devices and also the mac address but I only had the ip addresses
#!/bin/bash
while ]
do
-mac)
Extension=5
shift
mac=$1
shift
;;
esac... (1 Reply)
Greetings.
I'm in the process of tracking down an issue with Firefox, and need some way of gathering the actual web addresses which are connected to from localhost.
The specific problem centers around the determination/capture of the exact generated app.update.url address formed by the... (2 Replies)
Hi
I have an input file with a list of random IP addresses, each on a new line. Below is just an example as I omitted the real IP addresses for obvious reasons.
Input: random_ip.txt
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1
10.0.0.1... (7 Replies)
If a web search is done on this topic there are many links but no information included in the documents. So my questions are;
Why does a NIC card have it's own permanent ID. Why can't it share the host name? An ID is an ID.
Why does a computer need two ways to ID it.
If the network... (3 Replies)
Hi List,
Could someone please point me into the right direction with the following:
I have a file containing a list of street addresses.
I need to sort all the street addresses with the same number to a new file containing the street name and corresponding number.
So:
Strawinskylaan... (3 Replies)
All,
I have a flat file which contains an email address in every line. I am trying to find a way to extract all the email addresses delimited by comma (,). Can you please show me a way, it will be very helpful, thanks. (3 Replies)
Hi,
i am working on a project where i have to write a script to find out MAC addresses of the systems with given IP address.
Can anybody tell me which command i can use to find MAC address if you know IP address of the machine.
Thanks (5 Replies)
Im trying to use a shell script to send to a list of email addresses in a txt file. Here is what i have tried but it keeps sending to dead.letter...
Success.ksh contains...
mailx -s"Night Batch Success" 'cat /Scripts/email_addresses.txt' < /Scripts/email_body_message.txt
The email body... (1 Reply)
I am training to be support on our solaris based network and was wondering why solaris seems to assign the same mac address to all NICs placed in the machine regardless of how many NICs are in there, when i do a ifconfig -a all nics have same MAC.
Presumably this is a feature and there is... (1 Reply)
01-24-2008
