A read-only application that you can use to browse auditing reports created by ApexSQL Trigger, with multiple filtering and grouping options for convenient data browsing.
- ApexSQL Trigger Viewer
- Version:2016.03.0144
- License :Freeware
- OS:Windows All
- Publisher:Apex SQL Tools
ApexSQL Trigger Viewer Description
Running large databases in SQL Server and having multiple users handle all the data might, inevitably, generate errors and accidental changes. Fortunately, there are advanced auditing tools out there that can track modifications and their authors, as well as the time they were made. One such application is ApexSQL Trigger, which can audit database updates and create unattended reports. Its partner app, called ApexSQL Trigger Viewer, is specifically designed for opening those reports in read-only mode, which may serve executives who just need to take a look at the report without operating any changes.
A viewer for audit reports created by ApexSQL Trigger
ApexSQL Trigger Viewer is thus a tool that only bundles read functionality for reports created by ApexSQL Trigger. Not that the reports cannot be viewed with the latter, but it is more comfortable and smart to deploy a cost-free and more lightweight application for browsing such reports than deploying ApexSQL Trigger on a computer that does not need it.
Just like its bigger brother, ApexSQL Trigger Viewer requires you to set up a new connection to the SQL Server instance and select the target database. Alternatively, you can choose to open an ApexSQL Trigger connection file (DAT format).
Different modes to view a report and filter the data
Thinking about large reports with hundreds of entries, ApexSQL Trigger Viewer packs advanced filtering and grouping criteria. Simple filters, such as the target database, the table name and its schema, the column name, the change author, or the time period in which the modifications were made are available in the ‘Standard’ viewing mode. The application enables you to customize the number of rows the report will show and filter the data by the action type (update, insert, delete), along with the aforementioned criteria.
The aggregate mode brings grouping criteria to the table, enabling you to handle database entries by the table name, change author, action type, used application and workstation, or date.
A distributed report viewer for ApexSQL Trigger
There is no doubt that a cost-free audit report reader is an option when the report generator is not free of charge. And even though its functionality is not amazing, the filtering and grouping criteria make it easier for you to find the piece of information you are looking for. But if that is not enough, perhaps the ‘Find’ panel will manage to help.