ECE 12.6 Audit

[Muhammed Ashiq]

Hi,

Does any one have ECE database schema ?

We have a customer who needs audit log as log file or database output in order to compliance with security policy. Audit log from ECE console is not acceptable.

As ECE doesn't have Audit file as log file we are focusing for Database output.

we have ECE 12.6,below are the customer requirements.

1. Login Success/failure (along with failure reason)

2. Admin Audit trails (Login/Logout/failure, modification etc.)

3. User/Admin privilege changes; group/Role modification if any?

4. details performed by user (like success / failed sales/purchases)

Kindly ensure following information is available while fetching above requirement from DB.

1. Date & time

2. Source ip

3. User

4. Success/failure (along with failure reason)

5. Activity details

Regards,

Ashiq Mattil

[Omar Deen]

The closest thing you'll get a database schema doc is this data dictionary document from 11.6... otherwise, eGain does not publish it. Back in the EIM/WIM days, there used to be a doc, but that's way outdated

https://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/enterprise_chat_email/enterprise_chat_email_11_6_1/Programming/Guide/ece_11_6_data_dictionary.pdf

[bill.king1]

This probably doesn't solve your issue, but here's another way to see about agent login information in case it helps you.

https://www.cisco.com/c/en/us/support/docs/contact-center/enterprise-chat-email/215324-troubleshoot-agent-login-and-availabilit.html

[Omar Deen]

Oh that's a useful TechNote! Thanks for sharing, Bill