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