Need help in creating Windows Audit Script for Server 2003

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #138517

Need help in creating Windows Audit Script for Server 2003

qa-featured

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.

Related Questions