Master Script Database UCC Enterprise

[lmrscheff]

I need to do a count of all the scripts Call Routing, Administrative, and Queuing scripts. How and where can I obtain that information.

thanks

[geoff]

I think you are on the right track. Do a count (*) on the Master_Script table where Deleted = 0. That should give you both the routing and admin scripts. Admin and routing scripts are defined by the value of ScriptType (DBSMALLINT).

Look at the Schema Guide.

Regards,

Geoff

[samuel.barnhouse]

Try this SQL against an AW SQL database:

SELECT

CASE

WHEN ScriptType = 1 THEN 'Routing Script'

WHEN ScriptType = 2 THEN 'Admin Script'

ELSE 'Unknown'

END AS [Type],

COUNT(MasterScriptID) AS [Count]

FROM Master_Script

GROUP BY ScriptType

[lmrscheff]

Thanks

I was able to get this out using a statement that pulled everything.