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.
Create a new query from an existing data source.
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.
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.
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.
To save the query, on the File menu, click
Save.
To return to Excel, click the 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.