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.6KViews0likes2CommentsCompliance Accelerator - Adding phrases with wildcards to Hotwords
Hi, As per the administrator's guide forCompliance Accelerator, one must use double quotation markswhen adding phrases to hotwords. Can I use wildcard wordswhen adding a phrase to the hotwords? For example if I want to add the following phrase to the list of hotwords:a comp* word If yes, thenhow would I do it?Solved1.7KViews0likes3CommentsCompliance Accelerator with Mailbox Archiving
I am trying to use Compliance Accelerator to search user's mailbox archives. I created a new department and marked the Mailbox Archive as searchable. I gave the ev account all the nessecary roles on the department. However when I create a search it doesn't run. I have another department for the journalled mail and I'm able to search that without any issues. Is there some other permission somewhere that prevents me from search mailbox archives?Solved1.6KViews0likes2CommentsCA 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.Solved1KViews1like1CommentCompliance Accelerator 9.0.4 Reporting
I recently installed and configured Compliance Accelerator 9.0.4 but I need to get reporting up and running. When I go to the reporting tab it says "Disconnected from report server". I'm assuming I need to install SQL Reporting services. I was hoping someone could provide me a KB article for configuring CA reporting.Solved775Views1like2CommentsCompliance Accelerator 9.0 configuration
I installed Compliance Accelerator and I created a new search under the Application Tab and let it run and it finished successfully. However when I go to the Review tab it says "No Items Avaliable" so I'm wondering what I'm missing...Solved1.5KViews1like10CommentsEV Compliance Accelerator questions
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 than one percent be sampled? d. How can I view the reports/activity as a user? On point a. we deployed CA earlier this year anticipating an SEC filing shortly there after, it was delayed and is now going to take place finally. The CCO would like to not have to bulk mark 50K+ items that have accumulated since they weren't operating in a production capacity with the product and wants to know if there is a way to clear all of this out. They would like to see if we can flush the random sampling hits and test searches to start from scratch while leaving the sampling configuration in place against the departments that have ben previously configured. Point b. I think I have the answer and that should be the ability to set a dash infront of an entry in the hotword / keyword parameters for the sampling IE: -donotreply@delta.com to skip anything with that address in the journaled mail content correct? Point c. they have the sampling rate set to 1% right now and feel that is still too much of a percentage as they will be monitoring 200 users for compliance with CA. Idealy they would like to be able to set it around .25-50% for now. Point d. is related to configuring CA reports that would be like a report template that any CA user would be able to see and run at any time. What we've come across is that a report created by the CCO can't be seen by another user that would be a compliance reviewer. Any assistance would be appreciated! =) Thanks, Nick M.Solved1.2KViews0likes3CommentsCA servers in different sites\physical locations
Hi, New to CA, but not EV. Planning an installation for a large customer with EV and Exchangein 3 geographically seperate locations\datacenters. Not sure yet if we'll have journal archiving in all 3 sites, but there will be in at least one. EV archving from Exchange 2010 mailboxes will be configured at each site. What is the best practice for the location of the CA server(s)? CA will be targeting all archived users in all regions. Should we have a CA server in every site? Lets say we'll have around 10,000 mailboxes in each site with 100% of them being archived. Thanks, Mitchell.Solved628Views0likes1CommentCompliance Accelerator Cannot Connect to server
I upated Enterprise Vault 9.0 to 9.0 SP4 last night. I then updated Compliance accelerator as well. Now when I try to login from the Compliance Accelerator Client I receive a message that says "Cannot connect to server - The server is in the process of being upgraded, please try again later." I rebooted the EV servers and that didn't have any effect. Any ideas as what's causing the issue? All the services are running and when I login to Enterprise Vault it shows that it's been updated to the latest version.Solved637Views0likes3Comments