Need A Script To List All Failed Log In Users


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Need A Script To List All Failed Log In Users
# 1  
Old 02-09-2011
Bug Need A Script To List All Failed Log In Users

I need to list all the failed log in users as part of audit report. How can I do so in Linux to find all the audit log records and then upload to a table for future reference. I am using oracle 10g on Linux. Hope I will get a quick response from the experts.
Thanks in advance for the tips.
# 2  
Old 02-10-2011
You might look at the faillog command, if your systems are linux. However, as near as I can tell, this doesn't catch things like ssh keybased auth.

In all likelihood, the most comprehensive way is to parse syslog files. That's not terribly hard, at least if you have your logging centralized to one server.
# 3  
Old 02-10-2011
If you are talking about failed unix logins, check out the "lastb" command.
The strategy depends on how long you keep your wtmp and btmp data files.

If you are takling about Oracle, then you'll need to locate the right log (or table) if your system maintains such records.

Last edited by methyl; 02-10-2011 at 05:40 PM.. Reason: typo
# 4  
Old 02-13-2011
Thanks everyone for giving some tips. However, I need a proper script to separate the failed log ins from a pool of all the log ins. I have a list of all the log ins in the form of .aud files from which I cannot find the failed ones. The script has all the details like linux node, userid, sessionid,objname, activity etc. Note that, I got most of the columns in sys.aud$ table. If anyone can guide me more in this regard, it will be a good help for me.
Thanks.

Last edited by oraQ; 02-13-2011 at 11:41 PM.. Reason: Typo
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Script to find Error: rpmdb open failed on list of servers

Hello all, I have a task to patch red hat servers and some servers have a corrupted rpm database and return the error: Error: rpmdb open failed I know how to fix this when it occurs. What I'm hoping to do is scan a list of servers by IP and report back which server have this error. ... (6 Replies)
Discussion started by: greavette
6 Replies

2. Shell Programming and Scripting

List the Manager of Users in AD - Using list- Get-ADuser

Is there any command that can used in Linux that export usernames and their manager's name from AD using bash shell script? I know this can be done using powershell but I need to use Linux for this procedure. (2 Replies)
Discussion started by: dellanicholson
2 Replies

3. Shell Programming and Scripting

Shell Script to zip users cmd history log files

I admit I am terrible with scripting, so when I was asked to store users' command history lines and zip them on monthly basis what I did was to create a file "user_history_Feb" with the following contents: Part A # more user_history_Feb cp -p /var/log/user_history/*history... (6 Replies)
Discussion started by: hedkandi
6 Replies

4. Shell Programming and Scripting

Script Help -- documenting specific users that log into server

Hello All, I am trying trying to write a shell script that will do a couple things: 1.) Identify any username that logs into the server. 2.) When the user logs out, send them an email detailing their log in/out times, duration logged in, and what processes they ran. Basically,... (3 Replies)
Discussion started by: SecureScript
3 Replies

5. Shell Programming and Scripting

help to create script for added date to list users

hi my friends im asking for the possibility to creat a script in ubuntu for added date to list users for doing this : - search in debug connected user of all connected users - if a new user is connect for the first time to my server the script record the date of the connection and added it... (1 Reply)
Discussion started by: amzioujda
1 Replies

6. Shell Programming and Scripting

script to ignore the user from list of users

Hi, I have a situation where I want to ignore few users from list of users and print rest of user in log file. say, I want to ignore aaa, bbb, ccc, ddd .. ppp from list of 20 user (do not want to include) What is the good command or any script? Thanks in advance. (1 Reply)
Discussion started by: sumit30
1 Replies

7. Shell Programming and Scripting

Script to list primary group of users

Dear All I am facing a problem with my script. I have to found the primary group of users . So first I selected all the groups and users register from a specific user : ONE Then I am making a file with all groups attached to the user : ONE Then I am making a file with all... (8 Replies)
Discussion started by: Aswex
8 Replies

8. Shell Programming and Scripting

Script to list users and their last login?

hi all, I'm trying to write a script to create a file with a list of all users, their gid, gecos field and their last login time e.g. fairly new to scripting, this is what I've got so far #!/bin/sh( userlist= cat /etc/passwd | awk -F: '{print $1," ",$4," ",$5}' for name in $userlist... (3 Replies)
Discussion started by: tanngo
3 Replies

9. Shell Programming and Scripting

Need to know abt script that invokes batches and get d log files if batches failed

hi , I need to know commands to be used in the script to invoke batches in order from other scripts and then run those batches,and how to take those logs of those batches which fails........If anyone give me a better idea to complete this entire task in a single script... (5 Replies)
Discussion started by: gopimeklord
5 Replies

10. Shell Programming and Scripting

Bourne Shell script - log for users loggin on and off

Hello all, I'm new to shell scripting and want to make a script that I can write to log the users logging on and off the a unix system. I have had a good look over the past few days to crack it, I think I am getting close. I want a script that runs an infinite loop to check every 5 seconds... (14 Replies)
Discussion started by: noodlesoup
14 Replies
Login or Register to Ask a Question