Forum Discussion

sidedave's avatar
sidedave
Level 3
10 years ago

Custom CA Reports

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?

Compliance Accelerator
Information Governance
Tip-How to
Windows Server (2003-2008)
  • TonySterling's avatar
    TonySterling
    10 years ago

    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,

     

  • TonySterling's avatar
    TonySterling
    Moderator
    10 years ago

    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's avatar
    sidedave
    Level 3
    10 years ago
    Those posts were very useful; a great starting point. Thanks Tony!
  • EV_Ajay's avatar
    EV_Ajay
    Level 6
    10 years ago

    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's avatar
    RK_EmailAdmin
    Level 3
    10 years ago

    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.