McDewey

ContactRoutingDetail , on page 46 ContactServiceQueue , on page 47 MonitoredResourceDetail, on page 73 RmonUser , on page 86 Resource Database table name: Resource The Unified CCX system creates a new record in the Resource table when the Unified CCX system retrieves agent information from the Unified CM. A Resource record contains information about the resource (agent). One such record exists for each active and inactive resource. When a resource is deleted, the old record is flagged as inactive; when a resource is updated, a new record is created and the old one is flagged as inactive. Table 56: Resource Table Fields Storage Description Field Name int NOT NULL Primary Key Numeric identifier of the resource. resourceID int NOT NULL Primary Key Identifier of the Unified CCX profile that is associated with this record. profileID nvarchar(128,0) NOT NULL The login name assigned to the resource in the Unified CM. resourceLoginID nvarchar(50,0) NOT NULL The first name and the last name of the resource. resourceName int NULL Resource group to which the resource belongs. Null if no resource group is assigned to the resource. resourceGroupID smallint NOT NULL Type of the resource: 1—Agent 2—Supervisor 3—Administrator resourceType Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 81 Database Schema Resource