public.vwlicensecountsbytype

public.vwlicensecountsbytype

Description

Assignment interval counts per license name

Table Definition 
CREATE VIEW vwlicensecountsbytype AS (
 SELECT l.licensename,
    l.licensetype,
    count(DISTINCT l.userid) AS totalusers,
    sum(
        CASE
            WHEN (l.licenseactive = true) THEN 1
            ELSE 0
        END) AS activelicenses,
    sum(
        CASE
            WHEN (l.licenseactive = false) THEN 1
            ELSE 0
        END) AS inactivelicenses,
    sum(
        CASE
            WHEN (l.copilotlicense = true) THEN 1
            ELSE 0
        END) AS copilotlicenses,
    min(l.licenseassignmentdate) AS earliestassignment,
    max(l.licenseassignmentdate) AS latestassignment,
    max(l.updated) AS lastupdated
   FROM subuserlicensedata l
  WHERE (l.licensename IS NOT NULL)
  GROUP BY l.licensename, l.licensetype
)

Columns

Name Type Default Nullable Children Parents Comment
licensename varchar(100) true License Name
licensetype varchar(100) true
totalusers bigint true Distinct users that held this license at any time in the history
activelicenses bigint true Open intervals: users currently holding the license
inactivelicenses bigint true Closed intervals in the history
copilotlicenses bigint true Intervals, open or closed, of a Copilot license
earliestassignment timestamp without time zone true
latestassignment timestamp without time zone true
lastupdated timestamp without time zone true

Referenced Tables

Name Columns Comment Type
public.subuserlicensedata 13 License assignment history from Genesys Cloud: one row per Assignment interval, open or closed. User attributes are copied from userdetails when a row is written. 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 ...