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.
Here are the logs :
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.
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.
You need to select data for one hour and count.
Here is an example on how to get one hour count of data
To get this automatically and tell only 3 hits between one hour is possible, but that is up to you to create.
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)