UCCE Skill Group ID's

[Horacio Gutierrez]

Hello,

Can anyone tell me where on the UCCE AW server I can find the Skill Group ID's.  Our Knoahsoft recording tech is asking to give the him the names and skill group ID's so he can use those to configure them on the Knoahsoft recording server.  We have UCCE CVP version 8.0 and we are using CTIOS. Any Suggestions?

Thanks,

[Slavik Bialik]

If you're not talking about the peripheral ID of the skill group, but about the skill group target ID so the only way to get it (the only way I know) is through the database.

Just go into the database (awdb) -> Views -> Skill_Group

And you'll see that for each skill group there's a column named "SkillTargetID".

[Horacio Gutierrez]

Can you please tell what table in the awdb database has the SkillTargeID and the sql command you run to see them?

[Slavik Bialik]

Yep,
SELECT * FROM [<instance_name>_awdb].[dbo].[Skill_Group]