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
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
Meta Data and regular expression seach in DA
Hi , I have EV 10.0.4 deployed, and have Journal archiving enabled (Exchange 2010). On top of that I have Discovery Accelerator 10 installed. My question is around search, in partiular, can it do the types of searches that are listed below:- 1) Document Metadata searches: So if you right click on a word document, and select the Details tab, would a DA search find any of the information there ? 2) Regular expressions search Can searching use regular expressions, so for instance can I search for National Insurance numbers, which are in the following format:- <letter><letter><number1><number2><number3><number4><numbe5r><>number6<letter>, such as AB123456P I don't need to find a particular NI number, but would like to find ALL occurances of NI numbers, ie any occurance of <letter><letter><number1><number2><number3><number4><numbe5r><>number6<letter> ? In the same way as that I would want to check for credit card numbers, which is a something like 4 sets of 4 numbers Any help would be appreciated regards Jim792Views0likes3Comments
Deduplication in Discovery Accelerator
Hi- I am running Discovery Accelerator 9.0. I am searching for 4 email addresses in the To/From fields. The search is limited to a journal archive. My question is, when the search results are presented, are they deduplicated automatically? The search results returned 109,000 items. Does Discovery Accelerator, behind the scenes, perform deduplcation during the search process? I've read a ton of material, but its not clear to me whether deduplication is something that I have to elect to do, or if it is done by default.Solved1.1KViews0likes2Comments
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 Unable to modify a search thats setup
We are running CA 10.0.4 and have searches setup on a daily schedule to collect the emails against the hotword for the compliance team to review. They have started providing email addresses to block, so i can see we need to do this under the freeform email addresses area. I created a new search to test this, which is fine and works - but I am unable to go back into the search and modify the email exclusions to include any new ones that they add.. I have created a new role that has all the permissions selected and it still doesnt allow me to modify the search. Is this a restriction of the product or is there a way to do this and to also remove old searches under the search screen in Departments? Any assistance gratefully recieved!Solved1.1KViews0likes3CommentsCA - Random Caputre Question
I was wondering if there was a way to change the way CA caputres emails. Here is our problem. Ex. I send an email to a distrubition list which has 20+ employees in our department and a couple outside clients are on the email as well. This email is now marked as external outbound. My manager reviews all the 20 internal employees on the email and now has the same 20 emails to review. I'm having a hard time to understand why this email will go to their ques since they - did not send the email - email did not come from outside in The email should only be review by my reviewer since I was the author.Right ? Our current config - The 20 employees are mapped as an exception to the same reviewer. (The department has more then 20+ emoployees with differnt reviewers) - ver. CA 9.02 - Random capure, StatisticalSolved1.3KViews1like8Comments
Back Track Exported Item to Archive and Mailbox Folder
I'm hoping this is a simple question. We have DA 9.0 running on a windows server 2008 R2 box with the client on a windows xp sp3 box. We are looking to trace an exported item back to the Archive from which it was pulled as well as the folder from which it was pulled. i.e. Archive jmcsweeney in sent items. Either I'm missing something or we need to trace it by the item ID or the SaveSetID. Also if there is a flag somewhere that I can set to sho this level of granularity. Any assistance is much appreciated.Solved644Views0likes4CommentsDiscovery and Compliance Accelerator 10x - Describe your Features
Hello Guys, Well, I need to prepare a WorkShop to describe in company (legal departament) the functions of Enterprise Vault Compliance and Discovery Accelerator 10x. I have seen some guides about it but I can't understand to develop a workshop. I would like to know if anyone has any extra material that could help me to do it. For example: E-learning, Power Point, PDF and etc. Thanks so Much.Solved894Views1like4Comments