Feedback

  • Contents
 

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:

Snapshot of initial data

Change to a user attribute

Addition of a user

Setting or changing a user license

Deletion of a user

Assignment of a skill to a workgroup or user

Removal of a skill from a workgroup or user

Modification_to_a_Role

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.

Back to top

 

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.

Back to top

 

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.

Back to top

 

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. 

Back to top

 

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.

Back to top

 

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.

Back to top

 

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.

 

Back to top

 

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