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
creating different searches in one case and exporting seperate pst's
Hi , i had a criteria where i have to seach for different users based on some criteria under one case and needed to get the pst's seperatley for each case. what i did is created 6 new searches in a single case and accepted all the seaches \then exported which turned out single pst file . do i have to accept each seach speperately and export ? if i needed in single case ? How it works ? ThanksSolved2KViews1like6Comments
Search with Multiple AND and OR
Hello. I am trying to find items with one search that matches the following in English: subject or content (blue and car) or (red and car) or (yellow and car) or (blue and boat) or (red and boat) Tried the following in DA: subject or content: blue red yellow +car subject or content: blue red +boat When I run this search it seems like it is finding only those items that match on car AND boat or blue or red or yellow. Thanks in advance. Analytics is NOT enabled for the case. -Tammy449Views0likes2Comments
Compliance Accelerator - Adding phrases with wildcards to Hotwords
Hi, As per the administrator's guide for Compliance Accelerator, one must use double quotation marks when adding phrases to hotwords. Can I use wildcard words when 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, then how would I do it?Solved1.7KViews0likes3Comments
DA search terms and symbols
I'm looking at a particular search where they are looking for near hits and, amongst the search terms, excluding to or from certain targets. eg. restructur match within 10 characters as well as not to or from T:Joe McSweeney. Also How many wildcards can you use in a single line before the search is considered malformed?Solved2.9KViews1like10Comments
Compliance 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 searches under 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.Solved777Views1like2CommentsCompliance 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.5KViews1like10Comments