sql query to find out when was the skillgroup created

[anusuya984]

Doees anyone know the field which points to the date time when a skillgorup created?I have refered to the schema document-but most dbtime usually points to The current date and time stamp when the records are written to the DBDATETIME’,’ Date and time the agent logged into the skill group,etc.

[david.macias]

This is a strange request and can't think of what field to look for.  Perhaps a way to discern this is to check the first time a call hit this SG?  Or maybe the time stamp of the first ICM script which utilized your SG.

david

[Jameson Gagnepain]

Looking at the first time a call was offered against the skill group, or looking at the time stamp of the first ICM script to reference the SG sound like the best options... but still leave a lot of room for error. They basically give you a "created no later than" date. If your ICM is set to automatically keep only a certain number of script versions, you lose history of skill group creation date after a few new script version saves. Call data has a retention period depending on your setup as well.

One more date you can look at is the earliest schedule on the Call Type. This will have the longest-held dates, but of course this won't give you anything for call types which you only reference within scripts, and will miss data for any schedules you've previously removed from Call Types. (I typically only schedule Call Types that are assigned to DNs, and use Go To Script nodes for script-to-script movement instead of Requalify Call for ease of viewing call flows)

Why do you need to see when Call Types were created?

-Jameson