Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: DarkAngel on April 08, 2009, 03:45:34 PM

Title: Config manager odbc?
Post by: DarkAngel on April 08, 2009, 03:45:34 PM

Hello all

I've been tasked with pulling a report of all agents who have particular skills, and then looking to see which have these skills exclusively, and which have these skills and others.

I was hoping to do this with MS Access, via odbc connection, but our reporting team do not think it's possible, and apparently the people at Genesys do not either.

Is anyone aware of any way of doing this, other than going through every agent individually and writing down their skills?

Thanks a lot,

D.A.

Title: Re: Config manager odbc?
Post by: ecki on April 08, 2009, 09:38:06 PM

Hi,

From which database do you want to pull this information from?  From Configuration database or CCA Datamart? And what do you mean doing it otherwise than going through every agent individually? What would be your preferable method?

Cheers,

ecki.

Title: Re: Config manager odbc?
Post by: DarkAngel on April 09, 2009, 06:58:59 AM

Hi

I assume it would be the config database, so we can pull details of agents with skills?

I meant my last resort would be opening each agent individually, and taking note of their skills, which is not something i want to do.

DA

Title: Re: Config manager odbc?
Post by: ecki on April 09, 2009, 07:12:57 AM

;D you mean via Config manager? Yep, that would be tedious.
What do you need this for? What database you have? Oracle/mssql?

Title: Re: Config manager odbc?
Post by: DarkAngel on April 09, 2009, 07:27:09 AM

MS Access, using odbc connection

Title: Re: Config manager odbc?
Post by: cavagnaro on April 09, 2009, 07:33:52 AM

check the cfg_person table in your Genesys Database and then associate with cfg_skill and cfg_skill level

[quote]
select b.first_name as Name, b.last_name as LastName, c.name as Skill, a.level_ as Level
from cfg_skill_level as a
inner join cfg_person as b on b.dbid = a.person_dbid
inner join cfg_skill as c on c.dbid = a.skill_dbid
order by LastName
[/quote]

Title: Re: Config manager odbc?
Post by: ecki on April 09, 2009, 07:45:11 AM

Try this

SELECT a.last_name, a.first_name, a.user_name, a.employee_id,d.skill_name,d.skill_level
FROM cfg_person a LEFT OUTER JOIN
      (SELECT c.person_dbid, b.name as [skill_name], c.level_ as [skill_level]
      FROM  cfg_skill b, cfg_skill_level c
      WHERE c.skill_dbid = b.dbid) d ON a.dbid = d.person_dbid
ORDER BY a.user_name

Title: Re: Config manager odbc?
Post by: ecki on April 09, 2009, 07:50:45 AM

Hi Cav... you were faster this time !!!  ;D
But my query should get also agents/non agents who does not have any skill  :P

Cheers,

e.

Title: Re: Config manager odbc?
Post by: cavagnaro on April 09, 2009, 09:32:07 AM

hehe yeah anyway he has two flavors now  ;D

Title: Re: Config manager odbc?
Post by: tony on April 09, 2009, 12:06:15 PM

Guys - I'm surprised you didn't do this...


[color=red] [b]***WARNING****[/b]

Genesys recommend using CME as the GUI and only their SDK's for access to the Config Layer/Tables/Database.  Using any other form of access to the Configuration Tables (even for [i]RO[/i] Accounts) can adverlsey affect your environment and can also invalidate your support agreements with Genesys.

[b]***WARNING****[/b] [/color]

I would be more inclined not to use MSAccess and ODBC and instead use the Configuration SDK...

Tony

Title: Re: Config manager odbc?
Post by: ecki on April 09, 2009, 12:30:15 PM

Right! Where is this warning from?

Title: Re: Config manager odbc?
Post by: tony on April 09, 2009, 01:54:56 PM

A long time ago, in a galaxy far away...

http://www.sggu.com/smf/index.php/topic,1270.0.html

Title: Re: Config manager odbc?
Post by: cavagnaro on April 09, 2009, 04:05:13 PM

Yes, so true, sorry. Forgot to make the quotation. However if he is only reading not making modifications, so I would guess it is safe and will be smart enought to create a once shot and not be reading 100 times per minute.