UCCE ECE Variables

[anthonyroesler]

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.

[Omar Deen · Accepted solution]

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

[Slavik Bialik]

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?

[Omar Deen]

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

[udemylearn2851]

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?

[bill.king1]

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.

[udemylearn2851]

Any one can explain ,how we are using ECE variables 

[udemylearn2851]

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...