Search <book_title>...

Enterprise Vault™ Auditing

Last Published: 2022-09-04

Product(s): Enterprise Vault (14.3)

About this guide
1. Introducing this guide
2. Where to get more information about Enterprise Vault
  1. Enterprise Vault training modules
Introducing Enterprise Vault auditing
1. About Enterprise Vault auditing
Setting up auditing
Viewing the audit database entries
Auditing for data protection compliance
1. Auditing general delete operations
  1. Example query search for general item delete audit entries
2. Auditing privileged delete operations
  1. Example query search for privileged delete audit entries
Appendix A. Format of audit database entries
1. The format of audit database entries

Using the OData service with Microsoft Excel

The following instructions are for Microsoft Excel 2010 and 2013. Make sure that you have installed the Microsoft Power Query add-in for Excel. You can download the add-in from the following page of the Microsoft website:

https://www.microsoft.com/download/details.aspx?id=39379

To use the OData service with Microsoft Excel

Open Microsoft Excel.
Create a new, blank workbook.
On the Power Query tab, in the Get External Data group, click From Other Sources, and then click From OData Data Feed.
In the OData Feed dialog box page, in the URL box, specify the website address for the data feed as follows:
https://EVServer/EnterpriseVaultAPI/OData/Auditing/endpoint_name(parameter=value)
For example:
https://EVServer1.domain.com/EnterpriseVaultAPI/OData/Auditing/AuditEntries(recordsPerFetch=100)
Note:
Take care to specify the mandatory parameters that are required to view the endpoint information. For information on them, see the online Help for each endpoint.
If you are prompted for your credentials, enter them and then log on. The Query Editor opens.
In the Query Editor, view the records available for the endpoint. Edit the queries as required.
Click Close & Load to import the endpoint information in Excel in tabular format.