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:
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_;
I hope this helps some of you out of a “Hole” dug by earlier versions of Genesys.
Tony