Create a report containing policy changes in an XML format

When a user edits a policy, the resulting policy settings are saved in an XML format and can be accessed via the Reports.vAuditEventsForPolicyEditAndDuplicate database view.

You can create a report containing this additional data by linking the two tables, Reports.vAuditEventsAll and Reports.vAuditEventsForPolicyEditAndDuplicate.

  1. Create a new query from an existing data source.
  2. In Microsoft Query, click Table and then click Add Tables. In the Add Tables dialog box, select vAuditEventsForPolicyEditAndDuplicate and click Add. Once done, click Close.
  3. Link the tables to each other by linking the fields that are common to both tables. Click on the common field, EventID, in the first table and drag the mouse over to the EventID field in the second table.
  4. Add fields to the query by double-clicking on them. Alternatively, you can add a field to the query by dragging it from the table to the display area.
    Tip You can use the Joins dialog in Microsoft Query (Table > Joins) to create a query joining the two tables.


  5. To save the query, on the File menu, click Save.
  6. To return to Excel, click the Return Data button.

    Return Data button

    Alternatively, on the File menu, click Return Data to Microsoft Excel.

    Back in Excel, the Import Data dialog box appears. Create a table. The PolicyContent column will contain the policy configuration changes in XML format.
    Tip If you use Microsoft SQL Server Management Studio, you can query the Reports.vAuditEventsForPolicyEditAndDuplicate view directly. Then, when you follow a link in the PolicyContent column in the query results, the policy content will be displayed in an XML editor in a format more readable than that in an Excel table.