Question on Config DB

[genesysnoob]

I always wondered Where do Config Db saves connections and other attributes related to the Application object.

In Detail, If we add a object like a person in the CME, i see a table for person in the config DB and all the details about a person are present. By running a simple query any one can get those details. When it comes to agentinfo tab details, where do i find those values, example, an agent login will be associated to agent.

Same goes with Host object, i was able to find the host table and ran a query and i got all the host machines. But how do i find what apps are installed on the hosts?

I would like to know any chance we can find out thru Config DB?

[Kubig]

Yes, of course you can find out these information within CFG database. All what you can see within CME, is saved within database.

[cavagnaro]

Hehe his question was more the "where" rater than "if"
I have no idea, no need so far to dig it on Cfg DB, usually get it via PSDK

[Kubig]

I know - just joke )

From my point of view, that is thing which can be easily founded by yourself.

[mduran22]

I have found it handy to run some queries in SQL vs using config manager. For example we have information on the annex tab for every single agent, so it is a bit of a pain to go through them one by one and check the annex tab (i.e. does it have the info, is it correct, etc) and a query allows that process to be expedited.

There are lots of joins throughout the database that you need to do on two or more tables sometimes to get the results you mentioned above. There is also enumerations in the locale table for different objects to turn an integer into a word.

Genesys does not support direct access into the config database so there is no formal documentation on it. As Cav mentioned the config SDK can be used and there is some documentation on that gives some insight to the objects and tables. Other then that you just have to go through each table an piece it together if you have the time and the patients.

[Adam G]

You can "Read" the cfg db tables, without penalty.  You cannot "Write" to them directly (without PSDK, etc.) without invalidating warranty of their stability.

To get the Agent Login Code of an Agent:

1. JOIN [i]cfg_person.dbid[/i] -to- [i] cfg_login_info.person_dbid[/i]
2. JOIN [i] cfg_login_info.agent_login_dbid [/i] -to- [i]cfg_agent_login.dbid[/i]

Select the "Person" details you need and include [i]cfg_agent_login.login_code[/i] in your Select/Results.

Additionally;

3. JOIN [i]cfg_agent_login.switch_dbid[/i] -to- [i]cfg_switch.dbid[/i] and include [i]cfg_switch.name[/i] in your results, to enable you to select a particular (Switch) Name.

HTH?

[Adam G]

Part II: Hosts/Applications:

1. JOIN [i]cfg_application.dbid[/i] -to- [i]cfg_server.app_dbid[/i]
2. JOIN [i]cfg_server.host_dbid[/i] -to- [i]cfg_host.dbid[/i]

Select from [i]cfg_application.name[/i] and include [i]cfg_host.name[/i] in your Results

HTH?