To obtain information, the who command usually examines the /etc/utmp file. If you specify another file with the File parameter,
the who command examines that file instead. This new file is usually the /var/adm/wtmp or /etc/security/failedlogin file.
Normally a plain last shows all entries. Though you can try who -a /var/adm/wtmp if it shows more.
/etc/utmp contains much less entries than /var/adm/wtmp.
/etc/utmp stores the logins, while /var/adm/wtmp stores archives everything together with information that will be used if you are using the Advanced Accounting facilities of AIX.
I just did a check on a box and here is the outcome:
Do you maybe have a job that tries to save space in /var and just overwrites or nulls /var/adm/wtmp? It can happen on machines, that are very busy login-wise, that this file can get very big very fast. Maybe that's the reason a last shows only last's day entries.
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)
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)
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)
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)
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)
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)
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)
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)
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 BSD
ac
AC(8) System Manager's Manual AC(8)NAME
ac - login accounting
SYNOPSIS
/usr/sbin/ac [ -w wtmp ] [ -p ] [ -d ] [ people ] ...
DESCRIPTION
Ac produces a printout giving connect time for each user who has logged in during the life of the current wtmp file. A total is also pro-
duced. -w is used to specify an alternate wtmp file. -p prints individual totals; without this option, only totals are printed. -d
causes a printout for each midnight to midnight period. Any people will limit the printout to only the specified login names. If no wtmp
file is given, /usr/adm/wtmp is used.
The accounting file /usr/adm/wtmp is maintained by init and login. Neither of these programs creates the file, so if it does not exist no
connect-time accounting is done. To start accounting, it should be created with length 0. On the other hand if the file is left undis-
turbed it will grow without bound, so periodically any information desired should be collected and the file truncated.
FILES
/usr/adm/wtmp
SEE ALSO init(8), sa(8), login(1), utmp(5).
4th Berkeley Distribution November 16, 1996 AC(8)