License Reporting Schema

In InProd, you can directly access the database tables that contain the license reporting usage data. However, you must configure the PostgreSQL database to accept the external connection. By default, the external connections are disabled.

Each entry in the table is either for a system defined Genesys license or a user defined Custom license.

Note:

In the tables list, the table bison_gentenant and bison_environment have been truncated to contain only the relevant fields.

Field	Type	Description
id	integer	PK ID.
tenant_dbid	integer	Tenant Db id.
start_time	timestamp	The timestamp for when the data collection process started.
license	character varying(100)	Base Genesys licenses that are internally defined.
usage	integer	Usage count for the license.
enabled	boolean	The value indicating whether the license is reported as ‘Enabled‘ or ‘Disabled‘ for usage.
custom_license_id	integer	PK Id for custom license definition, if relevant.
env_id	integer	PK Id for the environment.
grouping_id	integer	PK Id for Business Unit definition, if relevant.

Field	Type	Description
id	integer	PK Id
name	character varying(30)	Object name
Description	character varying(150)	Description of the object
tenant_dbid	integer	Tenant Database Id.
env_id	integer	PK Id for the environment

Field	Type	Description
id	integer	PK Id
name	character varying(30)	Object name
Description	character varying(150)	Description of the object
tenant_dbid	integer	Tenant Database Id.
env_id	integer	PK Id for the environment

Field	Type	Description
id	integer	PK Id
name	character varying(30)	Object name
dbid	integer	Database Id for this object
env_id	integer	PK Id for the environment

Field	Type	Description
id	integer	PK Id
name	character varying(255)	Object name