Genesys CTI User Forum > Genesys-related Development

retreive skill usage

(1/2) > >>

DANIEL.DOUSSET:
Hi,

I'm trying to developp a program to find whose person use a skill  and the level. 

I scan all person and skill but it's very long. So,  I would like to do as CME with the Dependency TAB of a specific Skill. It is possible ?

I developp whith PSDK 8.5 java.

Thank you

cavagnaro:
Maybe do that Query and check on CfgServer logs what it requests exactly, you will see the Event and XML interpretation.
Then replicate via PSDK
However there you still will need to scan evey single agent on the platform...same thing you are doing now

hsujdik:
Does it have to be retrieved through PSDK, or can you connect to the Config Database? Because if you can, it is way faster to retrieve something like:

select
p.dbid as person_dbid,
p.employee_id,
p.user_name,
s.dbid as skill_dbid,
s.name as skill_name,
sl.level_ as skill_level
from cfg_person p
inner join cfg_skill_level sl on sl.person_dbid = p.dbid
inner join cfg_skill s on s.dbid = sl.skill_dbid
where
s.name = 'SKILL_NAME_TO_VERIFY'

Janis:
Looks like we can do this (replace 106 with the dbid of your skill):

[code]CfgXPathBasedQuery query = new CfgXPathBasedQuery(confService, CfgObjectType.CFGPerson, "CfgPerson[skillLevels/*/@linkDBID = 106]");
ICollection<CfgPerson> persons = confService.RetrieveMultipleObjects<CfgPerson>(query);[/code]


"CfgPerson[skillLevels/*/@linkDBID = 106]" - found in confserv log after checking dependency for the skill in the CME. Don't know details of it.

Janis:
https://stackoverflow.com/questions/45067040/use-iconfservice-to-query-object-by-attributes

Navigation

[0] Message Index

[#] Next page