cancel
Showing results for 
Search instead for 
Did you mean: 

Custom CA Reports

sidedave
Level 3

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?

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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,

 

View solution in original post

4 REPLIES 4

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

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,

 

sidedave
Level 3
Those posts were very useful; a great starting point. Thanks Tony!

EV_Ajay
Level 6
Employee Accredited

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

Query Result.jpg

RK_EmailAdmin
Level 3

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.