Here is something else I penned a while back but never published. Not sure it is relevant with the new CME interfaces out there but may be of use to older versions.
***Running scripts against your CME dB is not big nor is it clever. Do this at your own risk***
If you have Admin access to the CME dB tables, run this against them and enter the criteria, to pick out Agents with those Skills:
[size=8pt]SELECT dbo_cfg_person.employee_id AS [Extension(s)], dbo_cfg_person.user_name AS CDSID, dbo_cfg_person.first_name AS Forename, dbo_cfg_person.last_name AS Surname, dbo_cfg_skill.name AS [Skill Name], dbo_cfg_skill.dbid AS [Skill ID Number], dbo_cfg_skill_level.level_ AS [Skill Level]
FROM (dbo_cfg_person INNER JOIN dbo_cfg_skill_level ON dbo_cfg_person.dbid = dbo_cfg_skill_level.person_dbid) INNER JOIN dbo_cfg_skill ON dbo_cfg_skill_level.skill_dbid = dbo_cfg_skill.dbid
WHERE (((dbo_cfg_person.employee_id) Like "*" & [Enter Search criteria or press ENTER] & "*")) OR (((dbo_cfg_person.user_name) Like "*" & [Enter Search criteria or press ENTER] & "*")) OR (((dbo_cfg_person.first_name) Like "*" & [Enter Search criteria or press ENTER] & "*")) OR (((dbo_cfg_person.last_name) Like "*" & [Enter Search criteria or press ENTER] & "*")) OR (((dbo_cfg_skill.name) Like "*" & [Enter Search criteria or press ENTER] & "*")) OR (((dbo_cfg_skill_level.level_) Like "*" & [Enter Search criteria or press ENTER] & "*"))
ORDER BY dbo_cfg_skill.name, dbo_cfg_skill_level.level_;[/size]
I hope this helps some of you out of a "Hole" dug by earlier versions of Genesys.
Tony
