Expand All Collapse All
Directory Services Change Log

ICDirChangeLog Table

Directory Services Change Log

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.

  • Table Type - Historical
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL 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

SQL 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)