Contains the information of the actions that are performed on the directory
Data model
Fields
| Field |
Type |
Description |
| action_date |
DATETIME |
Date on which the operation was performed in the directory |
| action_id |
INT |
ID of the action that was performed in the directory (Password Change = 0, Reset Password = 1, Unlock User = 2, Timed Out Question Attempts = 3, Generate Password Reset Email = 4) |
| auxiliary |
VARCHAR (50) |
Additional information about the operation (For security questions it saves the value of failed attempts, and for operations with the directory it saves the result of those operations) |
| domain_id* |
INT |
LDAP Unique Identifier |
| id* |
INT |
Unique audit identifier |
| ip |
VARCHAR (255) |
IP from which the operation was performed |
| type |
INT |
Audit Type (Takes No Action = 0, Blocking = 1) |
| user_id* |
INT |
Unique user identifier |
Primary Key
References
| Column |
Referenced Table |
Referenced column |
Name |
| domain_id* |
dbo.AFW_LDAP |
id |
FK02_APR_AUDIT |
| user_id* |
dbo.AFW_USERS |
user_id |
FK01_APR_AUDIT |
