Reports : Activity Profiling Reports
Activity Profiling Reports
FortiDB allows you to export activity profiling information in report form. You filter the information that FortiDB includes in the report by target database and, optionally, by database user and table.
For information on managing reports using the Activity Profiling Reports page, see “Report management”.
Alternatively, you can export the profiling results displayed on the Target DB Activity Profiling page. You cannot add a schedule or configure notification for this type of report. See “Viewing and exporting activity profiling results”.
To configure and run an activity profiling report
1. On the navigation menu, click Report > Activity Profiling Reports.
2. On the Activity Profiling Reports page, under Name, click Activity Profiling Report.
3. On the General tab, for Name, enter a name for the report and an optional description.
Alternatively, you can use the default name (Activity Profiling Report). FortiDB adds the date to the name of each report it generates to distinguish it from any other reports with the default name.
4. Click the Data Filter tab.
5. For Target, select the target database whose activity profiling results you want to include in the report.
6. For DB Login/User, select either All Users or a specific user.
7. In the All Table Name list, select an item and click > (right arrow) to add it to the Selected Table Names list.
Repeat this step as required until all the tables to include in the report are in the list.
To select multiple items, click and item and then Shift-click a second item. Both items and any items between them are selected. Click Control-A to select all items.
8. Optionally, use the Schedule and Notification tabs to configure FortiDB to run the report at a scheduled time and send the report to one or more FortiDB administrators using email.
For detailed instructions, see “Schedule and notification”.
9. Click Save.
10. Do one of the following:
If you configured the report to run at a scheduled time, wait for it to run.
Click Run to run the report immediately.
11. When the Status value shows that the report no longer running, click [+] (plus sign) to access the instance of the report that you generated.
See also
Configuring monitoring using the TCP/IP sniffer (all database types)
Activity profiling