Config manager odbc?

[DarkAngel]

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.

[ecki]

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.

[DarkAngel]

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

[ecki]

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

[DarkAngel]

MS Access, using odbc connection

[cavagnaro]

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]

[ecki]

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

[ecki]

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

Cheers,

e.

[cavagnaro]

hehe yeah anyway he has two flavors now 

[tony]

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

[ecki]

Right! Where is this warning from?

[tony]

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

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

[cavagnaro]

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.