I have this script I wrote to track users when they log onto AD for a future project. The SQL portion does a IF THEN ELSE scenario the issue is my vbs script is returning an error:
Incorrect Syntax near 'UPDATE logons SET Timestamp=GETDATE() WHERE Username='
I checked the syntax of Line 27 which is the beginning of the query statement so I dont know which part I have wrong.
I attached the error and the VB script.