[VOPRadius] Log Analyzer

[Ron Fitzgerald]

Sorry, I just re-read you last post.   A typical SQL statement can be:   SELECT * FROM accounting WHERE LogDate >='2003-07-11' AND LogDate <='2003-07-13' AND LogTime >='00:00:00' AND LogTime <='23:59:59'   The above statement is querying any accounting records that were created between July 11th, 12 am and July 13th, 11:59 and 59 secs pm   If you had an IP address, you can add this to the end of the query: AND NasIPAddress ='192.168.0.1' ( of course adding the real IP )   -and/or-   If you had a username, you can add this to the end of the query: AND UserName ='username'   Ron ----- Original Message ----- From: WMOL Administration To: [EMAIL PROTECTED] Sent: Monday, July 14, 2003 12:33 PM Subject: [VOPRadius] Log Analyzer * This is the VOP Radius mailing list * Text and MS-SQL. Scot ----- Original Message ----- From: "Ron Fitzgerald" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 14, 2003 12:30 PM Subject: [VOPRadius] Log Analyzer What method are you using for keeping logs? Access, text, my/sql? Ron   ----- Original Message -----   From: WMOL Administration   To: [EMAIL PROTECTED]   Sent: Monday, July 14, 2003 12:26 PM   Subject: [VOPRadius] Log Analyzer   * This is the VOP Radius mailing list *   Greets,    Anybody know of an easy way to see who was on at a specific time? We are   attempting to cooperate with the local law here and they need who was on at   a few specific dates / times. I can manually scan the logs for those times   but it doesn't really give me the full scope of things since someone could   of logged on 2 hours earlier, etc...   TIA,    Scot   **   To leave this list, send an email to [EMAIL PROTECTED]   and put the word "LEAVE" in the BODY of the email. ** To leave this list, send an email to [EMAIL PROTECTED] and put the word "LEAVE" in the BODY of the email.