UMRA – Logging and Auditing at 5:43 PM

If you haven’t already, please read my first post on where and how to download a trial version of User Management Resource Administrator, developed by tools4ever.

Download Trial Version of UMRA > http://www.tools4ever.com/download/

UMRA – Logging and Auditing Overview

More and more clients we build UMRA - Automation / UMRA - Mass / UMRA – Delegation projects for are looking for a way to make sure that every action UMRA is taking on a Active Directory Object is recorded into some type of “record system”. In most cases, we will log this data out to a SQL database for the user to quickly obtain the Logging and Auditing information. Why is this important you may ask, and why would you or clients want this? The answer is simple, Audits and Compliance standards are everywhere theses days, and having all the actions taken on a user in Active Directory, at your finger tips, is a solution to this problem.

Here are a few steps on how get your projects to start Logging and Auditing UMRA scripts actions that affect Active Directory Objects.

UMRA – Logging and Auditing Steps

Step 1: Find out where you will store your log data – SQL / Access / CSV etc.Step 2: Setup your database, and database columns for the data to be inserted into.Step 3: For each script action, that affects an Active Directory Object
A. Affecting an Active Directory Object can be creation / deletion / modification
B. If your logging to a CSV then drag/drop a “Export Variables” action to your script, after your Action has taken place.
C. If your logging to a Database then drag/drop a “Update Database” action to your script, after your Action has taken place.
Step 4: Edit your action, to log your specific variables that you want to record.
A. For most of our clients, username, who did the action, time/date, action type, new value, old value are what they record into the database.
Step5: Repeat steps 1-4 on each action

Once all script actions are in place, you now have a compete logging system in place for your UMRA project.