- Contents
Interaction Administrator Help
Examples of changes to database tables
This help topic shows how the following types of database changes are tracked when the Enhanced Interaction Administration Change Log is enabled:
Setting or changing a user license
Assignment of a skill to a workgroup or user
Removal of a skill from a workgroup or user
Change_to_a_Default_User_attribute
Snapshot of initial data
This example shows a snapshot of data that was taken when the Enhanced Interaction Administrator Change Log was enabled. Notice that value in the ChangeType column is “Initial.” You can also see that both the IAAttributeLog table and the IALicenseAttributeLog table have multiple records tied to a single record in the EnhancedIAChangeLog table.
Change to a user attribute
This example shows the change log records that are created when you change an attribute on any property page in the Users container.
Addition of a user
This example shows the change log records that are updated when you add a user:
-
The UserLicense modification is tied to a record in the IALicenseAttributeLog table.
-
The Password attribute generates its own change log record.
-
The other properties are tied to the other EnhancedIAChangeLog modification record.
- A record in the EnhancedIAChangeLog with a ChangeType of Addition denotes that a user was added to the system; there are no attribute records tied to that entry.
Setting or changing a user license
This example shows the change log records that are inserted when the client access license and the ACD Media 2 licenses (with call and email qualifiers) are assigned for a user.
Deletion of a user
This example shows the change log record with the Change Type of Deletion. This indicates that the user record was deleted. The IAAttributeLog table is also updated to show what attributes were set on that user when the user was removed.
Assignment of a skill to a workgroup or user
This example illustrates how the database tables are updated when a skill is added to a workgroup and a user.
Note: If the EntryClass shows "SkillsUser" or "SkillsWorkgroup," then the skill was added from the Skills container.
Removal of a skill from a workgroup or user
This example shows the change log records that are updated when a skill is unassigned from a workgroup or a user. Change log records are logged for the users and workgroups that were assigned that skill, along with the deletion record.
Modification to a Role
This example shows the change log records that are created when you change an attribute on any property page in the Roles container.
Note: If the EntryClass shows "RolesUser" or "RolesWorkgroup," then the role was added/deleted from the Roles container.
Change to a Default User attribute
This example shows the change log records that are created when you change an attribute on any property page in the Default User container.
Related topics
About the Enhanced Interaction Administrator Change Log
Database tables for the Enhanced Interaction Administrator Change Log
Database views for the Enhanced Interaction Administrator Change Log