ICM - Remove E-mail Manager & ECC Variables

[Mark Cockrell]

How do I uninstall / remove the e-mail manager and associated ECC Variables?  My initial thought was this must be an option in icmsetup but after a little poking around I can't find any options that jump out at me. 

The ECC Variables for e-mail manager are:

cisco.cem.Category

cisco.cem.Priority

cisco.cem.MessageKey

My primary motivation for getting rid of them (Other than good housekeeping) is that they are consuming 450 bytes of ECC space.

Thanks!

[Jameson Gagnepain]

I wonder about this as well. We're going through a UCM and UCCE upgrade soon, I'm hoping our implementation partner can remove these as part of the upgrade.

[Gergely Szabo · Accepted solution]

Hi,

er... can't you just disable them in Config Manager > Expanded Call Variable list?

I mean, they're Cisco Provided so no way to get rid of them permanently, but the "Enabled" checkbox should still work.

G.

[Mark Cockrell]

Thanks for the responses.  The variables are currently 'disabled' but it appears they are still being included in the total byte calculation. 

I realize they're cisco provided but there must be a way to get rid of them as the e-mail manager functionality is EOL/EOS.

I suppose I'll open a TAC Case if no one has any other ideas.  (Other than deleting them directly from the database.)

[Gergely Szabo]

Hi, are you sure about that?

>> it appears they are still being included in the total byte calculation

Where do you see that?

G.

[Mark Cockrell]

Looks like I stand corrected, the 'Enabled' parameter does indeed remove the variables from the Total Byte calculation. 

I threw together some SQL to calculate ECC Byte usage if anyone else is interested:

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 MyTable

[Gergely Szabo]

Wow. Now, there's that 'Hey, I should have thought about this earlier' feeling. Not nice to be envious indeed. Kind of like you have stolen my idea - of course, you did not.

Anyways, +5. Would give you twice as much if I could.

G.

[Jameson Gagnepain]

Ooh, thanks for that nice SQL snippet Mark. Definitely adding that to my library.