CA Database Schema - SQL Querying
Hi there - I am currently looking to build some custom SQL queries against the CA database but am struggling to understand the various tables and their relationships. Is anyone aware of where I can find a data relationship diagram, CA data model schema, or data dictionary to assist? As a temporary option, I am looking at the IntDiscoveredItems table which I understand are similar to the alerts produced when certain hotwords are hit. However I am unsure how to link this table back to the IntHotwordID table? Any help is much appreciated.1.6KViews0likes2Comments
CA Unable to modify a search thats setup
We are running CA 10.0.4 and have searches setup on a daily schedule to collect the emails against the hotword for the compliance team to review. They have started providing email addresses to block, so i can see we need to do this under the freeform email addresses area. I created a new search to test this, which is fine and works - but I am unable to go back into the search and modify the email exclusions to include any new ones that they add.. I have created a new role that has all the permissions selected and it still doesnt allow me to modify the search. Is this a restriction of the product or is there a way to do this and to also remove old searches under the search screen in Departments? Any assistance gratefully recieved!Solved1.1KViews0likes3Comments
