Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Master Script Database UCC Enterprise

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

3 REPLIES
Green

Re: Master Script Database UCC Enterprise

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

New Member

Re: Master Script Database UCC Enterprise

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

New Member

Re: Master Script Database UCC Enterprise

Thanks

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

147
Views
0
Helpful
3
Replies