05-24-2018 07:32 AM - edited 03-14-2019 06:12 PM
Trying to find out if theres a way to see how much of the allocated memory each variable is actually using. Problem is I'm coming into an environment where I do not know exactly what each one is being used for and we are running low on memory available.
Solved! Go to Solution.
05-24-2018 09:44 PM - edited 05-24-2018 09:47 PM
For non Arrays, you can use this query:
SELECT SUM(LEN(EnterpriseName)+ MaximumLength + 4) AS Bytes_Consumed, EnterpriseName
FROM Expanded_Call_Variable
WHERE EnterpriseName = 'BACampaign'
GROUP BY EnterpriseName
For Arrays, you can use this query:
SELECT SUM(MaximumArraySize *(LEN(EnterpriseName) + MaximumLength +5)) AS Bytes_Consumed, EnterpriseName
FROM Expanded_Call_Variable
WHERE EnterpriseName = 'user.microapp.ToExtVXML'
GROUP BY EnterpriseName
for total, you can use this query:
SELECT SUM(bytes) AS Bytes_Consumed FROM(SELECT SUM(LEN(EnterpriseName)+ MaximumLength + 4) AS bytes FROM Expanded_Call_Variable WHERE ECCArray = 'N' and Enabled = 'Y' UNION ALL SELECT SUM(MaximumArraySize *(LEN(EnterpriseName) + MaximumLength +5)) AS bytes FROM Expanded_Call_Variable WHERE ECCArray = 'Y' and Enabled = 'Y') AS ECCTable
Swap out the EntepriseName value with the ECC variable of your choise or use the IN operator to fit more ECC variables into the query. Run these queries against the logger database
05-24-2018 09:44 PM - edited 05-24-2018 09:47 PM
For non Arrays, you can use this query:
SELECT SUM(LEN(EnterpriseName)+ MaximumLength + 4) AS Bytes_Consumed, EnterpriseName
FROM Expanded_Call_Variable
WHERE EnterpriseName = 'BACampaign'
GROUP BY EnterpriseName
For Arrays, you can use this query:
SELECT SUM(MaximumArraySize *(LEN(EnterpriseName) + MaximumLength +5)) AS Bytes_Consumed, EnterpriseName
FROM Expanded_Call_Variable
WHERE EnterpriseName = 'user.microapp.ToExtVXML'
GROUP BY EnterpriseName
for total, you can use this query:
SELECT SUM(bytes) AS Bytes_Consumed FROM(SELECT SUM(LEN(EnterpriseName)+ MaximumLength + 4) AS bytes FROM Expanded_Call_Variable WHERE ECCArray = 'N' and Enabled = 'Y' UNION ALL SELECT SUM(MaximumArraySize *(LEN(EnterpriseName) + MaximumLength +5)) AS bytes FROM Expanded_Call_Variable WHERE ECCArray = 'Y' and Enabled = 'Y') AS ECCTable
Swap out the EntepriseName value with the ECC variable of your choise or use the IN operator to fit more ECC variables into the query. Run these queries against the logger database
05-25-2018 04:56 AM
Hi @Omar Deen,
Are you totally sure about this query (at least the last one)?
Because I tried to run on my system, and I got 2085 as an output. But as much as I understand from the documentation, the maximum size permitted is 2000 bytes. no?
05-25-2018 05:56 AM - edited 05-25-2018 05:56 AM
Yes, I'm sure
The maximum total ECC payload size is 2000 bytes
The maximum total payload AND name size for ECC variables is 2500 bytes.
To give you a real world example, I ran the query in a PCCE 11.6 production environment, and the results matched what's in CCE Admin
06-26-2019 06:00 AM
Hi Everyone,
I am new to cisco Ucce.
1.we have 27 ECE variables, right?
2. can anyone explain, what is the purpose of we are using ECE variables?
3.what is the major difference ECE variables and user variables?
06-26-2019 11:43 AM
Are you referring to ECC variables or ECE variables, from what you wrote I'm guessing ECC, in which case you might want to start a new topic to avoid confusion.
06-26-2019 07:47 PM
06-26-2019 07:48 PM - edited 06-26-2019 07:49 PM
Any one can explain ,how we are using ECE variables
06-28-2019 04:00 AM
Hi everyone,
1.we have 27 ECE variables, right?
yes, we have 27 variables.
2. can anyone explain, what is the purpose of we are using ECE variables?
ECE:- stored values associated with the contact.
3.what is the major difference ECE variables and user variables?
ECE variable is a user-defined variable and user variable is a globally defined variable.
If I am wrong, plz correct anyone.
waiting for u guys reply...
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide