04-02-2015 07:00 AM
Hey.
The standard CA reports are pretty useful, but I'm wondering it it's possible to create a custom report or modify an existing one. Specifically, I'm inerested in "Monitored IDs by Department". That report only includes messages from random sampling or guaranteed sample searches, but I'd like one that covers scheduled searches as well.
I don't need for the report to be visible in the CA console. If there's a database query that returns the desired info, I could transform that into a CSV which would be just fine. Poking around in the database, I haven't been able to make a lot of headway.
Any ideas?
Solved! Go to Solution.
04-02-2015 08:15 AM
These are older but might help:
https://www-secure.symantec.com/connect/articles/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-1
https://www-secure.symantec.com/connect/articles/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-2
or you could work with a partner to develope one.
Best,
04-02-2015 08:15 AM
These are older but might help:
https://www-secure.symantec.com/connect/articles/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-1
https://www-secure.symantec.com/connect/articles/creating-custom-report-symantec-enterprise-vault-discovery-accelerator-80-and-higher-part-2
or you could work with a partner to develope one.
Best,
04-09-2015 11:01 AM
04-09-2015 09:31 PM
Hi,
You can also try follwoing SQL query against CA Customer Database and you will get desire result.
Select tc.CaseID 'DepartmentID',tc.Name 'Department Name',tu.EmployeeID,ta.Address 'EmailID'
From tblAddressUser tu
JOIN tblHistCaseAddressUser th
ON th.AddressOwnerID=tu.AddressOwnerID
JOIN tblCase tc
ON tc.CaseID=th.CaseID AND th.EndDate IS NULL JOIN tblAddress ta ON ta.AddressOwnerID=tu.AddressOwnerID
Where tc.Type=102 AND tu.MonitorStatusID=120 Order by tc.Name
04-21-2015 09:14 AM
Please post the result if you are able to do this. We are looking for the same sort of thing for scheduled searches.
Thank you.