Search results for query: *

I think I got it now 'Option Explicit 'On Error Resume Next '========================================================================== ' VARIABLE DECLARATIONS '========================================================================== Dim objFSO, strInput, strOutput, strLine, objEmail...

guitarzan, Nice! That worked, but it's only checking yesterdays date. How can I make the search do both yesterday and todays date? Thanks

Bummer, I thought this script was working, but it's not. I clearly had some errors in the errorlog yesterday that didn't get picked up. I want to look through this log for the word error, starting at yesterday's date and checking through todays. Here's the code, if I leave the variable...

Yes, it's worked out great. I posted this, but could not modify my post. I changed my script and put a link to your function for cred. Thanks

I think I figured it out '========================================================================== ' ' NAME: Error Log File Check by Date.vbs ' ' AUTHOR: Gene Magerr ' EMAIL: genemagerr@hotmail.com ' ' Comment: This script checks the file \\Shcwebtrans\logs\shipconfirmemail.log for ' the word...

Sorry, I'm looking for this line An error occurred while receiving the HTTP response to https://api.Se.......

Hi, I have a log file I must look through each morning to see if there were any failures the previous day. Here's a small sample 1/16/2013 1:40:00 PM | Starting process ========================================================== 1/16/2013 1:40:00 PM | Import ERP order email data... 1/16/2013...

Ok, i figured out how to do an instr so I don't double name the files. Last question In my t variable, how can I add AM or PM to the time? Thanks

I have another problem. If I run the script twice, it doubles all of the stuff i'm adding the first time. Anyway to check if PPW-OFU is in the filename, if it is just skip renaming that file? I want to rename only files with their original filename Thanks

PHV, Thanks, that did it. I also needed to format the date the same way. Your suggestion worked on the date too. Thanks

Skip, I'm not sure what you mean by check out the assignment of variable t? Variable t is producing the 5.3.22 AM and I need it to read 05.03.22 AM. How can I format the Hour(Time) Minute(Time) and Second(Time) to do that? Thanks

I am trying to rename files in folders with the name of the folders in which they reside, the date and time and some other things. I would like the time to read 05.03.22 AM and it's coming up 5.3.22 AM here's the code, can someone assist with the time portion? Thanks Call...

Got it! Thanks guys, here's the change '========================================================================== ' MAIN SCRIPT CODE '========================================================================== Set objTextFile = objFSO.CreateTextFile(strReport) txt = "" txt = txt & "Server"...

PHV, I've been trying to add the header in the script all morning. I am not sure how to get it to insert outside of the loop. I' ve moved it all around, but with no success. It always seems to wind up in the loop somehow. If I move it about the "Do While Not" the file comes out blank. I'm...

Hi, I have two scripts. One gets me drive space for a list of servers, and the other will add a header to the top of the text file created by the first script. If I run them as individual scripts, it works fine. When I try to add the script that writes the header into the script that generates...

Thargy, Thanks again for the input. I will make the changes you recommended and check the data types.

Thargy, OK, I've redesigned, and this is what I have now. I renamed the locations table to addresses. I'm a little unsure of that as we have three major locations, would the way i currently have the design satisfy that? in other words is it ok to use the addresses table for the suppliers...

Thargy, Fantastic, thanks for all the useful input. The database started out relatively simple, as I read more about normalization, the more I tried to seperate everything. I'm going to re read your suggestions and apply them to the DB. i'll post the new model. thanks again

Hi, I'm struggling with normalizing a database I've created. I basically attempting to create an asset management database for my computer center. I've attached a screenshot of what I have so far. I'm trying to depict several things. Category - Server, Network, Storage SAN, Storage Other, Misc...

Hi guys, This script is changing the admin password on every other server in the successping.txt file. I can't figure it out, can someone help? Thanks '========================================================================== ' ' NAME: Reset Local Admin Password.vbs ' ' AUTHOR: Gene...