retreive skill usage

[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

[DANIEL.DOUSSET]

Thank you for the solution.

I use the JANIS Code. It's perfect. I win lot's of time Thank you. Now i think i go to look in the configserver log.  I allaways try to look but i doesnt know how to you that in my code. Now i know.

GOODDDDD