Buy or Renew
Buy or Renew
Cisco + Splunk: It’s a new day for your data. Learn more.
 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
411
Views
0
Helpful
3
Replies

Master Script Database UCC Enterprise

lmrscheff
Level 1
Level 1

‎06-01-2009 08:09 AM - edited ‎03-14-2019 04:09 AM

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

Labels:
0 Helpful
3 Replies 3

geoff
Level 10
Level 10

‎06-01-2009 12:13 PM

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

0 Helpful

samuel.barnhouse
Level 1
Level 1

‎06-04-2009 02:50 PM

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

0 Helpful

lmrscheff
Level 1
Level 1
In response to samuel.barnhouse

‎06-05-2009 04:14 AM

Thanks

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

0 Helpful
Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Customers Also Viewed These Support Documents