public.vwrealtimemonitorqueueobsmedia

public.vwrealtimemonitorqueueobsmedia

Description

Table Definition 
CREATE VIEW vwrealtimemonitorqueueobsmedia AS (
 SELECT replace((realtimeadaptermonitordata.keyid)::text, 'QueueObsService:media:'::text, ''::text) AS media,
    realtimeadaptermonitordata.servicename,
    realtimeadaptermonitordata.status,
    realtimeadaptermonitordata.isrunning,
    realtimeadaptermonitordata.eventsprocessed,
    realtimeadaptermonitordata.errorcount,
    realtimeadaptermonitordata.activeconnections,
    realtimeadaptermonitordata.totalwebsockets,
    realtimeadaptermonitordata.activeconversations,
    realtimeadaptermonitordata.staleconversationcount,
    realtimeadaptermonitordata.oldeststaleconversationageseconds,
    ((realtimeadaptermonitordata.oldeststaleconversationageseconds)::numeric / 60.0) AS oldeststaleconversationageminutes,
    realtimeadaptermonitordata.healthpercentage,
    realtimeadaptermonitordata.acwpendingcount,
    realtimeadaptermonitordata.staleacwcount,
    realtimeadaptermonitordata.lastactivityutc,
    realtimeadaptermonitordata.lastconversationnotificationutc,
    realtimeadaptermonitordata.lastconversationhealthcheckutc,
    realtimeadaptermonitordata.lastconversationverifiedactiveutc,
    realtimeadaptermonitordata.updated,
        CASE
            WHEN (realtimeadaptermonitordata.updated IS NULL) THEN NULL::integer
            ELSE GREATEST(0, (floor(EXTRACT(epoch FROM (timezone('utc'::text, now()) - realtimeadaptermonitordata.updated))))::integer)
        END AS monitorrowageseconds,
    (realtimeadaptermonitordata.staleconversationcount > 0) AS hasstaleconversations,
    realtimeadaptermonitordata.notes
   FROM realtimeadaptermonitordata
  WHERE ((realtimeadaptermonitordata.keyid)::text ~~ 'QueueObsService:media:%'::text)
)

Columns

Name Type Default Nullable Children Parents Comment
media text true
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
oldeststaleconversationageminutes numeric 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
monitorrowageseconds integer true
hasstaleconversations boolean true
notes varchar(400) true

Referenced Tables

Name Columns Comment Type
timezone 0
public.realtimeadaptermonitordata 20 BASE TABLE

    • Related Articles

    • 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 ...

    • public.participantattributesdynamic

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true conversationenddate ...

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

    • public.userinteractionpresencedetaileddata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone true endtimeltc ...