Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search query
Top Forums Shell Programming and Scripting Search query Post 302818879 by Don Cragun on Sunday 9th of June 2013 05:53:51 PM
Old 06-09-2013
John,
You keep saying basically the same thing without answering the questions needed to figure out what you're trying to do. Let me give you a simple list of questions. Answer them and we may be able to help, or we may have more questions:
  1. What exactly is the output you want (using CODE tags) when your input contains 3 searches that occur in an hour and show us sample data that we can use as a test that actually contains data that would cause a report to be generated?
  2. What determines the 1 hour time range:
    1. 3 BIND entries with timestamps <= 1 hour apart where the corresponding RESULT entries include SRCH=Q?
    2. 3 RESULT entries with SRCH=Q with timestamps <= 1 hour?
    3. 3 RESULT entries with SRCH=Q where the sum of the differences between the corresponding BIND and RESULT timestamps is >= 1 hour?
    4. something else?
    Note that none of the 1st three elements in the above list will trigger a report with any of the sample data you have given us! (However, C would be met if you wanted to report a user using more than one hour of search time in three or fewer searches if we used the data provided in your initial post in this thread.)
  3. Are all timestamps in non-decreasing order?
  4. Are all timestamps in increasing order?
  5. Are all timestamps in the same timezone?
  6. Do we have to worry about shifts to and from daylight savings time?
  7. Are all timestamps in an input file from the same day? If not, will there ever be:"
    1. days that have no RESULT entries with SRCH=Q?
    2. days that have no entries at all?
    3. a time difference between a BIND time and a RESULT time of more than 23:59:59?
  8. If a user has more than one 1 hour time period with 3 SRCH=Q RESULT entries:
    1. Should there only be 1 occurrence reported for the user?
    2. Should there be 1 occurrence reported for every set of 3 SRCH=Q RESULT entries that occur within an hour even if some of the SRCH=Q RESULT entries were used in an earlier report?
    3. Should there be 1 occurrence reported for every set of 3 SRCH=Q RESULT entries that occur within an hour but only if none of the SRCH=Q RESULT entries were used in an earlier report?
  9. Will every RESULT entry have a corresponding BIND entry?:
  10. Could the corresponding BIND appear in a different log file? If the corresponding BIND is not found, should some kind of diagnostic be printed? (If so, exactly what should the diagnostic be?)
  11. Can there be more than one search in progress for a given user at any time? (I.e., can there be two or more BIND entries before the RESULT entry shows up corresponding to the first BIND entry?
  12. Will conn=xxx always be in the 3rd field in every line?
  13. Will "BIND" and "RESULT" always appear in the 7th field in every input line? If so, will the 7th field on any line ever contain anything other than "BIND" or "RESULT"?
  14. On RESULT lines that contain "SRCH=Q", will that string always be the last field on the line?

I assume that you already know the answers to all of the above questions and just haven't shared them with us. If you can't answer some of these questions, please quickly let us know that so we can forget about this topic and concentrate on issues for other forum members. (Then when you can answer them, start a new thread with all of the details we need to be able to help you. And, if you need to start a new thread, show us what you have tried while working on solutions to this problem.)
Last edited by Don Cragun; 06-09-2013 at 06:57 PM.. Reason: fix typo
 

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

query on how to search for a line and read 4th word from that line

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)
Discussion started by: jaggesh
4 Replies

2. UNIX for Dummies Questions & Answers

LDAP search query help

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)
Discussion started by: dopple
3 Replies

3. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

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)
Discussion started by: balaeswari
6 Replies

4. UNIX for Dummies Questions & Answers

Search Query

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)
Discussion started by: theref
2 Replies

5. Shell Programming and Scripting

Ldap search query

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)
Discussion started by: posner
1 Replies

6. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

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)
Discussion started by: Rami Reddy
4 Replies

7. Shell Programming and Scripting

Complex string search query.

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)
Discussion started by: mohtashims
11 Replies

8. Programming

MYSQL query search between dates

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)
Discussion started by: barrydocks
4 Replies
All times are GMT -4. The time now is 06:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy