public.realtimeadaptermonitordata
Columns
| keyid |
varchar(100) |
|
false |
|
|
|
| servicename |
varchar(100) |
|
true |
|
|
|
| status |
varchar(50) |
|
true |
|
|
|
| isrunning |
boolean |
|
true |
|
|
|
| eventsprocessed |
bigint |
|
true |
|
|
|
| errorcount |
bigint |
|
true |
|
|
|
| activeconnections |
integer |
|
true |
|
|
|
| totalwebsockets |
integer |
|
true |
|
|
|
| activeconversations |
integer |
|
true |
|
|
|
| staleconversationcount |
integer |
|
true |
|
|
|
| oldeststaleconversationageseconds |
integer |
|
true |
|
|
|
| healthpercentage |
numeric(5,2) |
|
true |
|
|
|
| acwpendingcount |
integer |
|
true |
|
|
|
| staleacwcount |
integer |
|
true |
|
|
|
| lastactivityutc |
timestamp without time zone |
|
true |
|
|
|
| lastconversationnotificationutc |
timestamp without time zone |
|
true |
|
|
|
| lastconversationhealthcheckutc |
timestamp without time zone |
|
true |
|
|
|
| lastconversationverifiedactiveutc |
timestamp without time zone |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
| notes |
varchar(400) |
|
true |
|
|
|
Constraints
| realtimeadaptermonitordata_key |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| realtimeadaptermonitordata_key |
CREATE UNIQUE INDEX realtimeadaptermonitordata_key ON
public.realtimeadaptermonitordata USING btree (keyid) |
Related Articles
public.vwrealtimemonitorqueueobsmedia
Description Table Definition CREATE VIEW vwrealtimemonitorqueueobsmedia AS ( SELECT replace((realtimeadaptermonitordata.keyid)::text, 'QueueObsService:media:'::text, ''::text) AS media, realtimeadaptermonitordata.servicename, ...
public.vwrealtimemonitorservicehealth
Description Table Definition CREATE VIEW vwrealtimemonitorservicehealth AS ( WITH service_rows AS ( SELECT realtimeadaptermonitordata.keyid, realtimeadaptermonitordata.servicename, realtimeadaptermonitordata.status, ...
public.vwrealtimemonitoroverview
Description Table Definition CREATE VIEW vwrealtimemonitoroverview AS ( WITH service_rows AS ( SELECT realtimeadaptermonitordata.keyid, realtimeadaptermonitordata.servicename, realtimeadaptermonitordata.status, realtimeadaptermonitordata.isrunning, ...
README
Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...
public.evalquestiondata
Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true score ...