Following guide provides an insight into SQL Server instance activities that are result of operations being taken within the SQL manage instance application.
Keeping a track record of operations performed on a SQL instance in the ApexSQL Manage may be a good feature to own.
This functionality allows users to keep track of ran operations, in other word activities, like server discovery, health checks, snapshot creation, comparison and documentation. Users can export activity logs, filter them by operation type, status and ran date, and to delete unwanted activity logs.
To see the mentioned operations, head over to the Activities tab of the main ribbon menu. Whether the SQL Server instance operation was scheduled or performed manually, it will be listed in the grid of the Activities tab:
Activities are conveniently displayed in the following grid columns:
Activities grid can be groomed to provide better overview of important information and filtered out to reduce information that might be considered as unnecessary noise.
To delete an activity, choose it from the grid and click the Delete button from the Data category. Click Yes on the following message dialog to confirm the action:
Listed activities can be easily exported into three different file formats: DOCX, PDF, XLSX. Simply select desired activities to document, click the Export button and from its drop-down menu choose the preferred file format:
The activities from the grid can be filtered to display desired SQL Server instance operations and its outcomes. The Filters category consists of the bellow displayed filters. Checking or unchecking them result in following actions:
To show only the FixSQL related activities with success status, uncheck all filters except Succeeded and FixSQL. The activities grid will look like this:
Additionally, the date range filter can be applied to the listed activities to extract only the ones that are executed within the selected date range. There are two ways of setting the date range:
Enter dates in required format by typing, in From and To boxes:
Pick dates from the calendar in both boxes:
For example, the following is a display of activities conducted in two sequential days: