Platform Log

1. Version

2. Feature introduction

The feature of Platform Log is designed to display indicators of the system operation status, aimed to help monitor and analyze the operation conditions of the system.

Including Access Statistics, User Behavior, Template Heat, Performance Monitoring,and Manage Logs.

As shown below:

Access statistics are divided into two aspects: the number of visits and the details of the visits, which can be used to simply analyze the usage rate of the template.

1. System Visits

System Visitsuses a line chart to introduce the number of system visits, the number of templates visited, and the number of active customers. When FineReport is integrated into FineBI, the System Access Times interface is as shown in the figure below:

The administrator can filter the access time by month.

1) Data Sources

The data in System Access Timesis the data in the fine_record_execute table of the filtered LogDB database.

When the Statistical Objectselects Report Template andBI Template, filter out the data in the fine_record_execute table whose type is within the range of the following table to perform the indicator statistics in the chart.

Note 1: Please refer to: LogDB table structure for detailed introduction of fine_record_execute table fields.

Note 2: When the "Statistical Object" selects "Report Template + BI Template", all the data shown in the following table will be filtered out.

Note 3: "Statistical Objects" are counted according to the template name. If the name of a dashboard is changed, it will be divided into two "Statistical Objects" before and after the name change.

2) Calculation logic

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

2. Server usage

1) The current number of online users

• Not connected to Websocket, the current system online number cannot be displayed correctly, user login is not counted in the current system online number, please refer to: WebSocket port is occupied

• Log in to two accounts with the same browser, the latter user information will overwrite the previous user information, and only count as one user.

• You must enter the platform through the login page to be counted as the number of people online in the current system (single sign-on is also applicable). Only access to the template without access to the platform will not be counted.

• When a new user logs in to check the current number of online users in the system, remember to refresh the page and check again.

2) Specific list description

The Server Usage list introduces 'XX user accessed the XX template in the platform at XX time XX location'.

• This detailed list shows the report template currently being previewed.

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

• Ordinary users close the template they are accessing, refresh the platform, and the access information of the template in the detailed list disappears.

3. Template access details

Template Access Details records 'XX user accessed the XX template in the system in XX at XX time and place', and the access records of all templates under the project will be displayed here.

Introduce in detail the time when the report was accessed, the IP accessed, the operation (how to access the report, such as pagination preview, report preview, data analysis, etc.), role (role of the login user name), and user name.

1) Query method

The administrator can select a certain period of time, the default is 'Previous Day' to 'Current Day', click Queryto query the details under that period of time, as shown in the figure below:

The administrator can check theAdvanced Query Conditions, select the content that needs to be queried, and then click Queryto query the details under the specific setting conditions, as shown in the following figure:

Note: The report project from 10.0.18 and later supports the filtering operation of logs with empty users, and the filtering of templates with empty template names.

2) Export access details

After querying, the administrator can export the log file, as shown in the figure below:

• Projects before 10.0.17 support exporting template access details, and only support exporting in .txt format.

• Projects from 10.0.17 and later support export template access details. Click theExport to logbutton to export to .txt format, and clickExport to excelto export to .xls format.

Note: Only 10k log data can be exported at most.

3) Operation type

The log is stored in thefine_record_execute table oflogdb. For details, please refer to: LogDB Table Structure.

The operation field is a number in the log, which corresponds to the report access method. The defined log information types are shown in the following table:

Support to view the user's access frequency and operation behavior within a specified time period, including operations such as viewing and exporting.

Display access data in groups by users, set date interval parameters, user parameters, and customers can query the report access status of different users within a specified time period, as shown in the following figure:

Note: The report project from 10.0.18 and later supports filtering and operating logs with an empty user name.

Click on theuser name hyperlink, click on theuser name, and then jump to the user's operation behavior details, as shown in the following figure:

After querying, the administrator can export the log file, as shown in the figure below:

• For projects before 10.0.17, log export is supported, and only .txt format is supported.

• Projects from 10.0.17 and later support log export. Click theExport to logbutton to export to .txt format, and click Export to excelto export to .xls format.

Note: Only 10k log data can be exported at most.

Support template visit volume analysis, so that administrators can understand business hotspots. Count the frequency of access to templates within a specified time period, including access operations such as viewing, exporting, and printing.

When displayed, it is displayed in descending order of the total number of operations, the template name is displayed with the name configured in the platform, and the path is the path of the template, as shown in the following figure:

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

2) If the same template is mounted in multiple directories on the platform, it will be divided into multiple records for statistics.

     The same template will be divided into multiple records for statistics if viewed through URL or drill-through.

Note: The report project from 10.0.18 and later supports filtering templates with empty template names.

Click thetemplate path hyperlink, after clicking it, the detailed access status of the template will be displayed, and the detailed data will be displayed in chronological order. As shown below:

After querying, the administrator can export the log file, as shown in the figure below:

• For projects before 10.0.17, log export is supported, and only .txt format is supported.

• Projects from 10.0.17 and later support log export. Click theExport to logbutton to export to .txt format, and click Export to excelto export to .xls format.

Note: Only 10k log data can be exported at most.

Support template response performance analysis, provide reference for administrators to optimize the system.

Display templates that have completed user requests, the longest response time, the shortest response time, average time-consuming, and memory usage. Set the date parameters, and set the operation behavior category parameters at the same time, as shown in the figure below:

CheckDetails, the effect is as shown in the figure below:

After querying, the administrator can export the log file, as shown in the figure below:

• For projects before 10.0.17, log export is supported, and only .txt format is supported.

• Projects from 10.0.17 and later support log export. Click theExport to logbutton to export to .txt format, and click Export to excelto export to .xls format.

Note: Only 10k log data can be exported at most.

Same as access statistics, clickQuery to display log information: platform module, platform setting items, operating user, operating IP, operating time, accessed resources, operation type, as shown in the following figure:

The Operation Type is composed of the following:

• Directory - Node/Template/Link/Report Label: Add/Update/Delete

• User -  Global Settings/User/Department/Department-Position/Role/Role-User/PC User/Mobile User: Add/Update/Delete

• Permission - Global Settings/Permission Configuration/Permission Reuse: Add/Update/Delete:

• System - Login/ Genaral/Print/SMS/Mailbox: Enable/Disable/Update

• Backup and Restore - Global Settings/Platform Configuration/Report Template/Jar Package/Plugin/Update and Upgrade:  Enable/Disable/Add/Update/Delete/Restore

• Platform Log - Log Settings/Access Details/User Behavior/Template Heat/Performance Monitoring: Update/ Export

• Memory Management - Intelligent Alert/Memory Session/Intelligent Release/Template Limit/Lifecycle: End/Update

• Data Connection: Add/Update/Delete

• Registration: Update

• Security - SQL Anti-injection: Open/Close/Update

• Task Schedule - Scheduled Task/Global Setting: Add/Update/Delete

• Multi-level escalation-escalation process / Escalation Task: Add/Update/Delete
  

• Mobile Platform - Mobile/APP Splash Screen/Device Binding/QR Code Configuration: Enable/Disable/Update

• Template Authentication - Global Settings/Permission Configuration: Add/Update/Delete

• Remote Design Permission - Permission Setting: Update

• Plug-in management: Install/Delete/Enable/Disable/Update

Check Advanced Query Conditions to view details as follows:

After querying, the administrator can export the log file, as shown in the figure below:

• For projects before 10.0.17, log export is supported, and only .txt format is supported.

• Projects from 10.0.17 and later support log export. Click theExport to logbutton to export to .txt format, and click Export to excelto export to .xls format.

Note: Only 10k log data can be exported at most.