Master Script Database UCC Enterprise

Unanswered Question
Jun 1st, 2009

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

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
samuel.barnhouse Thu, 06/04/2009 - 14:50

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 Fri, 06/05/2009 - 04:14

Thanks

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

Actions

This Discussion