Genesys Calling List and Table Access Name

Product: Genesys CTI
Version: 5.x and above (worked with 8)
Component: Outbound Contact Server

Following query can be used to join Genesys determine calling list, table access name, and database table name. This is useful to be used for calling list import

MS SQL Server

SELECT L.name AS CallingListName, L.description as CallingListDescription, L.dbid AS CallingListDBID,A.db_table_name AS TableName  from [Config].[dbo].[cfg_calling_list] AS L, [Config].[dbo].[cfg_table_access] AS A WHERE L.tabl_acc_dbid = A.dbid

Oracle

SELECT L.name AS CallingListName, L.description as CallingListDescription, L.dbid AS CallingListDBID,A.db_table_name AS TableName  from cfg_calling_list AS L, cfg_table_access AS A WHERE L.tabl_acc_dbid = A.dbid