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 10 Searches do not start
I installed and configured CA 10.0.4. I created a couple searchesunder the application tab but they are not showing up under the Monitor tab. I created a daily search with a schedule and it hasn't done anything. Io also created an immediate search to search for everything from 2013 and after I submitted the search it didn't start and I'm unable to find any searches under the monitor tab. Not sure what I could be missing... I'm also unable to delete the searches.Solved1KViews1like1Comment
Acquiring the total number of items used for the random sampling
Hello all, Concerning Compliance Accelerator, Enterprise Vault; I'm trying to determine the total number of items that are used (per 24 hours) in order to get the 1%+ random sampling. I understand that this is a per monitored employee query performed from the journal items passed through CA. This would be the total number of items CA would use prior to performing the random sampling. For instance, the 100,000 emails passing through the journal that CA would take it's 1% against. How would I get the 100,000. Is there a SQL query that anyone is aware of to get these numbers (either total or per mailbox) or perhaps a report from CA itself? We've used the Differential Sampling Summary by Department report but there appears to be no comparison between the numbers in that report versus what CA states in the Review. I realize that scanning times and variances most likely make a difference. We are using CA 9.0. Thank you!Solved896Views0likes5Comments