N/APosted 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?
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.