markd89

Edit: I'm just going to use Powershell for this and AutoIT for everything else.

Thanks much! I have it almost figured out. I posted one question in the thread you linked to. If you have a suggestion there, it'd be also much appreciated! Thanks, Mark

Hi, I have been hacking on your code here I would like to query and get only the stuff from the last hour. I can't seem to get the syntax right. $oResult=readEvent(@computername,"","","root\cimv2","Select * from Win32_NTLogEvent Where Logfile = 'Application' and TimeWritten> '20180723' ") seems to work OK. The following, where I try to get stuff after 1pm doesn't work. I have tried various combinations without success. $oResult=readEvent(@computername,"","","root\cimv2","Select * from Win32_NTLogEvent Where Logfile = 'Application' and TimeWritten> '201807231300' ") Any pointers much appreciated!

Hi, I'd like to make a script that counts the number of log entires in the Windows Application Log, System log and Security Log for the last hour only. I'm then going to pass that to another tool which graphs. Usually the number of entries will be 0 or just a few. If there are hundreds or thousands of them, then I know I have an issue I need to look at. I found _EventLog__Count but it doesn't let me get the data for just the last hour. I know I can store the last result in a variable and compare it hour to hour. That would be OK, but then if the log is cleared or my app doesn't run for a while, it gets screwy. Better would be something discrete that just counts for the last hour and returns that number. Any suggestions? Can _EventLog__Count be modified to take a date? Any help or best, sample code, much appreciated! Mark

Hi, I'm not an ADO expert :-( I got the _Example_MSSQL() to work OK. When I try _Example_MSSQL_COMMAND_StoredProcedure(), I always get a Messagebox with title @Result1 and no content. I tried hacking on this for a while, including having it create the Proc as testing1 rather than #testing1. I could then easily modify and test the proc directly in SQL and get it to return results, but still could not get AutoIT to do the same with that proc. I'm not sure if the example is broken or I am doing something wrong, or both ;-) My project should be pretty easy. I just need to EXEC a stored procedure passing it some parameters and then get the result into a string variable. My result is a single value -- not several fields, not several rows. Any suggestions or more simple examples would be greatly appreciated!! Thanks! Mark

(deleted)

Thanks!

I need to activate a Window but I don't have it's exact title. I have only what the title begins with. For example: I want to detect "Test Application" in the title and activate the window whether the title is "Test Application" or "Test Application - document1" or "Test Application - foo" Is this possible? Thanks, Mark

Thanks, that did it!

Hi all, I want to have an INI file in the same directory as my compiled script. I'd like the EXE to detect where it is running from so I know where to open the INI from. I think there's a WINAPI way to know where the EXE is running from, but I'm hoping for an easier suggestion.. Thanks! Mark