| News |
| By label |
| By team |
| By product |
|
ApexSQL Blog Product announcements, promotions and other ApexSQL news Trigger based SQL Server auditing – customize data tracking and reporting (part II)
Similarly as the Watches, the Lookups feature allows the ApexSQL Audit report to show a meaningful value from a related database table, along with the value of the field that was audited. A more human-readable value can be shown in the audit reports, for example "111" (customer’s ID number) versus "John Smithson" (customer’s actual name)
To examine how to achieve this, the previously described Clients table will be used, along with the Invoices table, which consists of the following columns:
Indicating that the Client field has changed the value from "111" to "222". Not much of an information for the reader of this report However, if the Lookups feature is set up properly, the output will be something like this: 
Here is how to accomplish this; The Lookups panel can be accessed from the View tab, in the Show panels section, just like the Watches:
Labels: ApexSQL Audit, Support team |
