Platform Log

Version

Functions

System status refers to monitoring and analyzing various aspects of system operation. Through this function, you can view various indicators of system operation status.

System status includes Access Statistics, User Behavior, Template Heat, Performance Monitoring, Manage logs, Template Error, and Download Log.

View the access time, access frequency, access method, and access users of the dashboard in detail to help admins understand the usage rate of each dashboard.

The statistics information includes system access times and report access details.

System Access Times

System Visits is presented in a line chart, which introduces the system access times as well as the number of visited templates and active users. When FineReport is integrated into FineBI, the System Visits interface is shown as the following figure:

• Admins can filter access time by month.

• From any node in the cluster, you can view the log information of the entire cluster.

Data Source

The data in System Visits is filtered from the fine_record_execute table in the LogDB database.

Select Report Template and BI Template as Statistical Object to filter the data with the type code within the following table in the fine_record_execute table for statistical indicators in the chart.

Note:

1. For details about the fields in the fine_record_execute table, see LogDB Table Structure.

2. Selecting both Report Template and BI Template as Statistical Object can filter out all the data shown in the table below.

3. Statistical Object is counted according to the template name. If the name of a dashboard is changed, besides the previous one, the dashboard with the current name will become another statistical object, so there are two statistical objects.

Calculation Logic

The calculation logic for each value is shown in the following table:

Server Usage

The Current Number of Online Users

When FineBI is not connected to WebSocket, the logged user cannot be counted in the current number of online users in the system, so the current number of online users cannot be displayed correctly.

If you log into two accounts on the same browser, the account information of the latter user will overwrite that of the former user, and only one user will be counted.

To be counted as a current online user in the system, you need to enter the platform through the login page, and the same as single login. Simply accessing the template without accessing the platform will not be counted.

When a new user logs into FineBI, it is necessary to refresh the page before checking the number of current online users in the system.

List Introduction

The Server Usage list introduces that the {user name} accessed the {template name} in the platform at {time} and {location}.

• The detail list displays the report template that is currently being previewed.

• When ordinary users log in to view a template, the access information of the template will be displayed in real time in this detailed list.

• After closing the accessing template, ordinary users refresh the platform, and the access information of the template in the details list will disappear.

Template Access Details

Template Access Details records that the {user name} accessed the {template name} in the system at {time} and {location}. All template access records in the project will be displayed here.

Template Access Details provides a detailed introduction to which directory's reports were accessed, access time, access IP, procedures (how FineBI was accessed, such as pagination preview, FineBI viewing, FineBI editing, Excel page exporting), role (the role of the logged-in username), and username.

Query Methods

Admins can select a certain time period, defaulting to the previous day to the current day.

Click Query to query the details of that time period.

Admins can tick Advanced Query Conditions, choose the content to be queried, and click Query to query details under specific settings.

Note: FineBI allows filtering logs with empty operation users and filtering templates with empty template names.

Exporting Access Details

After the query, the admin can export the log files.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Operation Type

Some operation fields in the log are numbers, and the corresponding log information types are shown in the following table:

Note: Some operation types are followed by , and you can hover the cursor on it to view specific operation information.

User Behavior includes two aspects: Template Business and Login Logout.

Specific user operation information can be obtained and analyzed easily here.

Template Business

Allow viewing the frequency of user visits and operation behaviors within a specified time period, including viewing, exporting, and other operations.

Display access data grouped by users.

You can set date range parameters and user parameters to query the report access status of different users within a specified time period.

Note:

1. If you access via a public link, Operating User is empty.

2. Allow filtering logs with empty usernames.

Click the username hyperlink to jump to the user's operation details page.

After the query, the admin can export the log files.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Login and Logout

JAR has been added the Login Logout function since 2023/02/21.

Login Logout records every login and logout request of the user, ranging from default login, cross-domain login, remote design, third-party, to mobile terminal.

Support user login behavior analysis.

You can filter by Operation Time, Operation Result, Operation User, and Operation Type, making you easy to review the login status of the system.

Query Methods

The default time period is from the previous day to the current day.

Select a specific time period, and click Query to query the login and logout records in that time period.

Select the content to be queried in the checkbox, and click Query to query the login and logout records under specific settings conditions.

Exporting Login and Logout Logs

After the query, the admin can export the log files.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Introduction to Viewing Logs

Login and logout logs are stored in the fine_record_login table in Logdb database, as shown in the following table below.

For details, see LogDB Table Structure.

Support template access analysis so that admins can understand business hotspots. Count the frequency of template access within a specified time period, including viewing, exporting, printing, and other access operations.

The detail list displays in descending order of total operation times. Template Name is displayed as the name configured in the platform, and the path is the path of the template.

1. If you view the template through a non-platform directory (URL of the template or drill-down), Template Name is empty.

2. If the same template is mounted in multiple directories on the platform, it will be counted as multiple records.

If you view the same template through a URL or by drilling down, it will be counted as multiple records for statistics.

Note:

1. Allow filtering templates with empty template names.

2. The view times include the number of times of viewing BI template, editing BI template, and viewing BI public links.

Click the template path hyperlink to display the detailed access information of the template, and the detailed data in chronological order.

After the query, the admin can export the log files.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Support responsive performance analysis of templates to provide reference for admins to optimize the system.

Display the template which completed user requests, the longest response time, the shortest response time, the average time consumption, and the average memory usage.

Set the date parameter and the operation category parameter simultaneously.

Tick Details.

After the query, the admin can export the log files.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Click Query to display log information: Module, Settings, Operation User, Operation IP, Operation Time, Accessed Resources, and Operation Type.

Operation types include:

Tick Advanced Query Conditions.

After the query, the admin can export the log files.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Functions

Click Query to summarize the errors in the use of the statistical template, including: Template Name, Accessed Resources, Error Code, Error Content, Occurrence, Total Visits.

1. If you view the template through a non-platform directory (URL of the template or drill-down), Template Name is empty.

2. If the same template is mounted in multiple directories on the platform, it will be counted as multiple records.

If you view the same template 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 error and query information for the corresponding error category under the corresponding template, including: User Name, Error Details, Query parameter, Error Time, and Template Preview Result.

Note: To avoid redundant error messages, only the first five errors will be recorded during a single visit.

After the query, the admin can export the log files of template error.

Click Export as log to export in .txt format.

Click Export to Excel to export in .xls format.

Note: You can only export 10,000 log data at most.

Template Error Notification

The admin logs into the data decision-making system, clicks Manage > Intelligent Operations > Platform Log, clicks  to go to the Global Setting interface, and enables Error Template Message.

After enabling Error Template Message, the system will check the error templates of the previous day at two am every day.

When there are error templates, the admin can be notified through three forms: SMS Reminder, Platform Message, and Email Reminder.

Note:

1. SMS Reminder: SMS platform needs to be enabled.

2. Email Reminder: Email server needs to be configured.

3. Platform Message: WebSocket port needs to be configured and opened at the load balancing level.