I have a typical requirement to find users having at least three occurrence in a log within an hour, and perform some action for that user. We have several steps, however I am kind of stuck here to accomplish the said requirement.
Basically, we need to find any user ( ie uid=xyz123), getting "SRCH=Q" in a particular connection have more than three occurrence within an hour. If you see the logs, they are related with "conn=13570".
In brief, here is the logic :
- Get the "SRCH=Q" occurence.
- Get the associated conn #, go back and get the bind user.
- Carrying bind user, search for "SRCH=Q" occurrence, if > 3, run add group command.
Let me know if we can get this via grep, sed or awk.
Thanks, JPrince
---------- Post updated 06-07-13 at 12:24 AM ---------- Previous update was 06-06-13 at 02:17 PM ----------
Hello,
Any reply on this?
JPrince
Last edited by johnprince1980; 06-06-2013 at 04:34 PM..
If you see the below logs, how can i search for "SRCH=Q", and then get the string in the same row "conn=13570", and perform another search to get "uid=xyz123" by looking up "conn=13570" and BIND String ( as mentioned in the first row).
I want to do this activity until I get three searches, and then store the user in a list.
awk 'FNR==NR {if ($0~"BIND") {split($8,s,"=|,");a[$3]=s[3]};if ($0~"SRCH=Q") b[$3]=$12;next} END { for (i in b) print b[i],i,a[i]}' file file
SRCH=Q conn=13570 xyz123
SRCH=Q conn=13572 xyz456
The intent here is to get the output only when there are 3 or more occurrences of search. When I run the code, it gives me an output even there are one occurrence.
Just a little help if possible
I have a table with date data, I want to select dates that fall between today and 1 month ago, here's my query
SELECT id, stdate, DATE_SUB(CURDATE(), INTERVAL 1 month) as monthago, CURDATE() as today
FROM data_table
where (stdate between 'today' and 'monthago')... (4 Replies)
Hi,
I wish to find the latest occurance of the below string in my log file.
Once found, I need to search the below string after the above string
and display this
Request 331489 has passed
or
Request 331489 has failed
I would like my query to be platform... (11 Replies)
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Hi All,
I have a existing Ldap query which take a HOME as variable and gives the result where i grep for a particular line.
ldapsearch -h server_domain_name -p 389 -D "uid=user,ou=appadm,o=ent" -w PaB -b "ou=roles,o=ent" "cidx=$HOME" | grep -w "ent: xyz"
Now i have 330K Homes in a... (1 Reply)
This issue has been causing me a headache all night....
I have a file, from a third party payment vendor, that contains an export of data including an order number (unique) and a payment value, amongst other data. I need to use the order numbers to integrate the database to check the order... (2 Replies)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
I would like to do an ldap search which looks for entries which do not actually have a certain attribute. Not that the attribute is Null, but where the attribute does not exist.
Is this possible using ldapsearch? (3 Replies)
Assume I have a text file as below:
me
con pi
ind ken
pras ur
me
con rome
ind kent
pras urs
pintu
con mys
ind pan
pras ki
con kit
ind sys
My requirement,
I need to search for "con rome" and if exists, then print 4th word from rome, i.e in above example, since "con rome"... (4 Replies)