hi,

this is really a great thing for logging. i have also used the script for this purpose and succesfully runing the code. but i wana one change. this code enter the value into the db table when events trigger. i want that this code should run once in the day at a specifice time and log the whole information. i tried serveral thing but didnt get any thing,

i made this change in the query

query = "Select * from __InstanceCreationEvent" _

& " " & "where TargetInstance isa 'Win32_NTLogEvent'" _

& " " & "and TargetInstance.Logfile = 'Application'" _

& " " & "and (TargetInstance.EventType = 1 or TargetInstance.EventType = 2)" _

& " " & "and (TargetInstance.SourceName like 'MSSQL%')"_

& " " & "and (TargetInstance.timewritten = (now))" --- serveral more option also tried without any success

Faisal DBA

please any one has any solution on this