Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: PFCCWA on October 17, 2023, 04:11:30 PM

Title: Can we access the sql scripts behind an agent bulk import process in GAX?
Post by: PFCCWA on October 17, 2023, 04:11:30 PM

hello

is there a way to locate the sql script that is used when we run GAX bulk import processes?
we are particularly interested in the agent bulk import and database tables it uses during the process.
the reason is we are looking at ways to create a backup should it ever be required (i am presuming there is no out of the box method to reverse a change this like).
thanks,

Title: Re: Can we access the sql scripts behind an agent bulk import process in GAX?
Post by: hsujdik on October 17, 2023, 05:16:31 PM

You can follow it up on Configuration Server logs.

It should update lots of tables depending on what you are setting (agent group, access group, skills, etc)...

I can think about those:

cfg_ace
cfg_flex_prop
cfg_hca_object
cfg_hca_link
cfg_hdb_object
cfg_login_info
cfg_max_dbid
cfg_obj_folder
cfg_person
cfg_role_member
cfg_skill_level
cfg_obj_resource
cfg_group_manager
cfg_agent_group

Anyway, you should not back them up individually... even restoring a backup of Configuration Database by itself could be harmful to other applications, since they may use internal Database IDs assigned by Configuration Server (and are stored on cfg_max_dbid) and once you reverse changes, you will be reaplying those DBIDs to other objects.

I would recommend using some tools that actually take snapshots of the Configuration Layer state and can safely restore a state without messing with DBIDs, like Spotlight or Eemaan.