Hi,
I have a file containing the following data:
junk123junk723itemcode001qty01price10total10junkjunk
junk123junk723itemcode002qty02price10total20junkjunk
..
..
..
could be 5000+ lines
I have an algo and need a code to implement this:
1. Linecount = wc -l (should give 5000)
2. For i... (1 Reply)
Hi
I connected to oracle database through shell script
My requiremnt is to get more than one record from the sql query.
How can i do in unix to get multiple records. (1 Reply)
output of Unix & sql in same file
hi all,
am working on shell script, i need to format data in such a way
that both my Unix commands output & my sql output should be in a same file.
I am able to redirect both output in separate files.
for sql output: sqlplus -s... (6 Replies)
Hello Forum members,
Have a nice day.
I have to write a script for the following below scenario.
There are 3 applications located in home directory(ie xyz/app) which have multiple directories and files of diff format(.sh,log,other formats).
Case 1: I have to find the hardcoded... (8 Replies)
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Hi All,
Just have a requirement, I am executing a bash shell script, my requirement is to catch the pid and job name to a txt file in the same directory, is there anyway to do it? please help me out.
Regards
Rahul
---------- Post updated at 08:42 AM ---------- Previous update was at... (2 Replies)
Hi ,
I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body.
p_id src_system amount
1 A 100
2 B 200
3 C ... (3 Replies)
Hi,
I need help in writing a shell script which can read data from a text file (Cancel_ID.txt) and then calls sqlplus session (Cancel.sql) with the first line parameter of the text file ("0322600453") till all rows are not completed.
... (4 Replies)
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
LEARN ABOUT DEBIAN
get-oui
GET-OUI(1) General Commands Manual GET-OUI(1)NAME
get-oui - Fetch the arp-scan OUI file from the IEEE website
SYNOPSIS
get-oui [options]
DESCRIPTION
get-oui fetches the Ethernet OUI file from the IEEE website, and saves it in the format used by arp-scan.
The OUI file contains all of the OUIs (Organizationally Unique Identifiers) that have been registered with IEEE. Each OUI entry in the
file specifies the first 24-bits of the 48-bit Ethernet hardware address, leaving the remaining 24-bits for use by the registering organi-
sation. For example the OUI entry "080020", registered to Sun Microsystems, applies to any Ethernet hardware address from
08:00:20:00:00:00 to 08:00:20:ff:ff:ff inclusive. Each OUI assignment represents a total of 2^24 (16,777,216) Ethernet addresses.
Every major Ethernet hardware vendor registers an OUI for their equipment, and larger vendors will need to register more than one. For
example, 3Com have a total of 37 OUI entries. Organisations that only produce a small number of Ethernet devices will often obtain an IAB
registration instead. See get-iab(1) for details.
This script can be used to update the arp-scan OUI file from the latest data on the IEEE website. Most of the Ethernet addresses in use
belong to an OUI registration, so this is the most important of the files that arp-scan uses to decode Ethernet hardware addresses. You
should therefore run get-oui occasionally to keep the arp-scan OUI file up to date.
The OUI data is fetched from the URL http://standards.ieee.org/regauth/oui/oui.txt and the output file is saved to the file ieee-oui.txt in
the current directory. The URL to fetch the data from can be changed with the -u option, and the output file name can be changed with the
-f option.
The ieee-oui.txt file that is produced by this script is used by arp-scan to determine the Ethernet card vendor from its hardware address.
The directory that arp-scan will look for the ieee-oui.txt file depends on the options used when it was built. If it was built using the
default options, then it will look in /usr/local/share/arp-scan.
OPTIONS -h Display a brief usage message and exit.
-f <fn>
Write the output to the specified file instead of the default ieee-oui.txt.
-u <URL>
Use the specified URL to fetch the raw OUI data from instead of the default http://standards.ieee.org/regauth/oui/oui.txt.
-v Display verbose progress messages.
FILES
ieee-oui.txt
The default output file.
EXAMPLES
$ get-oui -v
Renaming ieee-oui.txt to ieee-oui.txt.bak
Fetching OUI data from http://standards.ieee.org/regauth/oui/oui.txt
Fetched 1467278 bytes
Opening output file ieee-oui.txt
9274 OUI entries written to file ieee-oui.txt
NOTES
get-oui is implemented in Perl, so you need to have the Perl interpreter installed on your system to use it.
get-oui uses the LWP::Simple Perl module to fetch the data from the IEEE website. You must have this module installed on your system for it
to work. This module is available on most distributions, often called libwww-perl. It is also available in source form from CPAN.
You can use a proxy server by defining the http_proxy environment variable.
AUTHOR
Roy Hills <Roy.Hills@nta-monitor.com>
SEE ALSO arp-scan(1)get-iab(1)arp-fingerprint(1)
http://www.nta-monitor.com/wiki/ The arp-scan wiki page.
March 30, 2007 GET-OUI(1)