Enterprise Vault™ Auditing

To use the OData service with Microsoft SQL Server Reporting Services (SSRS)

1. Open Report Builder.
2. Add a new datasource as an XML connection type.
3. In the Connection string box, specify the URL for the data feed as follows:

   https://EVServer/EnterpriseVaultAPI/OData/Auditing/endpoint_name(parameter=value)?$format=application/atom+xml

   For example:

   https://EVServer1.domain.com/EnterpriseVaultAPI/OData/Auditing/AuditEntries(recordsPerFetch=100)?$format=application/atom+xml

4. Provide credentials to connect to the data source.
5. Click OK.
6. Add the dataset using the above mentioned datasource.
7. Select Use a dataset embedded in my report.
8. Select the dataset from the list.
9. Set the query as follows:

   <Query>
     <ElementPath IgnoreNamespaces="true">
       feed{}/entry{}/content{}/properties   
     </ElementPath>
   </Query>

10. Click Refresh Fields.
11. Use the new dataset as reporting data for the SSRS report.