Event Sink Project

• Event Sink Database
• Create EventSink DB in SQL Server (create-EventSink.sql)
• Create tblIgnoreList (create-EventSink-tblIgnoreList.sql)
• Create tblInBound (create-EventSink-tblInBound.sql)
• Event Collection Code
• Collect events from local or remote or multiple machines (EventSink.vbs)
• Scheduled Events (CScript)
• Delete Duplicate Events in DB (clusters make duplicates) (delete-duplicates-db.vbs)
• Mail any "Error" events as they occur (mail-errors.vbs)
• Display all Events involving a specified computer (display-all-comp-events.vbs)
• Create a log entry with computer's MAC address and IP and username (LogonTrack.vbs)

Please remember all this revolves around there being a System DSN called EventSink and utilizing Windows Authentication of the user running the script, this allows us to post and share code that has no connection string info or security credentials in it.