Need help in creating Windows Audit Script for Server 2003

Asked By meganwharding 0 points N/A Posted on - 09/10/2012

I want a script that can run on a Windows Server (any version) to display certain fields. I have audit some of my clients Windows boxes and would like to run a report on certain information. And I realize this can't be done in Power Shell as the servers don't all have Power Shell installed. I am assuming a VB script or even batch script would be sufficient.

Can anyone help me on this?

• Status: Open
• Question Views: 886
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: DOS & Windows

Answered By Niktha Busch 0 points N/A #138517

Need help in creating Windows Audit Script for Server 2003

in all the transactional system Audit is always one of the standard requirements. We need to create a structure audit table and create Insert, Update and Delete triggers to keep track of the info in the table that has been changed. This is a procedure that will create passed table in the below objects.

1. Creates an audit table with name <Tablename>_audit. It has some additional fields to capture the changes on the table.

• AuditDataState — States data state whether "New" or "Old".
• AuditDMLAction — States DML Action like "Insert","Update","Delete".
• AuditUser — Stores the action performed by the user on the table.
• AuditDateTime — Stores the date and time on which the action occurred.

2. Creates an insert trigger with the name <TableName>_Insert.

3. Creates a delete trigger with the name <TableName>_Delete.

4. Creates an update trigger with the name <TableName>_Update.

It will make the power shell work.

About Niktha Busch

Questions
1

Answers
100

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 09/24/2012
• Question Category: DOS & Windows