config db table

[elwan]

hi all,
would someone tell me where i could find a list of config db tables? i need to pull out agent skills, agent groups, virtual queues, switches.
thanks a lot...

[ecki]

Hi,

The best way would be to have look in to configuration database and check the contents of each table you will find. Then try to figure out how the tables are connected together.
It is actually pretty simple and obvious. Even some config table names are intuitive. Just check it with SME and you will see.  Just small hint for skills information : cfg_skill -> cfg_skill_level -> cfg_person

e.

[René]

Hi elwan,

I have some experience with modification of config db directly and have to say one thing - be very careful. The database seems to be quite simple but there is lot of "hidden" relation between the tables. Breaking these relation could lead to database corruption which is a fatal (config server won't start) especially when using Configuration Server 6.5.

I suggest you to forget direct config db modification and use some of available Configuration SDK. Especially you get one important "benefit" - no need to restart configuration server after making changes. You have to do it when modifying config db directly to see the changes in CME.

R.

[mark]

Are you looking to modify or just see what is where?
Im sure that if you want to view only, you could use Hyperion / Brio to run reports for you. I currently have a built report that tells me all the routepoint 'Options' configuration which is valuable to me, but something similar could be achieved for yourself I would imagine.

[elwan]

[quote author=ecki link=topic=2052.msg7052#msg7052 date=1171434936]
Hi,

The best way would be to have look in to configuration database and check the contents of each table you will find. Then try to figure out how the tables are connected together.
It is actually pretty simple and obvious. Even some config table names are intuitive. Just check it with SME and you will see.  Just small hint for skills information : cfg_skill -> cfg_skill_level -> cfg_person

e.
[/quote]

Hi ecki,
The thing is I don't have access to the configuration database, so I can't have a good look at the tables. The reason I'm asking for the list is that our database guys wan't me to give him a list of tables I need so that he could give me access to those tables. Maybe you could give me a list in here. I won't be modifying the data, just for reporting. I don't also have access to Hyperion as well. Can I use the Configuration SDK to pull out data as well?

Thanks.

[tony]

Echoing comments already made here;

I would advise that you read up on the types of interfaces available to access cfg tables in the cfg database or contact your Genesys support representative before you start pulling data from the cfg tables without using a recognized and acceptable means to do so...

One way you could achieve this without affecting cfg itself is to have your DBA's make regular copies (say - every 15 minutes) of the cfg tables you need and you work from the copy - not the actual operational cfg tables....

I would also strongly suggest you read up on the Genesys Config SDK before you take any advice relating to it's use.  Don't forget that we would not be responsible if whatever you attempt invalidates your environment...

You may find the Stat SDK or even GIS useful for pulling off User data but they are both primarily for reporting use.

Tony

[ecki]

Yes, definitely I agree with everyone here who replied. I forgot to warn elwan to be really careful with CFG database. But he mentioned that he wants to pull out the data.

Elwan:
Using Configuration SDK(Software Development Kit) is the recommended way. Although I have no experiences with it, I am convinced that you will get everything you mentioned and it would be absolutely safe and appropriate way how to access or modify the Genesys configurations data.

In the case you want to continue with idea to read directly the cfg data from cfg tables, then the idea from Tony with doing the backup copy of the cfg database on daily base is really the best precaution how to secure you won’t harm your production at all. However you won’t have the up-to-date configuration status of your CC.
Another way would be to let your db guys create for you new db account with read only access permissions to production cfg tables you need.

To the list of cfg tables, I could find somewhere the cfg database initialization script and extract the table names from there, but there is easier way. Just tell your db department to make available for you all tables, which begins with prefix "cfg_". Do not forget that you MUST have read only access to those tables!!!


Be careful! 

Cheers,

e.