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

UCCX SQL database

I need to remove a specific email in the UCCX database and for this I'd like to use the command "utils uccx eemtables cleanup uid" but I don't know how to get the email uid.

Can someone explain me how to get the uid from the UCCX database ? The UCCX version is 8.5(1) SU3.

Many thanks in advance !!

2 ACCEPTED SOLUTIONS

Accepted Solutions

Re: UCCX SQL database

I'm not sure what you're doing or how you're doing it, but here is the database schema guide:

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/user/guide/uccx85dbschema.pdf

And according to a few tables on the subject of email, it looks like the UID is the unique Identifier for an email, and can be retrieved from UCCX with the following type of command:

run uccx sql db_cra select emailid, emailsubject from eemactiveemail where emailsubject like '%some%key%words%'

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

UCCX SQL database

That's great.  Could you please mark this answered?

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
3 REPLIES

Re: UCCX SQL database

I'm not sure what you're doing or how you're doing it, but here is the database schema guide:

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/user/guide/uccx85dbschema.pdf

And according to a few tables on the subject of email, it looks like the UID is the unique Identifier for an email, and can be retrieved from UCCX with the following type of command:

run uccx sql db_cra select emailid, emailsubject from eemactiveemail where emailsubject like '%some%key%words%'

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
New Member

UCCX SQL database

Hello Anthony,

Thank you for your answer and the link you provided, both helped me to find the exact command I needed to retrieve the email UID and to remove the corresponding email:

run uccx sql DB_CRA select emailUIDOnMailServer from EEMActiveEmail where emailSubject = "Nouvelle demande: 2047736 / 450"

which gives the email UID:

EMAILUIDONMAILSERVER
--------------------
1615986528

Remove the email:

utils uccx eemtables cleanup uid 1615986528

Mode is: uid
This will delete records from email related tables.
If you're sure you wish to continue, press 'Y'


Performing Cleanup . . .


Begin ExecuteUIDModeQueries : 1615986528
Deleting records from EEM Active Email table
Deleting records from EEM Agent State Detail table
Deleting records from EEM Queue Agent Detail table
Deleting records from EEM Contact Email Detail table
End ExecuteUIDModeQueries

Check if the email is removed:

run uccx sql DB_CRA select emailUIDOnMailServer from EEMActiveEmail where emailSubject = "Nouvelle demande: 2047736 / 450"


EMAILUIDONMAILSERVER
--------------------

No records found

Command successful.

Thank you so much !!

Alexandre

UCCX SQL database

That's great.  Could you please mark this answered?

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
472
Views
0
Helpful
3
Replies