Query is showing all skills and agent ever had??

[Scottyjohn]

Hi all,
I have an SQL query which I run on the config DB using the config person, skill, and skill level tables to show an agent's current skills.  A friend at a different company is reporting that when he runs the same query, its showing all the skills the agent ever had?  Can anyone suggest why this is happening, and if there is any way to query just their current skills?

[S]

Interesting!! Never seen that happen before... I pull from Cfg db tables like you said... and always get the current skills - not the previous added skills ... unless your friend is searching in another DB too, which is backup to current cfg DB and storing the old skills of the advisor...

S

[barleycorn]

It could also be an incorrect join on the SQL and it may be showing each agent with all skills... What is the query?

[barleycorn]

I just tried this on my small test system (12 agents, 1 without any skills):

select p.user_name, s.name, s.level_
from cfg_person p, cfg_skill_level l, cfg_skill s
where l.person_dbid = p.dbid
and l.skill_dbid = s.dbid
order by p.user_name, s.name

and it seemed fine. Each of these agents has had differing skills at one point or another.

[JGMG]

Could you get the query they are using? Config Server is current configuration only, unless you are using the HCA journal mode.(A special mode required for GIM 7.2)

[barleycorn]

Yes, but to use any of the HCA stuff you'd have to link in cfg_hca_link and cfg_hca_object. These tables aren't particularly self-explanatory, and would require some fairly complicated joins to get meaningful results.

[kowari]

They also aren't that hard to do... if he were hitting the HCA_Object table, that is jsut a big fat list of historical changes... that would do exactly what he says (and get a list of this history of skills)

[tony]

Does he have WfM installed..?