How to find object path in Configserver Database

[Zacharie]

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

[Kubig]

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

[victor]

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.