07-02-2012
wtmp file - is there a patch to export the data another file each day?
sorry for being a noob, i am trying to find which user accessed the server at what time and there ip address at first i used who command but the output didn't contain the ip address then i used the last command which provided me with the ip of the users but when i searched i searched and found that both commands use to retrieve the data from a file called wtmp.
- does both use the same file ?
- i found that the file contains only record for the last day how can i increase the time the this file hold the data ?
- is there a patch to export the data another file each day ?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am searching a way to export data file on Unix to SQL server on a daily bases.
Any one has any ideas?
Thanks in advance! (20 Replies)
Discussion started by: whatisthis
20 Replies
2. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
3. Shell Programming and Scripting
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
Discussion started by: ss3944
2 Replies
4. Shell Programming and Scripting
Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.
Any unix/linux tools, scripts available?
Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies
5. Shell Programming and Scripting
Hi,
So I'm kinda new to shell scripts and the like. I've picked up quite a bit of use from browsing the forums here but ran into a new one that I can't seem to find an answer for.
I'm looking to parse/find a string AND the next 15 or so charachters that follow the string within a text file... (1 Reply)
Discussion started by: kar23me
1 Replies
6. Shell Programming and Scripting
Hi,
I am trying to export the data to an .ixf file.
I have read the table names from a .dat file and those table name should be passed to the select * from schema.TABLENAME query .
I am trying the below loop
while read TABLE; do
db2 EXPORT TO ~/data_export/$TABLE.ixf OF IXF MESSAGES... (5 Replies)
Discussion started by: vikyalex4
5 Replies
7. Shell Programming and Scripting
Hi All
I will run the same script every day in corn and output should go to same CSV file but in different row with dates on it. Below is my example in attached format.
Script i am using to collect switch port online
DATE=`date '+%d-%m-%y'`
for f in `cat... (1 Reply)
Discussion started by: ranjancom2000
1 Replies
8. Shell Programming and Scripting
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
hive -e "select * from test " > /home/user/test.txt ;
... (1 Reply)
Discussion started by: STCET22
1 Replies
9. Linux
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Discussion started by: lxdorney
7 Replies
10. Shell Programming and Scripting
Greetings,
After a few hours of trial and error, I decide to ask for some help.
I am new to AWK and shell script, so please don't laugh :p
I made the below script, to gather data from some logs and have the output into a CSV file :
#!/bin/sh
#Script to collect Errors
... (9 Replies)
Discussion started by: Yagami_Sama
9 Replies
LEARN ABOUT DEBIAN
rawtmp
RAWTMP(1) General Commands Manual RAWTMP(1)
NAME
rawtmp - display wtmp entries in raw form.
SYNOPSIS
rawtmp [-da] [-w wtmp|-] [-X[3|4]d] [-s start] [-e end] [-b H:M:S] [--help] [--version]
DESCRIPTION
Rawtmp is a utility to dump the raw data in a wtmp or utmp file to the screen for viewing. It may be useful to anyone who wishes to divine
the nature of the data stored in the wtmp or utmp files. It may also be useful to extract special wtmp entries that are not documented
anywhere (like those netdate puts in the wtmp file).
If on a logout, when the username is encoded in the ut_user field by replacing the first character of the username with a null, rawtmp will
print the contents of the user field with a leading dot '.' to denote the null character. Only agetty and tacacs control software are cur-
rently known to use this logging method.
OPTIONS
Rawtmp understands the following command line switches:
--help Outputs a verbose usage listing.
--version
Displays the version of rawtmp.
-w wtmp
Select a different input file instead of the default (/var/log/wtmp).
-X[3] Read a wtmp file maintained by versions 3.3 or 3.4 Tacacs terminal server access control software.
-X4 Read a wtmp file maintained by version 4.0 of Tacacs terminal server access control software.
-d Output the time in MMM DD HH:MM:SS format instead of raw time for a more human readable form (and to actually know what day you're
looking at!).
-a Print the contents of the ut_addr field (in quad-dotted notation) instead of using the ut_host field. Note: ut_addr is almost never
used and more than likely contains garbage information.
-b hours[:minutes[:seconds]]
Consider only those utmp entries that fall within the last few hours/minutes/seconds from the current time, disregarding the rest.
-s start
Selects the starting date of the report, in mm/dd/yy format.
-e end Selects the ending date of the report, in mm/dd/yy format.
FILES
/var/log/wtmp login database.
AUTHOR
Steve Baker (ice@mama.indstate.edu)
BUGS
Could use some filtering options.
SEE ALSO
last(1), sac(8)
UNIX Manual RAWTMP(1)