Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. OneArk

    Summary and average per minute

    I had to do some adjustments to the data formatting, I got rid of the seconds in the time stamp, so it looks like APP01 2016-02-16 00:03 111 APP01 2016-02-16 00:03 145 APP01 2016-02-16 00:03 231 APP01 2016-02-16 00:03 132 APP01 2016-02-16 00:03 73 then I passed it to the Following AWK...
  2. OneArk

    Summary and average per minute

    Hello, I am trying to find out the average response time per minute from a log file that contains the response time in milliseconds. I would like to pipe the results into Awk and end up with the summary. I am looking for the most effective way to do it. The desired result is one line per...
  3. OneArk

    Validate Data in MySQL

    God bless you all, works like a charm. Happy New Year.
  4. OneArk

    Validate Data in MySQL

    Thanks Tarn and R937 for the direction, I will research and if there is a problem I will post again. I appreciate your advice.
  5. OneArk

    Validate Data in MySQL

    Hello, I am new to (MySQL 5.5/Apache/PHPMyadmin) I am also using Toad when I work on the localhost (just because I have it). I would like to get direction of what to search for, or research. In other words I am unable to find the right terminology for my search, which so far is not giving me...
  6. OneArk

    totext

    if you wish you can try. Had the same issue with decimal points this morning. replace(totext({?Year}),",","") that should remove the comma
  7. OneArk

    Archiving Log Files

    That Works perfectly, what does the following code do? I removed it and it worked good as well. do while wshexec.status <> 1 : wscript.sleep 50 : loop
  8. OneArk

    Archiving Log Files

    thanks Tsuji, will try that and let you know how it went.
  9. OneArk

    Archiving Log Files

    The following part never worked and never created that text file & " >> d:\docs\logs.txt" how would I transform the code to use the exec method? can I pass variables to it?
  10. OneArk

    Archiving Log Files

    Thanks, jges, but that is the example I used to exec but still did not work, I do not seem to be able to pass variables to it. Microsoft VBScript runtime error: Object doesn't support this property or method
  11. OneArk

    Archiving Log Files

    Do you have an example of exec? I tried the following, it zips the fisrt file then quits. With Run it goes through the loop. if LOGAge > 1 Then strRunLOG = objShellLOG.Exec (StrCMDLOG) End If
  12. OneArk

    Archiving Log Files

    Hi I am trying to create a VBScript that will go through log files on a server, then move it to an archive location if older than one day. I am new to VBS, however I used Visual Basic back in 98 so I may still have some logic building skills but as far as vbs understanding I may not be very...

Part and Inventory Search

Back
Top