Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Zacharie on June 14, 2018, 01:57:45 PM

Title: How to find object path in Configserver Database
Post by: Zacharie on June 14, 2018, 01:57:45 PM

Hi,

Like Configuration manager, when you look for an object I would like to know if we can find object path with an SQL query?

Regards

Title: Re: How to find object path in Configserver Database
Post by: Kubig on June 14, 2018, 02:45:23 PM

Of course you can find all information and object within CFG database. Try to check this threat where some useful queries are mentioned - http://www.sggu.com/smf/index.php/topic,9136.msg41059.html#msg41059

Title: Re: How to find object path in Configserver Database
Post by: victor on June 20, 2018, 09:03:20 PM

What Kubig said but there are quite a few posts detailing this:

SELECT
  CFG_PERSON.USER_NAME,
  CFG_PERSON.EMPLOYEE_ID,
  CFG_AGENT_LOGIN.LOGIN_CODE
FROM CFG_PERSON
INNER JOIN CFG_LOGIN_INFO
ON CFG_PERSON.DBID = CFG_LOGIN_INFO.PERSON_DBID
INNER JOIN CFG_AGENT_LOGIN
ON CFG_LOGIN_INFO.AGENT_LOGIN_DBID = CFG_AGENT_LOGIN.DBID
ORDER BY CFG_PERSON.EMLOYEE_ID

is a good start. Just look at DB schema - it is pretty straight-forward.