Skip to content

README.md

Latest commit

 

History

History
18 lines (15 loc) · 720 Bytes

README.md

File metadata and controls

18 lines (15 loc) · 720 Bytes

SQLServerTraceFileParser

Parse SQL Server Trace Files and Build Simple Alert System for Audit

Prerequisite

  • SQL Server 2008 R2 or SQL Server 2012
  • Powershell
  • Permissions

How to use

  1. Build Database $AuditDB.
  2. Build Table $TraceFileData in $AuditDB by using TraceFileData.sql.
  3. Set up arguments in TraceFileParser.ps1.
  4. Run and Test.
  5. Use SaveTraceFile.ps1 to save data into files.
  6. This version will save data into database which is specified, and this is different from v1.

To-Do

  1. Alert mail content need to be html for clearifing output. Use this for HTML Output, Please read the manual from the link.