McDewey

Multi-vendor documentation library · semantic search · MCP endpoint at /mcp

Page 303

↗ View in doc context
page
303
source
ucce/v15.0.1/db-schema-handbook/db-schema-handbook.md
chunk_id
ucce::v15.0.1::db-schema-handbook::db-schema-handbook::289

Logger_Admin This table is in the System category (see System, on page 649). To see database rules for these tables, see System Tables, on page 703. It gets populated on central and HDS databases. This table contains one record of information for each administrative task the system software applies to the central database. Specifically, this table tracks Purges and Update Statistics operations. These operations are run automatically as scheduled jobs. Scheduled SQL jobs carry out the purge of the following tables, so the Logger_Admin table does not contain the entries for these tables: • Call_Event_Detail • Route_Call_Variable • Dialer_Detail • Call_Type_SG_Interval • Route_Call_Detail • Termination_Call_Variable • Agent_Event_Detail • Termination_Call_Detail • Network_Event_Detail • Agent_Skill_Group_Interval Table 227: Indexes for Logger_Admin Table index_keys index_description index_name RecoveryKey Nonclustered, unique, unique key located on PRIMARY XAK1Logger_Admin TableName, ScheduledAt, FunctionName Nonclustered located on PRIMARY XIE1Logger_Admin DateTime Nonclustered located on PRIMARY XIE2Logger_Admin RecoveryKey Clustered, unique, primary key located on PRIMARY XPKLogger_Admin Table 228: Fields in Logger_Admin Table Keys and NULL Option Data Type Description Name IE-2 NOT NULL DBDATETIME The date and time at which the scheduled job was submitted. DateTime Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 285 All Tables Logger_Admin