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 sch...
Hi, I need help creating a sql query to collect the following data: * User Name/Login ID * First Name * Last Name * Email address * Account Disabled Flag * Entitlement within the application once...
Does anyone have a SQL Query that will return the results of each day's search. Name, Dept, Hits.Sampled, Duplicates? Thanks!!
Hi , I have a requirement to prepare a report on total no of items reviewed, pending and questioned for one employee in compliance accelerator. I checked the inbuilt CA report " Evidence of exchange(internal) review by employee " , but it displays ...
Greetings, Recently one of our business units has requested that we provide them a report where we can target specific hotwords, each which are part of larger "Hotword Sets" to try and determine which ones are occurring more often than others using ...
I am looking for a report that will list all employees from the "Employees" tab listing: Dislay nameEmployee IDEmail address Thank you.
When trying to run reports in Compliance Accelerator I am getting Event ID 405 APP AS - Customer ID: 7 - An error occurred retrieving the report snapshots. System.FormatException: String was not recognized as a valid DateTime. at System.DateTim...
I am looking for a report that lists all active searches for each department. Does this exist? Thank you.
Hi, Is there a way to automate one of the CA reports being produced say weekly at a set time? Thanks
Hi. I wanted to know if it was possible to run a report on everyone that has delegate access in Complaince Accelerator. Can someone point me to what table will have this info ? I would like to run the report in SQL...
Regulators will request evidence of email supervision. Specifically requested is: email and attachmentsreviewerdate of the reviewreviewer comments While a "Printable Version" of 1-10 messages may be printed from the Review Pane of CA containing this...
Our firm performs scheduled and immediate key word searches (no guaranteed sample or random sample). Which CA report provides total messages monitored employee sent and total messages sampled? Thank you.
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.
We are working on creating a custom report that will help us determine the following per Employee in a Department in Compliance Accelerator. 1) Total Number of Lexicon Items Flagged 2) Total Number of Random Sample Items Flagged 3) Total Number of It...
Hi All, Hoping someone here can shed some insight on a couple items our compliance department want cleared up. a. Delete the large test pool of open items on our enterprise vault? b. Can we flag or whitelist addresses? c. Can less ...
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 perfor...
Hello, Odd error, when i try and view reports using compliance accelerator it gives a 404 error, but that's because it's accessing the report using localhost as a servername. Where is the config file that i need to change to point it to the correc...
