Expand All Collapse All
Administrative Data

Administrative Data

This class of data includes the Interaction Administrator (IA) Change Notification table and the IC Change Notification table. These tables are audit trail tables for configuration changes you make in CIC. Both of these tables record changes you make in CIC, but they do so from different levels of the system.

Data Source

The data source for this class of data is event driven by changes you make in the configuration in Interaction Administrator, or any change you make to the CIC configuration in the case of the IC Change Notification log.

Type of Information Stored

The type of information we store in this table are class, path, key, user and station making the change (not available for IC Change notification), and type of change.

Report Types using this data

The administrative report types use this data to allow you to search for changes by class and other attributes.

Interaction Administrator Change Notification Table

This table is a log of all changes you make using the Interaction Administrator program. CIC adds a record in the IA Change Notification table for any change you make using Interaction Administrator. A change you make using handlers or other methods is not recorded here.

Physical Attributes

Log Identifier Log Name Table Name

7

Interaction Administrator Change Notification Log

IAChangeLog

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ChangeDateTime datetime False No

Date/time of the change.

 4.0.106.453 4.0 Release
ChangeTime char (8) False No

Time of the change.

 4.0.106.453 4.0 Release
ChangeDateTimeGMT datetime False No

Date/time of the change adjusted to Greenwich Mean Time.

 4.0.106.453 4.0 Release
UserId nvarchar (50) False Yes

User identifier of the user whose configuration has changed. This is the User ID as defined in Interaction Administrator

 4.0.106.453 4.0 Release
StationId nvarchar (50) False Depends on customer usage

Identifier of station whose configuration has changed.

 4.0.106.453 4.0 Release
ChangeType varchar (50) False No

Type of change. Expected values are "Created", "Deleted", "Renamed", "Modified"

 4.0.106.453 4.0 Release
EntryKey nvarchar (128) False No

Entry path of the directory services key changed. Includes key name.

 4.0.106.453 4.0 Release
EntryClass nvarchar (50) False No

Directory services class of the key that was changed. Typical values are "User" or "Report Log".

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

System supplied date/time when the row was sent to the IC Logging server for insertion into the database.

 4.0.106.453 4.0 Release
SiteId smallint False No

Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data.

 4.0.106.453 4.0 Release
SubSiteId smallint False No

The purpose of this field is to divide use within a site, such as for multiple independent companies on one CIC system. Until CIC has such functionality, this field is zero and is reserved for future use

 4.0.106.453 4.0 Release


Constraints

Primary Key Name Type Column Name (sort order)
PK_IAChangeLog Non-clustered ChangeDateTimeGMT (Ascending)
SiteId (Ascending)
EntryClass (Ascending)
ChangeType (Ascending)
EntryKey (Ascending)


Index Name Type Column Name (sort order)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)
IEChangeTime Non-clustered ChangeDateTime (Ascending)
EntryClass (Ascending)
SiteId (Ascending)
IEEntryKey Non-clustered EntryKey (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)
IEStationId Non-clustered StationId (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)
IEUserId Non-clustered UserId (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)

Enhanced Interaction Administrator Change Notification Table

The EnhancedIAChangeLog table is the primary table that is used for the Enhanced Interaction Administrator Change Log. If you enable the log, changes in supported Interaction Administrator containers are logged in this table.

Physical Attributes

Log Identifier Log Name Table Name

6

Enhanced Interaction Administrator Change Notification Log

EnhancedIAChangeLog


Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
EnhancedIAChangeLogId int False No

Unique ID for the change

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeDateTime datetime False No

Local server date and time when the change was made.

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeTime nchar (8) False No

Local time of the change.

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeDateTimeGMT datetime False No

Greenwich Mean Time for when the change was made.

 16.1.0.378 Added for IA Enhanced Change Log.
UserId nvarchar (50) False Yes

The user ID that made the change.

 16.1.0.378 Added for IA Enhanced Change Log.
StationId nvarchar (50) False Depends on customer usage

The ID of the computer from which the change was made. This may also be the IP address in when the change was made from ICWS or IceLib APIs

 16.1.0.378 Added for IA Enhanced Change Log.
ChangeType nvarchar (50) False No

The type of change that was made. The values are Addition, Modification, Deletion, and Initial. Initial is the data taken when the system takes a snapshot point of the DS data.

 16.1.0.378 Added for IA Enhanced Change Log.
EntryKey nvarchar (128) False No

Is the specific item the change affects.

 16.1.0.378 Added for IA Enhanced Change Log.
EntryClass nvarchar (50) False No

Represents the IA container for which the change was made. Licenses and Skills are special cases. "License" denotes a change from the License Allocation container. "UserLicense" represents the license change was made from the user container. "StationLicense" represents the change was made from the stations container. Skills is represented in a similar manner. "Skills" denotes a change from Skills container, "SkillsUser" represents a change to the user from the skills container, and "SkillsWorkgroup" indicates a change to the workgroup from the Skills container.

 16.1.0.378 Added for IA Enhanced Change Log.
I3TimeStampGMT datetime False No

The Date/Time the entry was sent for insertion into the table.

 16.1.0.378 Added for IA Enhanced Change Log.
SiteId smallint False No

Site ID

 16.1.0.378 Added for IA Enhanced Change Log.
SubSiteId smallint False No

Reserved for future use.

 16.1.0.378 Added for IA Enhanced Change Log.
ApplicationID smallint False No

Application ID that the change was made from. The ID number corresponds to the one ID found in the ICApplications Table

 16.1.0.378 Added for IA Enhanced Change Log.


Constraints

Primary Key Name Type Column Name (sort order)
PK_EnhancedIAChangeLog Clustered EnhancedIAChangeLogId (Ascending)


Index Name Type Column Name (sort order)
IX_EnhancedIAChangeLog Non-clustered EnhancedIAChangeLogId (Ascending)

Interaction Administrator Attribute Log Table

The IAAttributeLog table is a child table of the IAChangeLog table. This table contains the specific attribute that was changed, the previous value, and the new value. There may be multiple records in the IAAttributeLog table that are for a single record in the IAChangeLog table.

Note: Changes involving licenses are not recorded in this table.

Physical Attributes

Log Identifier Log Name Table Name

Not applicable

Not applicable

IAAttributeLog

Column Definitions



Constraints




Interaction Administrator License Attribute Log Table

The IALicenseAttributeLog table is a child table of EnhancedIAChangeLog table. This table captures the changes made for a user or a workstation license attribute.

Note: There are several attributes for each user or workstation license. When a change is made to a user or a workstation license attribute, this table does not record which attribute was changed. Instead, all of the licenses for the user or station are written to the table.

To determine which specific attribute was changed, do a diff to compare the current set of license attributes with the previous set of license attributes. A set of records for a single change will have the same EnhancedIAChangeLogID.

Physical Attributes

Log Identifier Log Name Table Name

Not applicable

Not applicable

IALicenseAttributeLog

Column Definitions



Constraints




IC ApplicationsTable

The ICApplications table is

Physical Attributes

Log Identifier Log Name Table Name

Not applicable

Not applicable

ICApplications

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
Id smallint False No

An identifier that gets stored in certain tables: LoginLogoutChangelog and EnhancedIAChangelog, instead of storing the full application name.

 15.2.0.516 Added for storing application login and logout information.
ApplicationName nvarchar (50) False No

This is the name of an application that runs on an IC Server or connects to an IC Server.

 15.2.0.516 Added for storing application login and logout information.


Constraints

Primary Key Name Type Column Name (sort order)
PK_ICApplications Clustered Id (Ascending)


Index Name Type Column Name (sort order)
IX_Applications Non-clustered ApplicationName (Ascending)

IA License Lookup Table

The IALicenseLookup table is

Physical Attributes

Log Identifier Log Name Table Name

Not applicable

Not applicable

IALicenseLookup

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
IALicenseLookupId smallint False No

An identifier that gets stored in IALicenseAttributeLog table instead of storing the full license name.

 16.1.0.378 Added for IA Enhanced Change Log.
License nvarchar (200) False No

This is the name of a license, for example, I3_ACCESS_ACD_MEDIA_1.

 16.1.0.378 Added for IA Enhanced Change Log.


Constraints

Primary Key Name Type Column Name (sort order)
PK_IALicenseLookup Clustered License (Ascending)



IC Change Notification Table

The IC Change Notification table records any changes made through the Directory Services subsystem, including any configuration change. This includes every persistent user/agent status change made by a user or handler.

Note

These changes include security changes made to each user if the default user security is changed, so the number of entries this log generates could be very large, if you have it activated.

For this reason, CIC configures this log and table inactive. If tighter auditing is required, you can activate the log to provide the information detailed below, at the cost of additional database space and system performance.

Physical Attributes

Log Identifier Log Name Table Name

8

IC Change Notification Log

ICDirChangeLog

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
ChangeDateTime datetime False No

Date/time of the change.

 4.0.106.453 4.0 Release
ChangeTime char (8) False No

Time of the change as a string.

 4.0.106.453 4.0 Release
ChangeDateTimeGMT datetime False No

Date/time of the change adjusted to Greenwich Mean Time.

 4.0.106.453 4.0 Release
NotificationType varchar (50) False No

Type of notification. Expected values are:

  • Created
  • Deleted
  • Renamed
  • Modified
  • Inactive Created
  • Inactive Deleted
  • Inactive Renamed
  • Inactive Modified
Inactive types designate changes that occur in inactive portions of the configuration tree.		 4.0.106.453 4.0 Release
EntryName nvarchar (50) False No

Name of the entry changed.

 4.0.106.453 4.0 Release
EntryPath nvarchar (128) False No

Full path, including key, of the entry that was changed.

 4.0.106.453 4.0 Release
EntryClass nvarchar (50) False No

Directory Services class of the key that was changed. Typical values are User or Report Log.

 4.0.106.453 4.0 Release
ListOfAttributes nvarchar (255) True No

List of the attributes that were modified or created. This column allows NULL values.

 4.0.106.453 4.0 Release
I3TimeStampGMT datetime False No

System supplied date time when the row was sent to the IC Logging server for insertion into the table.

 4.0.106.453 4.0 Release
SiteId smallint False No

Site identifier of the source of this interaction row. Used in multi-site rollup to distinguish the origin of data.

 4.0.106.453 4.0 Release
SubSiteId smallint False No

Not used in this release. The purpose of this field is to divide use within a site, such as for multiple independent companies on one CIC system. Until CIC has such functionality, this field is zero and is reserved for future use.

 4.0.106.453 4.0 Release


Constraints

Primary Key Name Type Column Name (sort order)
PK_ICDirChangeLog Non-clustered ChangeDateTimeGMT (Ascending)
SiteId (Ascending)
EntryClass (Ascending)
EntryName (Ascending)
NotificationType (Ascending)
EntryPath (Ascending)


Index Name Type Column Name (sort order)
I3TimeStampGMT Clustered I3TimeStampGMT (Ascending)
SiteId (Ascending)
IEChangeTime Non-clustered ChangeDateTime (Ascending)
EntryClass (Ascending)
SiteId (Ascending)
IEEntryName Non-clustered EntryName (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)
IEEntryPath Non-clustered EntryPath (Ascending)
ChangeDateTime (Ascending)
SiteId (Ascending)

LoginLogoutChangeLog_viw view

The LoginLogoutChangeLog_viw view contains timestamp, administrative and client login, and application name data.

Note In the event of switchover, logout will not be tracked as the subsystem to track login and logout is no longer operational. After a switchover, only new logins are logged in the database table.

LoginLogoutChangeLog_viw Schema

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
ApplicationName nvarchar (50) False No

The client Application name, for example, Interaction Client or Interaction Administrator.

 15.2.0.516 Added for storing application login and logout information.
Action smallint False No

The action type, for example, Login or Logout.

 15.2.0.516 Added for storing application login and logout information.
ActionDateTime datetime2 False No

The timestamp when the action happens.

 15.2.0.516 Added for storing application login and logout information.
ActionDateTimeGMT datetime2 False No

The GMT timestamp when the action happens.

 15.2.0.516 Added for storing application login and logout information.
UserId nvarchar (50) True Yes

The userid, who logged in to or logged out from the application.

 15.2.0.516 Added for storing application login and logout information.
Station nvarchar (50) True Depends on customer usage

The station used to log in to or log out from the application.

 15.2.0.516 Added for storing application login and logout information.
ICServer nvarchar (50) True No

The machine or IC server the application logged in to or logged out from.

 15.2.0.516 Added for storing application login and logout information.
SessionManagerInstanceId nvarchar (50) True No

The SessionManager instance Id.

 15.2.0.516 Added for storing application login and logout information.
ErrorDescription nvarchar (50) True No

A descriptive message about the error happening during a login. The values are populated from the ICErrorCodeLookup table that has error codes and error descriptions.

 15.2.0.516 Added for storing application login and logout information.
I3TimeStampGMT datetime False No

Used by the data records purging mechanism.

 15.2.0.516 Added for storing application login and logout information.
SiteId smallint False No

The site identifier.

 15.2.0.516 Added for storing application login and logout information.