CA Database Schema - SQL Querying
Hi there - I am currently looking to build some custom SQLqueriesagainst 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 Hotword search issues
We have a number of departments and searches and in one particular department the search for hotwords always produces 0 hits. Searches for attachments and external (named) recipients works fine. After some testing, I’ve narrowed the problem down to the message route of ‘FROM <dept> to outside the organisation’. I’ve managed to get hotwords searches to produce hits when avoiding the above message route, e.g. by putting in a specific destination domain. The problem appears to be how the search defines what is ‘outside the organisation’. However, this is working in other departments but just not this particular one. Any ideas to resolve this?1KViews1like2Comments
Message Status Summary Drill Down Report - Employee Journaled Message Stats Summary
Is there documentation for the drilldown report within "Message Stats Summary"? The drilldown report reads "Employee Journaled Message Stats Summary". Specifically, I cannot reconcile the counts within "Received" and "Sent". Thank you.Solved1.2KViews0likes6Comments