Overview
Version
Report Server Version | Function Change |
V11.0 | / |
V11.0.1 | Added the Template Error function. |
V11.0.13 | 1) Added Platform Log access permission of sub-administrators. 2) Added login/logout function under the User Behavior tab. 3) The original User Behavior function has been renamed to Template Business function. |
| V11.0.19 | Added recording scenarios in Log Management, such as clearing all users and creating desensitization rules. |
Function Introduction
Platform Log monitors and analyzes the system operation. You can view various indicators of the system's operating status through this function.
Platform Log includes Access Statistics, User Behavior, Template Popularity, Performance Monitoring, Log Management, Template Error.
Notes
Version 11.0.13 added access permission for sub-administrators to view Platform Log.
Starting from version 11.0.13, if sub-administrators want to view platform logs, they need to have permission to use the Platform Log module.
The administrator logs into Decision-making Platform and grants sub-administrators access to Intelligent Operations > Platform Log.
Access Statistics
Access Statistics is divided into two aspects: Access Time and Template Access Details, which can be used to analyze the usage rate of templates.
System Visits
System Visits is presented in a line chart, which introduces the system access times, the number of visited templates, and the number of active clients. When FineReport is integrated into FineBI, the System Visits page is shown as the following figure:
Administrators can filter access time by month.
From any node in the cluster, you can view the log information of the entire cluster.
1. Data Source
The data in System Visits is filtered from the fine_record_execute table in the LogDB database.
Note: For specific introductions to the fields of the fine_record_execute table, see LogDB Table Structure .
Statistical Objects | Field Type Encoding | Types |
Report template | 0 | Page preview |
1 | Online analysis | |
2 | Data-Entry preview | |
3 | Dashboard preview | |
4 | Row-based engine | |
5 | Online editing | |
6 | New filling | |
7 | New engine preview | |
8 | FVS preview | |
BI template | 101 | BI template preview |
102 | BI template editing | |
105 | Viewing the BI public link | |
104 | Creating the BI public link | |
109 | Saving the BI template as | |
202 | Editing the self-service dataset | |
204 | Turning off sharing the self-service dataset | |
205 | Closing sharing the BI template. | |
206 | Closing a BI public link | |
302 | Editing a Component | |
401 | Previewing an Excel plugin template | |
404 | Creating a common link for Excel plugin | |
405 | Accessing Excel plugin template via a public link | |
409 | Saving the Excel dashboard as |
2. Calculation Logic
The calculation logic for each value is shown in the following table:
Numerical Value | Introduction |
Monthly Average Daily Visits | Within the days in the current month, the total number of times reports and BI templates were accessed divided by the number of days visited |
Monthly Active Templates | The number of unique templates visited this month |
Monthly Active Users | The number of unique users who have accessed the platform this month |
Daily Visits | Total number of reports and BI templates accessed on the day, represented by the blue line |
Daily Active Templates | The number of unique reports and BI templates visited on the day, represented by the green line |
Daily Active Users | The number of unique users who visited the platform on that day, represented by the orange line. |
Server Usage
1. The Current Number of Online Users
The system is unable to connect to WebSocket, the current number of online users cannot be displayed correctly, and user logging is not counted in the current number of online users.
When you log in two accounts on the same browser, the information of the latter user will overwrite the information of the former user, and only one user will be counted.
To be counted as part of the current system's online users (single sign-on also applies), users need to enter the platform through the login page. Simply accessing the template without accessing the platform will not be counted.
When a new user logs in to check the current number of online users in the system, the user remembers to refresh the page before checking.
2. Specific List Description
The Server Usage list introduces Accessed Resources, Template Name, Access User, Access IP, and Access Start Time when the user n1 accessed template n2 in the platform at time n3 and location n4.
The detail list displays the report template currently being previewed, regardless of whether the WebSocket is connected, so it may not be consistent with The Current Number of Online Users in the system.
Ordinary users can log in to view templates, and the access information of the template will be displayed in real time in this detailed list.
Ordinary users can close the template they are accessing, refresh the platform, and the access information of the template in the details list will disappear.
Template Access Details
The Template Access Details records Operation User, Operation IP, Operation Time, Accessed Resources, Template Name, and Operation Types when the user n1 accessed the template n2 in the system in way n3 at location n4 and time n5, and all template access records under the project will be displayed here.
1. Query Method
Administrators can select a certain time period. The default period is from the previous day to the current day. Click Query to query the details within that time period.
Administrators can tick Advanced Query Conditions, select the content to be queried, and then click Query to query the details under specific settings.
Support filtering logs with empty operation users, and templates with empty template names.
2. Export Access Details
After the query, the administrator can export the log file.
Support exporting template access details. Click the Export as log button to export TXT files and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
3. Operation Type
The logs are stored in the fine_record_execute table of LogDB. For details, see LogDB Table Structure.
The operation field is a number in the log, corresponding to the report access method. The defined types of log information are shown in the table below:
Number | Types | Number | Types |
0 | Page preview | 20 | Exporting PNG images |
1 | Online analysis | 21 | Exporting GIF images |
2 | Data-Entry preview | 22 | Exporting BMP images |
3 | Dashboard preview | 23 | Exporting WBMP images |
4 | Row-based engine | 24 | Built-in dataset export template |
5 | Online editing | 25 | HTML export |
10 | Excel page export | 27 | Exporting Excel files through BI |
11 | Exporting files in Excel format | 30 | Flash printing |
12 | Exporting all Excel sheets | 31 | PDF printing |
13 | Export Excel sheets separately | 32 | Applet printing |
14 | Exporting the PDF files | 33 | Zero client printing |
15 | Exporting the Word files | 34 | Local software printing |
16 | Exporting the SVG files | 101 | BI templates preview |
17 | Exporting the CSV files | 102 | BI templates editing |
18 | Exporting the text | 103 | Sharing the BI template |
19 | Exporting JPG images |
User Behavior
User behavior is divided into two aspects: Template Business and Login Logout. Specific user operation information can be obtained and analyzed easily.
Template Business
Support viewing the frequency of user visits and operations within a specified time period, including viewing, exporting, and other operations.
Display access data grouped by users, set date range parameters and user parameters, and clients can query the report access situation of different users within a specified time period.
Support filtering logs with empty usernames.
Click the username hyperlink to jump to the user's operation details.
After the query, the administrator can export the log file.
Support exporting logs. You should click the Export as log button to export TXT files, and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
Login and Logout
Version 11.0.13 added a login/logout log recording feature.
Record every login and logout request of the user, including default login, cross-domain login, remote design, third-party, and mobile terminal.
Support user login behavior analysis, which can filter information by operation date, operation result, operation user, and operation type, making it easy for users to review the login status.
1. Query Method
Select a time period, and the default is from the previous day to the current day. Click Query to query the login and logout records within that time period.
Select the content to be queried in the checkbox, then click Query to retrieve login and logout records under specific settings.
2. Exporting Login and Logout Logs
After the query, the administrator can export the log file.
Support exporting logs, click the Export as log button to export TXT files, and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
3. Explanation of Log Viewing
The login and logout logs are stored in the fine_record_login table of LogDB, and the corresponding description is shown in the following table. For details, see LogDB Table Structure.
Field | Meanings | Introduction |
actionMethod | Login method | 0: Default login 1: Cross-domain login 2: Remote design 3: Third party 4: Mobile end Note: When logging out without a login method, the field value is -1. To distinguish the logged-out device, you can set the field value for mobile logout to 4 separately. |
actionType | Operation type | 0: login 1: logout 2: timeout logout 3: keeping logged in |
authMethod | Authentication Method | 0: password 1: verification code 2: integration Note: When logging out without authentication, the field value is -1. |
actionResult | Operation result | 0: success 1: failure |
Template Popularity
It supports template access analysis so that administrators can understand business hotspots. Count the frequency of template access within a specified time period, including viewing, exporting, printing, and other access operations.
The information displays in descending order of total operation times, the template name displays as configured in the platform, and the path displays as the template path.
1. If you view the template through a non-platform directory (template URL or drill-down), the template name is empty.
2. If the same template is mounted in multiple directories on the platform, it will be counted as multiple records.
For the same template, if viewed through a URL or by drilling down, it will be counted as multiple records for statistics.
3. Support filtering templates with empty template names.
Click the template path hyperlink to view the detailed template access information displayed in chronological order.
After the query, the administrator can export the log file.
Support exporting logs, click the Export as log button to export TXT files, and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
Performance Monitoring
Support responsive performance analysis of templates, providing reference for administrators to optimize the system.
Display the template that has completed user requests, Max response time, Min response time, Average Time, and Average Memory. Set the date parameter and the operation type parameter at the same time.
Tick the Details option, and the effect is shown in the following figure:
After the query, the administrator can export the log file.
Support exporting logs, click the Export as log button to export TXT files, and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
Log Management
Same as Access Statistics, click Query to display log information: Module, Settings, Operating User, Operation IP, Operation Time, Accessed Resources, and Operation Types.
Operation types are shown in the following table.
| Module | Setting | Operation Type |
Directory Management | Node, template, link, report tab, and homepage management | Add, update, and delete |
User Management | Global setting, user, department, position under department, position, personnel under position, role, personnel under role, platform user, mobile user, and clearing all users | Add, update, and delete |
Permission Management | Global setting, permission configuration, and permission reuse | Add, update, and delete |
GUI Configuration | Login page, platform theme, platform style, directory style, and report style | Update, switch, open, close |
Attachment | Attachment upload | Add |
System Setting | Login, general, print, SMS, mailbox, and login lock | Open, close, update, lock, unlock |
Backup and Restore | Global setting, platform configuration, report template, JAR package, plugin, and update and upgrade | Open, close, add, update, delete, and restore |
Platform Log | Log setting, access statistics, user behavior, template popularity, and performance monitoring | Update and export |
Load Management | Intelligent alert, memory session, intelligent release, template limit, and lifecycle | End and update |
Cluster Configuration | Status server, file server, MQ built-in, and cache mode | Test and update |
Downtime Handling | Dump parsing and port setting | Execute and test |
Disk Operation and Maintenance | Disk clean and disk usage analysis | Update, search, and execute |
Data Connection | Data connection management, server dataset, and dataset | Preview, add, update, delete, and test connection |
Intelligent Operation and Maintenance | Health inspection and inspection report | Execute and download log |
Resource Handover | Resource import and resource export | Import and export |
Security Management | SQL injection prevention, watermark setting, and data desensitization | Open, close, update, enable, disable, and add |
Registration Information | / | Update |
Task Schedule | Scheduled task and global setting | Add, update, and delete |
Multi-level Reporting | Reporting process and reporting task | Add, update, and delete |
Mobile Platform | Mobile platform, authorized device, and QR code configuration | Open, close, update |
Map Configuration | Geographic information | Update and import |
Template Authentication | Global setting and permission configuration | Open, switch, close, update, add, and delete |
Remote Design | Permission setting | Update |
Plugin Management | / | Install, delete, enable, disable, and update |
Tick Advanced Query Conditions.
After the query, the administrator can export the log file.
Support exporting logs, click the Export as log button to export TXT files, and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
Template Error
Starting from version 11.0.1, the report project has added a new feature, Template Error.
Function
Click to query and summarize the errors in template use, including Template Name, Accessed Resources, Error Code, Error Content, Occurrence, and Total Visits.
1. If you view the template through non-platform directories (template URL or drill-down), the template name will display as non-mounting access.
2. If the same template is mounted in multiple directories on the platform, it will be counted as multiple records.
For the same template, if viewed through a URL or by drilling down, it will be counted as multiple records for statistics.
3. Only display templates with error records in the filter bar.
Click Error Details to display detailed errors and query information for the corresponding error category under the corresponding template, including User Name, Error Details, Query parameters, Error Time, and Template Preview Result.
Note: To avoid redundant error messages, only the first five errors that occur will be recorded for a single visit.
After the query, the administrator can export the template error log file.
Support exporting logs. You can click the Export as log button to export TXT files, and click Export to Excel to export XLS files.
Note: You can export 10,000 log data at most.
Template Error Notification
The administrator logs in the Decision-making System, clicks Manage > Intelligent Operations > Platform Log and Global Setting, and it supports enabling Error Template Message.
If Error Template Message is enabled, the system will check the error templates of the previous day at 2 am every day. When there are error templates, the administrator can be notified through three forms: SMS reminder, platform message, and email reminder
Note:
1. SMS reminder: enable the SMS platform first, and for details, see SMS Service.
2. Email reminder: configure the Email server first, and for details, see Email Service.
3. Platform message: configure and enable the WebSocket port at the load balancing level, and for details, see WebSocket Port is occupied.
