FAQ: About the contents of the operation log (SysLogs table)
## Overview
User operation logs are output to the "「SysLogs Table」" in the database (Implem.Pleasanter). The contents of the output log are as follows.
## About Identifying Users
|Column|Content|
|:---|:---|
|UserHostName|The IP address from which the access originates is recorded, but if the access originates via a proxy, etc., it may be the same IP address. |
|UserHostAddress|Same as above. |
|Creator|If the user is logged in, this indicates the user ID. The user name must be linked to the Users table to confirm. |
|Updator|Same as above. |
## About User Operations
|Column|Content|
|:---|:---|
|Url|The URL requested by the user is recorded. |
|UrlReferer|The URL of the link that the user previously opened is recorded. |
|HttpMethod|The HTTP method sent by the user is recorded. |
|RequestData|The encoded string of the form data sent by the user is recorded. |
## Explanation of Other Columns Are As Follows
|Column|Content|
|:---|:---|
|CreatedTime|The date and time the log was recorded. |
|SysLogId|The unique ID of the log. |
|Ver|The version of the log, but not used. |
## <Log type>
|SysLogType|Log type|
|:---|:---|
|10|Info|
|50|Warning|
|60|UserError|
|80|SystemError|
|90|Execption|
## <Log column>
|Column|Content|
|:---|:---|
|OnAzure|When running on Azure WebApp, 1 is recorded. |
|MachineName|The host name of the Pleasanter web server is recorded. |
|ServiceName|The service name "Implem.Pleasanter" is recorded. |
|TenantName|The tenant name in a multi-tenant environment is recorded. Not applicable in general environments. |
|Application|The project name of the application that is outputting the log. |
|Class|The name of the controller requested by the user is recorded. (This is part of the URL.) |
|Method|The name of the action requested by the user is recorded. (This is part of the URL.) |
|RequestSize|The size of the POSTed data is recorded. |
|ResponseSize|The size of the data returned from the server is recorded. |
|Elapsed|The time (in milliseconds) required for each request on the server side is recorded. |
|ApplicationAge|The time (in milliseconds) elapsed since the application started. |
|ApplicationRequestInterval|The interval (in milliseconds) since the previous request is recorded. |
|SessionAge|The time (in milliseconds) elapsed since the session started. |
|SessionRequestInterval|The interval (in milliseconds) since the previous request of the same session is recorded. |
|WorkingSet64|The amount of physical memory (in bytes) allocated to the process is recorded. |
|VirtualMemorySize64|The amount of virtual memory (in bytes) allocated to the process is recorded. |
|ProcessId|The process ID is recorded. |
|ProcessName|The process name is recorded. |
|BasePriority|The base priority of the process is recorded. |
|UserLanguage|The user's language is recorded. |
|UserAgent|The user's browser is recorded. |
|SessionGuid|The GUID used to identify the session is recorded. |
|ErrMessage|The message when an error occurs is recorded. |
|ErrStackTrace|The stack trace when an error occurs is recorded. |
|IsDebug|When debugging is performed in the development environment, 1 is recorded. |
|AssemblyVersion|The version of Pleasanter is recorded. |
|Comments|If ClientId in "SysLogs.json" is set to true, ClientId is recorded when logging in and out. |
|UpdatedTime|The date and time when the log was updated is recorded. |
## About The Extension Columns
The columns added by the "「System Log Extended Function」" are as follows.
|Column|Content|
|:---|:---|
|Api|If the request is from the API, "1" is recorded, otherwise "0" is recorded. |
|SiteId|Records the "site ID" of the reference. |
|ReferenceId|Records the "site ID" if the reference is a table, or the "record ID" if it is a record. |
|ReferenceType|Records "Sites", "Issues", "Results", or "Wikis" according to the reference type. |
|Status|Records the status code. |
|Description|Records "Class name.method name:line line number:message displayed on screen" in the source code. |
## Related Information
<div id="ManualList">
<article class="s-blog_list_unit"><h2>
<h2>The specified information was not found.</h2>
<p><a href="/ja/manual">Return to top</a></p>
</article>
</div><input id="SearchTextHidden" type="hidden" value="" />