I have lots of AWDB queries to produce the data joins useful for documentation of the "as is" state - agent team membership, agent skill group membership, call type-dn associations etc.

Haven't done exactly what you want, but it's pretty easy if you know SQL.

Here is an example of a query to get the dialed number - call type association. My peripheral ID is 5000, but season to suit. ;-)

select DialedNumberString AS DN, c.EnterpriseName AS CallType, d.Description AS DN_Descr

from t_Dialed_Number_Map m, t_Call_Type c, t_Dialed_Number d

where m.CallTypeID = c.CallTypeID

and m.DialedNumberID = d.DialedNumberID

and d.RoutingClientID = 5000

order by DialedNumberString

Your query would be a good one for me. I'll have a look at it and get back here.

Regards,

Geoff

Try this. Again, 5000 on my routing client.

select DialedNumberString AS DN, d.Description AS DN_Description, c.EnterpriseName AS CallType,

ms.EnterpriseName as ScriptName

from t_Dialed_Number_Map m, t_Call_Type c, t_Dialed_Number d, Call_Type_Map ctm, t_Master_Script ms

where ctm.Item = 0

and m.CallTypeID = c.CallTypeID

and c.CallTypeID = ctm.CallTypeID

and m.DialedNumberID = d.DialedNumberID

and ms.MasterScriptID = ctm.MasterScriptID

and d.RoutingClientID = 5000

order by DN

Regards,

Geoff

Hi Geoff

Thanks for the query.Worked like a charm for me and saved lot off of my time.

Good stuff - you are welcome.

Regards,

Geoff