System Logs

Overview

This page provides guidance on how system administrators can use the different types of log files that Appian produces to assess performance, analyze usage, troubleshoot issues, and audit activity.

Monitoring performance and usage

Performance logs are written to the APPIAN_HOME/logs/perflogs directory. These logs are written in CSV files for easy observation and analysis using common spreadsheet tools. The information in them can be used to learn the broad spectrum of what actions take place in the system and how long those actions take to complete.

The log files include one for each Appian engine written to every minute (Engine Performance Logs) and up to three kinds of logs for various events written by the application server which include the following:

• Summary: Enabled by default. Written to once every five minutes and aggregate all the relevant events since the last line was logged into one set of metrics. One line is written per update, even if there were no events in the given interval.
• Details: Enabled by default. Written to once every hour, and while they have similar information to the summary logs, they provide fine-grain aggregation by type of event. Multiple lines are written per update, but if no events occurred in the given interval then nothing is written.
• Trace: Disabled by default. When enabled, updates every time an event occurs with in-depth information about the event in question. Trace logs are disabled by default because they require a greater and less predictable amount of disk space and they contain potentially sensitive human-entered data such as usernames.

Some events have certain phases of their execution separately timed. These "phase times" are parts of the total time, but the total time is not necessarily covered completely by the phase times. Even if an event has measured phases, it may not record a time for that phase. Logs that contain phases have individual counts for each phase to show how many of the total recorded events actually participated.

Data store performance logs

These logs record the operations of querying data in a data store using query rules, writing data via the Write to Data Store Entity Smart Service, and verifying current information in the data store. These three types of data store operations (Query, Write, Verify) can include the following three phases:

• Prepare: Formatting the RDBMS call.
• Execute: Waiting to hear back from the RDBMS.
• Transform: Processing the results received from the RDBMS.

Not all operations involve all three phases. For example, Verify operations do not go through a Transform phase.

In order to aid the identification of slow operations, a separate log file with the same columns records a duplicate entry of only those operations that take more than three seconds to complete. If three seconds is not an appropriate threshold for what qualifies as a slow query, it can be adjusted using the property conf.monitoring.rdbms.SLOW_QUERY_THRESHOLD_MS in custom.properties, which takes an integer value in milliseconds.

Trace file metrics (perf_monitor_rdbms.csv / perf_monitor_rdbms_slow.csv)

Metric	Description
Timestamp	Date and time of the data store operation.
Thread	Identification number of the thread executing the query.
Data Store	Name of the data store against which the operation is being executed.
Entity	Name of the entity being accessed by the operation.
Operation Type	Type of operation being executed.
Operation Name	Query rule name in the case of queries or a short description of the operation type.
Operation Detail	Details about the operation, such as query parameters or paging controls. The content of this field varies according to the operation.
Prepare Time (ms)	Time spent in the Prepare phase.
Execute Time (ms)	Time spent in the Execute phase.
Transform Time (ms)	Time spent in the Transform phase.

Summary file and details file metrics (data_store_summary.csv / data_store_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
[Details Only] Data Store	Name of the data store against which the operation is being executed.
[Details Only] Entity	Name of the entity being accessed by the operation.
[Details Only] Operation Name	Query rule name in the case of queries or a short description of the operation type.
Total Count	Number of operations against data stores.
Mean Total Time (ms)	Average amount of time required for operations from beginning to end.
Query Count	Number of Query operations.
Write Count	Number of Write operations.
Verify Count	Number of Verify operations.
Failure Count	Number of failed operations of any type.
Prepare Count	Number of operations with a prepare phase.
Mean Prepare Time (ms)	Average amount of time taken to complete the Prepare phase.
Execute Count	Number of operations with an Execute phase.
Mean Execute Time (ms)	Average amount of time taken to complete the Execute phase.
Transform Count	Number of operations with a Transform phase.
Mean Transform Time (ms)	Average amount of time taken to complete the Transform phase.
Minimum Total Time (ms)	Shortest time required for any operation from beginning to end.
Maximum Total Time (ms)	Longest time required for any operation from beginning to end.
Minimum Prepare Time (ms)	Shortest time an operation required to complete the Prepare phase.
Maximum Prepare Time (ms)	Longest time an operation required to complete the Prepare phase.
Minimum Execute Time (ms)	Shortest time an operation required to complete the Execute phase.
Maximum Execute Time (ms)	Longest time an operation required to complete the Execute phase.
Minimum Transform Time (ms)	Shortest time an operation required to complete the Transform phase.
Maximum Transform Time (ms)	Longest time an operation required to complete the Transform phase.

Data service trace log

The data service provides a trace log that captures information about the requests made by application server to the data service.

Trace file metrics (ads_call_trace.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Thread Name	Name of the originating thread.
User	The data service user ID of the calling user.
Address	Host and port of the target data service component.
ADS Service	The data service service the request is targeted to (HS, RTS, etc.).
API	The data service API that was called (query, write, etc.).
Store	The target data store in the data service.
Query Target	ID or the UUID of the view or attribute specified as target.
Total Time (ms)	Time taken by the call between request and response.
Status	Specifies whether the call succeeded or failed.
Error Code	Appian error code.
Request JSON length	JSON length of the transaction data sent to the data service.
Response JSON length	JSON length of the results retrieved from the data service.

Design object comparisons (diffs) logs

The Design object comparisons (diffs) performance log (design_object_diffs_details.csv) records information about how object comparisons are performing so that Appian Technical Support can help troubleshoot issues. This log contains quantitative data and does not log any sensitive information.

Engine call logs

These logs contain information about what requests the application server makes to the Appian Engines.

Trace file metrics (engine_call_trace.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Engine	Name of the engine.
Address	Host and port the engine is running on.
Function	Name of the call being tracked.
Username	User who made the call.
Thread Name	Name of the thread the call was made from.
Total Time (ms)	Time required for the call from beginning to end.
Execute Time (ms)	Time the engine spent processing the call.
Other Time (ms)	Time required for the call that was not processing by the engine.

Details file metrics (engine_call_details.csv)

For every time period, there will be one line per type of engine call made.

Metric	Description
Timestamp	Date and time when the metric is taken.
Engine	Name of the engine.
Function	Name of the call being tracked.
Total Count	Total number of calls made to the engine during the time period.
Write Count	Number of write calls made to the engine during the time period.
Read Count	Number of read calls made to the engine during the time period.
Mean Total Time (ms)	Average amount of time required for the calls, from beginning to end.
Mean Execute Time (ms)	Average amount of time the engine spent processing the calls.
Mean Other Time (ms)	Average amount of time required for calls that was not processing by the engine. Includes network delay and time spent queued for the engine to process.
Minimum Total Time (ms)	Shortest time required for any call from beginning to end.
Maximum Total Time (ms)	Longest time required for any call from beginning to end.
Minimum Execute Time (ms)	Shortest time required for the engine to process a call.
Maximum Execute Time (ms)	Longest time required for the engine to process a call.
Minimum Other Time (ms)	Shortest time required for a call that was not processing by the engine.
Maximum Other Time (ms)	Longest time required for a call that was not processing by the engine
Rejected Count	Number of calls that were rejected by the engine or gateway and needed to be retried.

Summary file metrics (engine_call_summary.csv)

For every time period, there will be one line per instance of each engine.

Metric	Description
Timestamp	Date and time when the metric is taken.
Engine	Name of the engine.
Address	Host and port the engine is running on.
Total Count	Total number of calls made to the engine during the time period.
Write Count	Number of write calls made to the engine during the time period.
Read Count	Number of read calls made to the engine during the time period.
Mean Total Time (ms)	Average amount of time required for the calls, from beginning to end.
Mean Execute Time (ms)	Average amount of time the engine spent processing the calls.
Mean Other Time (ms)	Average amount of time required for calls that was not processing by the engine. Includes network delay and time spent queued for the engine to process.
Minimum Total Time (ms)	Shortest time required for any call from beginning to end.
Maximum Total Time (ms)	Longest time required for any call from beginning to end.
Minimum Execute Time (ms)	Shortest time required for the engine to process a call.
Maximum Execute Time (ms)	Longest time required for the engine to process a call.
Minimum Other Time (ms)	Shortest time required for a call that was not processing by the engine.
Maximum Other Time (ms)	Longest time required for a call that was not processing by the engine
Rejected Count	Number of calls that were rejected by the engine or gateway and needed to be retried.

Engine summary log

This file contains information about the status of each engine server. It is written every five minutes to engine_summary.csv, but unlike other summary logs, one line is written for each configured engine. If there is more than one server hosting Appian engines, the log is written only on the server configured first in appian-topology.xml.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Gateway Name	Name of the engine
Gateway ID	ID number of the engine.
Hostname	Name of the host running this engine.
Size on Disk (MB)	Size of the engine data when persisted to disk.
Transaction Count	Number of transactions run since the last checkpoint.
Chain Status	Name of this engine's status
Uptime (s)	Time in seconds since the engine was last started.
Response Time (ms)	Time in milliseconds before the engine responded to the request for status information.
Total Memory Used (MB)	Amount of memory currently used on the engine.

Engine performance logs

These files contain information about the performance of the Appian engines. They are written every minute to files named according to the convention perf_monitor_db_<ENGINE-ACRONYM>_<TIMESTAMP>.csv.

Engine acronyms include:

Engine Acronym	Engine Name
CH1	Channels
CO1	Content
CS1	Content Statistics
DF1	Discussion Forums
NE1	Email Notifications
NO1	Notifications
PA00001	Process Analytics Zero (0000)
PA00011	Process Analytics One (0001)
PA00021	Process Analytics Two (0002)
PD1	Process Design
PE1	Personalization
PO1	Portal
PX001	Process Execution Zero (00)
PX011	Process Execution One (01)
PX021	Process Execution Two (02)

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
CPU Idle Time (%)	Percentage of the past monitoring period that the CPU was idle.
CPU Foreground Time (%)	Percentage of the past monitoring period that the CPU was processing foreground activities.
CPU Background Time (%)	Percentage of the past monitoring period that the CPU was processing background activities.
Work Queue - Finished	Number of items that were processed from the Java Work Queue in the last sample period.
Work Queue - Java Work Queue Size	Size of the Java Work Queue, which contains items to be processed by the application server in the foreground.
Event Received	Number of messages received in the last sample period. These may be JMS messages, email, or process-to-process messages. After these messages are processed, they are sent to Event Consumers Received.
Event Consumers Received	Number of times receive message events were the target of messages in the last monitoring sample period. Event targets and messages are multiplied to calculate the total number of events. For example, when three messages are received (Event Received) by two receive message events in three process instances, the total number of event Consumers Received is 18 (323).
Work Queue - Event Consumers to Process	Number of receive message events waiting to be processed.

Process execution logs

These files contain information about the performance of processes on the Appian engines. The data is measured and written in batches, every 5 minutes, to files named according to the convention top_models_by_time_<ENGINE-ACRONYM>_<TIMESTAMP>.csv and top_processes_by_time_<ENGINE-ACRONYM>_<TIMESTAMP>.csv, where the engine acronyms follow the same convention as the engine performance logs above. These logs can provide additional insight into process resource usage and are best used in conjunction with the perf_monitor_db logs.

For example, you can use the perf_monitor_db log to determine when there may be a timeframe that the CPU idle time % dips to an undesirable level. Both the top_models_by_time and top_processes_by_time logs can then be used to determine which processes or models consumed the most resources during this same timeframe. The models or processes with high "Percent of Interval (%)" values in this specific measured interval are the most resource intensive processes, indicating potential room for design adjustments.

Top Models (top_models_by_time.csv)

Metrics include the following:

Metric	Description
Ordinal	The position of a process model within each batch interval. The first ordinal number in each batch represents the process model which took the most amount of time in the batch.
Timestamp	Date and time at which each batch interval started. Each batch interval is 5 minutes.
Process Model Id	The ID of the associated process model
Operation Count	An approximation for the number of discrete operations carried out by the process model during the batch interval
Measured Time (ms)	For a batch interval, the amount of CPU time consumed by the process model
Percent of Interval (%)	For a batch interval, the amount of CPU time consumed by the process model compared to the total 5 minute batch interval, expressed as a percentage
Percent of All Measurements in Interval (%)	For a batch interval, the amount of CPU time consumed by the process model compared to the total CPU measured time of all of the process models during that interval, expressed as a percentage.

Top Processes (top_processes_by_time.csv)

Metrics include the following:

Metric	Description
Ordinal	The position of a process within each batch interval. The first ordinal number in each batch represents the process which took the most amount of time in the batch.
Timestamp	Date and time at which each batch interval started. Each batch interval is 5 minutes.
Process Id	The ID of the associated process
Process Model Id	The ID of the process model for the associated process
Operation Count	An approximation for the number of discrete operations carried out by the process during the batch interval
Measured Time (ms)	For a batch interval, the amount of CPU time consumed by the process
Percent of Interval (%)	For a batch interval, the amount of CPU time consumed by the process compared to the total 5 minute batch interval, expressed as a percentage
Percent of All Measurements in Interval (%)	For a batch interval, the amount of CPU time consumed by the process compared to the total CPU measured time of all of the processes during that interval, expressed as a percentage.

Execution by category logs

These files contain information around background timers of the Appian engines, which are not specific to process models or processes. They are written every 5 minutes to files named according to the convention execution_by_category_<ENGINE-ACRONYM>_<TIMESTAMP>.csv, where the engine acronyms follow the same convention as the engine performance logs above. Metrics include the following:

Metric	Description
Ordinal	The position of an object within each batch interval. The first ordinal number in each batch represents the object which took the most amount of time in the batch.
Timestamp	Date and time at which each batch interval started. Each batch interval is 5 minutes.
Category Name	The specific background timer. Possible values include: Activity Chain Timeout, Archive Process Check, Engine Pings, Inactive Process Check, Load Metric Updates, MNI Spawning, Model Cleanup, Node Execution, Node Execution Queue, Process Messaging, Process Messaging Producers, Rule Events, Running Web Service Timeouts, Submitted Web Service Timeouts, Timer Events
Operation Count	An approximation for the number of discrete operations carried out by the object during the batch interval
Measured Time (ms)	For a batch interval, the amount of CPU time consumed by the object
Percent of Interval (%)	For a batch interval, the amount of CPU time consumed by the object compared to the total 5 minute batch interval, expressed as a percentage
Percent of All Measurements in Interval (%)	For a batch interval, the amount of CPU time consumed by the object compared to the total CPU measured time of all of the objects during that interval, expressed as a percentage.

Expressions performance logs

These log files provide performance measurements on the building blocks of Appian expressions: functions and rules.

Rules can contain both functions and/or other rules. In such cases, the measured time of the main rule will include that of any nested rules and/or functions.

The trace and summary logs measure the usage of Appian functions, rules, and custom plug-in functions together to make it easier to debug issues or check the health of your overall system. However, Appian functions are measured in a separate details log from rules and custom plug-in functions to make it easier to distinguish between the usage of your objects and Appian functions.

Trace file metrics (expressions_trace.csv)

Metric	Description
Timestamp	Date and time of the expression evaluation.
Name	Name of the function or rule.
Type	"Appian Function", "Function" (custom plug-in), "Smart Service", or "Rule" (anything referenced using rule!). For smart service functions, time measurements only include the time spent evaluating the expression and do not include executing the smart service.
Total Time (ms)	Total time evaluating the function or rule including the time to evaluate its inputs.
User	UUID of user who invoked the function or rule.
Thread	ID of the thread the function or rule was evaluated on.
Individual Time (ms)	Total time evaluating the function or rule excluding the time to evaluate its inputs. For example, given that rule!getDistinctItems(items: rule!getAllItems()) has a Total Time of 100ms and rule!getAllItems has a Total Time of 80ms, then rule!getDistinctItems has an Individual Time of 20ms.
Called By Rule	Name of the rule that called the object specified in Name. This value will be blank for top-level rules and internal functions.

Summary file metrics (expressions_summary.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Function Count	Number of functions evaluated.
Mean Function Time (ms)	Average time spent evaluating functions.
Rule Count	Number of rules evaluated.
Mean Rule Time (ms)	Average time spent evaluating rules.
Minimum Function Time (ms)	Shortest time required to evaluate a single function.
Maximum Function Time (ms)	Longest time required to evaluate a single function.
Minimum Rule Time (ms)	Shortest time required to evaluate a single rule.
Maximum Rule Time (ms)	Longest time required to evaluate a single rule.

Rule and Plug-in Function details file metrics (expressions_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Name	Name of the function or rule.
Type	"Function" (custom plug-in) or "Rule" (anything referenced using rule!).
Total Count	Number of invocations of this function or rule.
Mean Total Time (ms)	Average amount of time required to evaluate this function or rule.
Minimum Total Time (ms)	Smallest amount of time required to evaluate this function or rule.
Maximum Total Time (ms)	Longest amount of time required to evaluate this function or rule.

Appian Function details file metrics (appian_functions_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Name	Name of the function or rule.
Type	"Appian Function" or "Smart Service". For smart service functions, time measurements only include the time spent evaluating the expression and do not include executing the smart service.
Total Count	Number of invocations of this function or smart service.
Mean Total Time (ms)	Average amount of time required to evaluate this function or smart service.
Minimum Total Time (ms)	Smallest amount of time required to evaluate this function or smart service.
Maximum Total Time (ms)	Longest amount of time required to evaluate this function or smart service.

Slow Plug-in Function metrics (plugin_functions_slow.csv)

This log displays all plug-in functions that take longer than 5 seconds to complete or have a result size over 100,000 AMUs. Plug-in functions that show up in this log should be investigated to determine if the performance is expected or can be improved. Long running plug-in functions can correlate with high memory usage which causes a site's overall performance to degrade.

Metric	Description
Timestamp	Date and time when the metric is taken.
User UUID	UUID of user who invoked the plug-in function.
Function	Name of the plug-in function.
Evaluation Type	The type of object that contains the expression. Possible values: record list, record view, report, start form, task form, related action (process start), related action (quick task), process node, web API, internal, interface designer.
Object UUID	The UUID of the design object where the plug-in was evaluated. You can search for objects by UUID in Appian Designer.
Record Instance ID	For evaluation types of record view, the record identifier (rv!identifier).
Record View URL Stub	For evaluation types of record view, the record view URL stub.
Process Instance ID	For evaluation types of start form, task form, related action, or process node, the process instance's ID (pp!id).
Task ID	For evaluation types of task form, the task's ID (tp!id).
Total Time (ms)	Total time spent evaluating the plug-in function.
Result Size	Size of the value returned by the plug-in function measured in AMUs. Large result sizes can have an impact on memory usage and should be investigated to determine if such a large result is expected or needed. However, a plug-in can still use a large amount of memory even if the result size is small. For example, a plug-in function that searches all document folders for a single file can use a lot of memory even if the result size is small.

Integration performance logs

These log files provide data on integration performance.

Trace file metrics (integration_trace.csv)

Integration trace logging can be enabled and disabled via the Admin Console.

Metric	Description
Timestamp	Timestamp at which the entry was logged
Integration UUID	The UUID of the integration
Success	Did the integration result in an error?
Timeout	Did the integration time out?
Username	The username of the user who executed the integration
Operation/Method	For HTTP integrations: the Method name. For SDK integrations: the Operation name.
Total Time (ms)	The total time for the integration execution
Prepare Time (ms)	The prepare time for the integration execution
Execute time (ms)	The execute time for the HTTP integration execution
Transform Time (ms)	The transform time for the integration execution
Connected System UUID	The UUID of the connected system at runtime (if one was used)
Process ID	If the integration was called as part of a process (whether or not the direct precedent is a process model), this is the process id. It will be null if it’s not called from a process model.
Status Code	The status code returned by the integration. Only populated for integrations that use an HTTP connected system, an OpenAPI connected system, or no connected system.

Summary file metrics (integration_summary.csv)

Metric	Description
Timestamp	Timestamp at which the entry was logged
Total count	Number of executions across all integrations per interval
Failure count	Number of failures across all integrations per interval
Timeout count	Number of timeouts across all integrations per interval
Mean Total Time (ms)	Mean total time across all integrations per interval
Minimum Total Time (ms)	Minimum total time across all integrations per interval
Maximum Total Time (ms)	Maximum total time across all integrations per interval
Mean Prepare	Mean total prepare across all integrations per interval
Minimum Prepare Time (ms)	Minimum prepare time across all integrations per interval
Maximum Prepare Time (ms)	Maximum prepare time across all integrations per interval
Mean Execute Time (ms)	Mean execute time across all integrations per interval
Minimum Execute Time (ms)	Minimum execute time across all integrations per interval
Maximum Execute Time (ms)	Maximum execute time across all integrations per interval
Mean Transform Time (ms)	Mean transform time across all integrations per interval
Minimum Transform Time (ms)	Minimum transform time across all integrations per interval
Maximum Transform Time (ms)	Maximum transform time across all integrations per interval

Details file metrics (integration_details.csv)

Metric	Description
Timestamp	The timestamp at which the entry was logged
Integration UUID	The UUID of the integration
Operation/Method	The Method name
Connected System UUID	The UUID of the connected system on the integration
Connected System Type Name	The name of the Connected System Type (such as Amazon Machine Learning)
Total Count	Number of times the integration was executed per interval
Failure Count	Number of times the integration failed per interval. This includes timeouts, which will be double counted.
Timeout Count	Number of times the integration timed out per interval
Mean Total Time (ms)	The mean total time for the integration per interval
Min Total Time (ms)	The shortest total time the integration took per interval
Max Total Time (ms)	The longest total time the integration took per interval
Mean Prepare Time (ms)	The mean prepare time for the integration per interval
Min Prepare Time (ms)	The shortest prepare time the integration took per interval
Max Prepare Time (ms)	The longest prepare time the integration took per interval
Mean Execute Time (ms)	The mean execute time for the integration per interval
Min Execute Time (ms)	The shortest execute time the integration took per interval
Max Execute Time (ms)	The longest execute time the integration took per interval
Mean Transform Time (ms)	The mean transform time for the integration per interval
Min Transform Time (ms)	The shortest total time the integration took per interval
Max Transform Time (ms)	The longest total time the integration took per interval

Interface performance logs

These log files provide performance measurements on interfaces, including record and report dashboards and start and task forms.

Trace file metrics (sail_trace.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Interface Type	The type of interface being accessed. Possible values: record dashboard, report dashboard, start form, task form, related action (process start), related action (quick task), internal.
Client	The client used to access the interface. Possible values: web, ios, android.
Evaluation Type	The type of interface interaction. Possible values: initial load, re-evaluation, save, submission.
Username	Username of the user who accessed the interface.
Server Evaluation Time (ms)	Time spent on the server evaluating the interface.
Context Size (bytes)	Amount of data in the server context.
Interface Size (bytes)	Size of the interface.
Component Count	Number of components visible in the interface.
Record Type	For record dashboards and related actions, the urlstub of the record type.
Record ID	For record dashboards, the ID of the associated record type.
Record Dashboard ID	For record dashboards, the urlstub of the dashboard.
Report ID	For report dashboards, the urlstub of the report.
Process Model ID	For start forms and non-quick task related actions, the ID of the associated process model.
Process ID	For start forms and quick task related actions, the ID of the associated process instance.
Task ID	For task forms, the ID of the associated task.
Internal ID	For internal interfaces, the identifier for the associated interface.
UI State Database Update Time	Time spent storing mobile client interface state in the Appian data source. This is always blank for web client requests.
UI State Database Fetch Time	Time spent retrieving mobile client interface state from the Appian data source. This is always blank for web client requests.
UI State Compression Time (ms)	Time spent compressing the interface context.
UI State Encryption Time (ms)	Time spent encrypting the interface context for transmission to the client.
Evaluation Initiator	Indicates whether the evaluation was initiated by a user or a refresh interval. Because requests can be batched together, a single evaluation can sometimes contain both user-initiated and interval-initiated requests, which is logged as "multiple".

Summary file metrics (sail_summary.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Evaluations	Number of interface evaluations in the time interval.
Web Client Evaluations	Number of interface evaluations by web clients in the time interval.
Android Evaluations	Number of interface evaluations by Android clients in the time interval.
Android Offline Evaluations	Number of evaluations in an offline interface by Android clients in the time interval.
iOS Evaluations	Number of interface evaluations by iOS clients in the time interval.
iOS Offline Evaluations	Number of evaluations in an offline interface by iOS clients in the time interval.
Mean Total Evaluation Time (ms)	Average amount of server time spent evaluating an interface.
Minimum Total Evaluation Time (ms)	Minimum amount of server time spent evaluating an interface.
Maximum Total Evaluation Time (ms)	Maximum amount of server time spent evaluating an interface.
Mean Context Size (bytes)	Average size of the server context for an interface.
Minimum Context Size (bytes)	Smallest server context for an interface.
Maximum Context Size (bytes)	Largest server context for an interface.
Mean Interface Size (bytes)	Average size of the interface.
Minimum Interface Size (bytes)	Smallest interface size.
Maximum Interface Size (bytes)	Largest interface size.
Mean Component Count	Average number of visible components in an interface.
Minimum Component Count	Smallest number of visible components in an interface.
Maximum Component Count	Largest number of visible components in an interface.
Total Record Dashboard Evaluations	Number of record dashboards accessed in the time interval, including reevaluations.
Total Record Dashboard Initial Loads	Number of record dashboards accessed in the time interval, not including reevaluations.
Total Report Dashboard Evaluations	Total number of report dashboards accessed in the time interval, including reevaluations.
Total Report Dashboard Initial Loads	Number of report dashboards accessed in the time interval, not including reevaluations.
Total Start Form Evaluations	Number of start forms accessed in the time interval, including reevaluations and submissions.
Total Start Form Initial Loads	Number of start forms accessed in the time interval, not including reevaluations or submissions.
Total Start Form Submissions	Number of start forms submitted in the time interval.
Total Task Form Evaluations	Number of task forms accessed in the time interval, including reevaluations, saves, and submissions.
Total Task Form Initial Loads	Number of task forms accessed in the time interval, not including reevaluations, saves, and submissions.
Total Task Form Submissions	Number of task forms submitted in the time interval.
Mean UI State Database Update Time	Average time spent storing mobile client interface state in the Appian data source.
Minimum UI State Database Update Time	Shortest time spent storing mobile client interface state in the Appian data source.
Maximum UI State Database Update Time	Longest time spent storing mobile client interface state in the Appian data source.
Mean UI State Database Fetch Time	Average time spent retrieving mobile client interface state from the Appian data source.
Minimum UI State Database Fetch Time	Shortest time spent retrieving mobile client interface state from the Appian data source.
Maximum UI State Database Fetch Time	Longest time spent retrieving mobile client interface state from the Appian data source.
Mean UI State Compression Time (ms)	Average time spent compressing the interface state.
Minimum UI State Compression Time (ms)	Shortest time spent compressing the interface state.
Maximum UI State Compression Time (ms)	Longest time spent compressing the interface state.
Mean UI State Encryption Time (ms)	Average time spent encrypting the interface state for transmission to the client.
Minimum UI State Encryption Time (ms)	Shortest time spent encrypting the interface state for transmission to the client.
Maximum UI State Encryption Time (ms)	Longest time spent encrypting the interface state for transmission to the client.
Evaluations With Stateful Context	Number of evaluations that kept the context on the server and did not transmit it to the client.
Evaluations With Stateless Context	Number of evaluations that transmitted an encrypted context to the client instead of storing it on the server.
Total Action Form Cache Count	Number of action form cache requests.
Scheduled Action Form Cache Count	Number of action forms cached for offline use without direct user action.
Foreground Action Form Cache Count	Number of action forms cached for offline use because a user viewed the action list.
Requested Action Form Cache Count	Number of action forms cached for offline use because a user viewed the action.
Mean Action Form Cache Evaluation Time (ms)	Average time spent evaluating action forms for caching purposes.
Minimum Action Form Cache Evaluation Time (ms)	Shortest time spent evaluating action forms for caching purposes.
Maximum Action Form Cache Evaluation Time (ms)	Longest time spent evaluating action forms for caching purposes.
Mean Action Form Cache Size (bytes)	Average size of a cached action form in bytes.
Minimum Action Form Cache Size (bytes)	Smallest size of a cached action form in bytes.
Maximum Action Form Cache Size (bytes)	Largest size of a cached action form in bytes.
Offline Submissions Attempted	Number of submissions attempted while offline.
Offline Submissions Succeeded	Number of offline submissions that completed successfully.
Offline Submission Validation Failures	Number of offline submissions that failed due to form validation.
Offline Submission Form Mismatch Failures	Number of offline submissions that failed because the form had been updated.
Mean Offline Submissions Evaluation Time (ms)	Average time spent evaluating offline submissions.
Minimum Offline Submissions Evaluation Time (ms)	Shortest time spent evaluating offline submissions.
Maximum Offline Submissions Evaluation Time (ms)	Longest time spent evaluating offline submissions.
Mean Offline Submissions Size (bytes)	Average size of offline form submissions in bytes.
Minimum Offline Submissions Size (bytes)	Smallest size of offline form submissions in bytes.
Maximum Offline Submissions Size (bytes)	Largest size of offline form submissions in bytes.
Interval Evaluations	Total number of interface evaluations triggered by a refresh interval during the time period, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Mean Total Evaluation Time for Interval Evaluations (ms)	Average amount of server time spent evaluating an interface when the evaluation is triggered by a refresh interval, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Minimum Total Evaluation Time for Interval Evaluations (ms)	Minimum amount of server time spent evaluating an interface when the evaluation is triggered by a refresh interval, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Maximum Total Evaluation Time for Interval Evaluations (ms)	Maximum amount of server time spent evaluating an interface when the evaluation is triggered by a refresh interval, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Total Interval Record Dashboard Evaluations	Number of record dashboards evaluations triggered by a refresh interval during the time period, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Total Interval Report Evaluations	Number of report evaluations triggered by a refresh interval during the time period, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Total Interval Start Form Evaluations	Number of start form evaluations triggered by a refresh interval during the time period, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Total Interval Task Form Evaluations	Number of start form evaluations triggered by a refresh interval during the time period, excluding any evaluations that contained both user-initiated and interval-initiated requests.

Details file metrics (sail_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Interface Type	The type of this interface. Possible values: record dashboard, report dashboard, start form, task form, related action (process start), related action (quick task), internal.
Total Evaluations	Number of evaluations of this interface during the time interval.
Web Client Evaluations	Number of evaluations of this interface during by web clients during the time interval.
iOS Evaluations	Number of evaluations of this interface during by iOS clients during the time interval.
Android Evaluations	Number of evaluations of this interface during by Android clients during the time interval.
Initial Loads	Number of initial evaluations of this interface.
Saves	Number of saves of this interface (only task forms can be saved).
Submissions	Number of submissions from this interface (only start and task forms can be submitted).
Mean Total Evaluation Time (ms)	Average amount of server time spent evaluating this interface.
Minimum Total Evaluation Time (ms)	Minimum amount of server time spent evaluating this interface.
Maximum Total Evaluation Time (ms)	Maximum amount of server time spent evaluating this interface.
Mean Context Size (bytes)	Average server context size for this interface.
Minimum Context Size (bytes)	Smallest server context for this interface.
Maximum Context Size (bytes)	Largest server context for this interface.
Mean Interface Size (bytes)	Average size of this interface.
Minimum Interface Size (bytes)	Smallest recorded interface size.
Maximum Interface Size (bytes)	Largest recorded interface size.
Mean Component Count	Average number of visible components in this interface.
Minimum Component Count	Largest number of visible components in this interface.
Maximum Component Count	Smallest number of visible components in this interface.
Record Type	For record dashboards and related actions, the urlstub of the record type.
Record ID	For record dashboards, the ID of the associated record type.
Record Dashboard ID	For record dashboards, the urlstub of the dashboard.
Report ID	For report dashboards, the urlstub of the report.
Process Model ID	For start forms and non-quick task related actions, the ID of the associated process model.
Process ID	For start forms and quick task related actions, the ID of the associated process instance.
Task ID	For task forms, the ID of the associated task.
Internal ID	For internal interfaces, the identifier for the associated interface.
Mean UI State Database Update Time	Average time spent storing mobile client state for this interface in the Appian data source.
Minimum UI State Database Update Time	Shortest time spent storing mobile client state for this interface in the Appian data source.
Maximum UI State Database Update Time	Longest time spent storing mobile client state for this interface in the Appian data source.
Mean UI State Database Fetch Time	Average time spent retrieving mobile client state for this interface from the Appian data source.
Minimum UI State Database Fetch Time	Shortest time spent retrieving mobile client state for this interface from the Appian data source.
Maximum UI State Database Fetch Time	Longest time spent retrieving mobile client state for this interface from the Appian data source.
Mean UI State Compression Time (ms)	Average time spent compressing this interface's state.
Minimum UI State Compression Time (ms)	Shortest time spent compressing this interface's state.
Maximum UI State Compression Time (ms)	Longest time spent compressing this interface's state.
Mean UI State Encryption Time (ms)	Average time spent encrypting this interface's state for transmission to the client.
Minimum UI State Encryption Time (ms)	Shortest time spent encrypting this interface's state for transmission to the client.
Maximum UI State Encryption Time (ms)	Longest time spent encrypting this interface's state for transmission to the client.
Evaluations With Stateful Context	Number of this interface's evaluations that kept the context on the server and did not transmit it to the client.
Evaluations With Stateless Context	Number of this interface's evaluations that transmitted an encrypted context to the client instead of storing it on the server.
Total Action Form Cache Count	Number of times this interface was cached for offline use.
Scheduled Action Form Cache Count	Number of times this interface was cached not in response to a user action.
Foreground Action Form Cache Count	Number of times this interface was cached in response to user action.
Requested Action Form Cache Count	Number of action forms cached for offline use.
Mean Action Form Cache Evaluation Time (ms)	Average time spent evaluating action forms for caching purposes.
Minimum Action Form Cache Evaluation Time (ms)	Shortest time spent evaluating action forms for caching purposes.
Maximum Action Form Cache Evaluation Time (ms)	Longest time spent evaluating action forms for caching purposes.
Mean Action Form Cache Size (bytes)	Average size of a cached action form.
Minimum Action Form Cache Size (bytes)	Smallest size of a cached action form.
Maximum Action Form Cache Size (bytes)	Largest size of a cached action form.
Offline Submissions Attempted	Number of submissions attempted while offline.
Offline Submissions Succeeded	Number of offline submissions that completed successfully.
Offline Submission Validation Failures	Number of offline submissions that failed due to form validation.
Offline Submission Form Mismatch Failures	Number of offline submissions that failed because the form had been updated.
Mean Offline Submissions Evaluation Time (ms)	Average time spent evaluating offline submissions.
Minimum Offline Submissions Evaluation Time (ms)	Shortest time spent evaluating offline submissions.
Maximum Offline Submissions Evaluation Time (ms)	Longest time spent evaluating offline submissions.
Mean Offline Submissions Size (bytes)	Average size of offline form submissions.
Minimum Offline Submissions Size (bytes)	Smallest size of offline form submissions.
Maximum Offline Submissions Size (bytes)	Largest size of offline form submissions.
Interval Evaluations	Total number of evaluations of this interface triggered by a refresh interval during the time period, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Mean Total Evaluation Time for Interval Evaluations (ms)	Average amount of server time spent evaluating this interface when the evaluation is triggered by a refresh interval, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Minimum Total Evaluation Time for Interval Evaluations (ms)	Minimum amount of server time spent evaluating this interface when the evaluation is triggered by a refresh interval, excluding any evaluations that contained both user-initiated and interval-initiated requests.
Maximum Total Evaluation Time for Interval Evaluations (ms)	Maximum amount of server time spent evaluating this interface when the evaluation is triggered by a refresh interval, excluding any evaluations that contained both user-initiated and interval-initiated requests.

Offline mobile performance logs

These log files provide measurements on offline mobile performance.

Trace file metrics (offline_trace.csv)

Metric	Description
Timestamp	Date and time of an action list request.
Evaluation Time (ms)	Time spent refreshing the action list and actions.
Total Action Count	Total number of actions in the action list.
Offline Action Count	Number of offline actions in the action list.
Response Size (bytes)	Size of the action list request response.
Time Since Last Action List Request (min)	Time since the action list was last requested.
Interaction Type	The client's reason for making the request. Possible values: Scheduled (requested without direct user action), Foreground (user opened the app), Requested (user refreshed their action list).

Summary file metrics (offline_summary.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Action List Request Count	Number of action list requests.
Scheduled Action List Request Count	Number of action list requests for offline use without direct user action.
Foreground Action List Request Count	Number of action list requests for offline use because a user opened the app.
Requested Action Form Cache Count	Number of action list requests for offline use because a user refreshed their action list.
Mean Action List Request Time (ms)	Average time spent refreshing the action list and actions.
Minimum Action List Request Time (ms)	Shortest time spent refreshing the action list and actions.
Maximum Action List Request Time (ms)	Longest time spent refreshing the action list and actions.
Mean Total Actions	Average total number of actions in the action list.
Minimum Total Actions	Smallest total number of actions in the action list.
Maximum Total Actions	Largest total number of actions in the action list.
Mean Offline Actions	Average number of offline actions in the action list.
Minimum Offline Actions	Smallest number of offline actions in the action list.
Maximum Offline Actions	Largest number of offline actions in the action list.
Mean Action List Request Response Size (bytes)	Average size of an action list request response.
Minimum Action List Request Response Size (bytes)	Smallest size of an action list request response.
Maximum Action List Request Response Size (bytes)	Largest size of an action list request response.
Mean Time Since Last Action List Request (min)	Average time since the action list was last requested.
Minimum Time Since Last Action List Request (min)	Shortest time since the action list was last requested.
Maximum Time Since Last Action List Request (min)	Longest time since the action list was last requested.

Portals latency, traffic, and error rate metric logs

These logs capture the number of requests, number of errors, and request latency for each portal published in a given environment. They are located in the APPIAN_HOME/logs/perflogs/portals/ subdirectory. This information can also be viewed in the Portal Monitoring tab in the Monitor view.

Summary file metrics (portal_summary_portalname_date.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Request Count	Number of requests to the portal.
Error Count	Number of requests that resulted in an error.
Median Latency	Median latency value.
90th Percentile Latency	Slowest response time of the fastest 90 percent of requests.
99th Percentile Latency	Slowest response time of the fastest 99 percent of requests.

Portals rule performance details logs

These logs capture the performance details for every rule and interface within any published portal in an environment. They are located in the APPIAN_HOME/logs/perflogs/portals/ subdirectory.

Summary file metrics (portal_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Rule Name	Name of the rule or interface.
Total Count	Includes one count per load and one count per interaction for the rule or interface.
Mean Total Time (ms)	Mean total time to execute. The measured time for any rule or interface will include that of any nested rules or interfaces.
Minimum Total Time (ms)	Fastest total time to execute. The measured time for any rule or interface will include that of any nested rules or interfaces.
Maximum Total Time (ms)	Slowest total time to execute. The measured time for any rule or interface will include that of any nested rules or interfaces.

REST API performance logs

These logs report information on Appian's REST API, which powers both Appian's web interface as well as the mobile clients.

Requests are broken into five phases:

1. Prepare - Time spent preparing to make a data source lookup. This phase may also involve secondary lookups.
2. Query - Time spent querying the main data source involved in processing the REST API call in question.
3. Render - Time spent post-processing the returned data and preparing it to display.
4. Task Fetch - Time spent retrieving task information related to the REST API call results.
5. User Fetch - Time spent pulling information about users related to the REST API call results.

Trace file metrics (rest_trace.csv)

Metric	Description
Timestamp	Date and time of the API call.
Thread	Identification number of the querying thread.
Operation Type	Type of the requested operation.
Operation Name	Possible values are "get feed", "add entry", and "add comment".
Operation Detail	Other information about the operation including the username making the request as well as the query string.
Prepare Time (ms)	Time spent in the Prepare phase of the request.
Execute Time (ms)	Time spent in the Execute phase of the request.
Render Time (ms)	Time spent in the Render phase of the request.
Task Fetch Time (ms)	Time spent in the Task Fetch phase of the request.
User Fetch Time (ms)	Time spent in the User Fetch phase of the request.
Other App Server Time (ms)	Time spent outside of the five phases.

Summary file and details file metrics (rest_summary.csv / rest_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
[Details only] API Call	URI of the request. To ensure aggregation of functionally identical but slightly dissimilar URIs, all numbers are changed to 0 before being grouped. Additionally, usernames and search queries are filtered out.
Total Count	Number of calls.
Mean Total Time (ms)	Average time spent responding to a call.
Prepare Phase Count	Number of calls with a Prepare phase.
Prepare Phase Mean Total Time (ms)	Average time each call spent in the Prepare phase.
Execute Phase Count	Number of calls with an Execute phase.
Execute Phase Mean Total Time (ms)	Average time each call spent in the Execute phase.
Render Phase Count	Number of calls with a Render phase.
Render Phase Mean Total Time (ms)	Average time each call spent in the Render phase.
Task Fetch Phase Count	Number of calls with a Task Fetch phase.
Task Fetch Phase Mean Total Time (ms)	Average time each call spent in the Task Fetch phase.
User Fetch Phase Count	Number of calls with a User Fetch phase.
User Fetch Phase Mean Total Time (ms)	Average time each call spent in the User Fetch phase.
Read Count	Number of calls that merely accessed data.
Write Count	Number of calls that modified data.
[Details only] Web Count	Number of calls made from the web interface.
[Details only] iOS Count	Number of calls made from the iOS mobile client.
[Details only] Android Count	Number of calls made from the Android mobile client.
Min Total Time (ms)	Minimum time spent responding to a call.
Max Total Time (ms)	Maximum time spent responding to a call.
Prepare Phase Min Time (ms)	Minimum time spent responding in a call's Prepare phase.
Prepare Phase Max Time (ms)	Maximum time spent responding in a call's Prepare phase.
Execute Phase Min Time (ms)	Minimum time spent responding in a call's Execute phase.
Execute Phase Max Time (ms)	Maximum time spent responding in a call's Execute phase.
Render Phase Min Time (ms)	Minimum time spent responding in a call's Render phase.
Render Phase Max Time (ms)	Maximum time spent responding in a call's Render phase.
Task Fetch Phase Min Time (ms)	Minimum time spent responding in a call's Task Fetch phase.
Task Fetch Phase Max Time (ms)	Maximum time spent responding in a call's Task Fetch phase.
User Fetch Phase Min Time (ms)	Minimum time spent responding in a call's User Fetch phase.
User Fetch Phase Max Time (ms)	Maximum time spent responding in a call's User Fetch phase.

Report performance logs

These files provide performance measurements on reporting functionality executed through the Designer Interface. They can include the following three phases:

• Query - Waiting to hear back from the RDBMS.
• Group - Organizing the results by columns.
• Sort - Applying the sort configurations.
• Merge - Combining the results from each Appian Engine into a single result.

Not all operations involve all three phases. For example, Verify operations do not go through a Transform phase.

Tracing file metrics (reporting_trace.csv)

Metric	Description
Timestamp	Date and time of the report execution.
.ARF Document ID	ID number of the report's definition file.
Report Type	Origin of the report. Possible values include "Process Model", "Process Model Version", "Process", and "Task".
Context Type	Context used by this report. Possible values include
Valid Report Returned	Indicates if the report executed and returned results without an error. True if the report returned successfully, otherwise false.
Returned Within Maximum Allowed Time	Indicates if the report returned results in the defined time frame. True if the report did not time out, otherwise false.
Returned Rows	Number of rows returned for display.
Available Rows	Number of rows available to display data on each page of the report.
Total Time	Total time it took to execute the report.
Query Time	Time spent querying the analytics engines.
Grouping Time	Time spent performing aggregations on report data.
Sorting Time	Time spent sorting the report's results.
Merge Time	Time spent merging results from different analytics engines.

Summary file and detailed file metrics (reporting_summary.csv / reporting_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
[Details only] Report Name	Full name associated with this report.
[Details only] .arf Content ID	ID number of the report's definition file.
Total Count	Number of reports executed in the time interval.
Mean total Execution Time	Average amount of time spent executing each report.
Mean Returned Rows	Average number of rows returned for display.
Mean Available Rows	Average number of rows available to display data on each page of the report.
Invalid Count	Number of reports that did not complete successfully (including timeouts).
Timed Out Count	Number of reports that timed out.
Query Phase Count	Number of reports that measured a Query phase.
Mean Query Time	Average amount of time spent in the Query phase.
Group Phase Count	Number of reports that measured a Group phase.
Mean Grouping Time	Average amount of time spent in the Group phase.
Sort phase Count	Number of reports that measured a Sort phase.
Mean Sorting Time	Average amount of time spent in the Sort phase.
Merge Phase Time	Number of reports that measured a Merge phase.
Mean Merging Time	Average amount of time spent in the Merge phase.
Process Model Report Count	Number of process model reports executed in the time interval.
Process Model Version Report Count	Number of process model version reports executed in the time interval.
Process Report Count	Number of process reports executed in the time interval.
Task Report Count	Number of task reports executed in the time interval.
System Context Count	Number of reports executed using a system context.
Process Model Context Count	Number of reports on context-specified process models.
Process Model Version Context Count	Number of reports on context-specified process model versions.
Node Context Count	Number of reports on context-specified nodes.
Process Context Count	Number of reports on context-specified processes.
Creator Context Count	Number of reports on processes created by the context-specified users.
Last Modifier Context Count	Number of reports on processes last modified by the context-specified users.
Initiator Context Count	Number of reports on processes initiated by the context-specified users.
Attributed User Context Count	Number of reports on tasks attributed to the context-specified users.
Assigned Group Context Count	Number of reports on tasks assigned to the context-specified groups.
Owner Context Count	Number of reports on tasks owned by the context-specified users.
Attributed Group Context Count	Number of reports on tasks attributed to the context-specified groups.
Minimum Total Execution Time	Shortest time required to complete a report's execution.
Maximum Total Execution Time	Longest time required to complete a report's execution.
Minimum Returned Rows	Fewest rows returned for one report.
Maximum Returned Rows	Most rows returned for one report.
Minimum Available Rows	Fewest rows available.
Maximum Available Rows	Most rows available.
Minimum Query Time	Shortest time required to complete a report's Query phase.
Maximum Query Time	Longest time required to complete a report's Query phase.
Minimum Grouping Time	Shortest time required to complete a report's Group phase.
Maximum Grouping Time	Longest time required to complete a report's Group phase.
Minimum Sorting Time	Shortest time required to complete a report's Sort phase.
Maximum Sorting Time	Longest time required to complete a report's Sort phase.
Minimum merging Time	Shortest time required to complete a report's Merge phase.
Maximum Merging Time	Longest time required to complete a report's Merge phase.

Search server replication performance logs

The search server replication performance log records the replication of data to the search server for indexing. The log is written to each time a replication occurs, which can be up to once per minute.

Summary file metrics (search_server_replication_summary.csv)

Metric	Description
Timestamp	Date and time of the replication.
Server Id	Unique identifier for the application server that is the source of the replication activity. This can be used to filter or group replication entries.
ID	Unique identifier for the replication event. Multiple lines may all be part of the same replication event.
Source	Source of the data being replicated to the search server.
Sink	The destination index in the search server to which the data is being replicated.
Action	The type of replication action that occurred. Possible values are BULK_LOAD - Replication of all relevant data from the source. INCREMENTAL_UPDATE - Incremental update of recent changes to data in the source. Each change is referred to as a transaction.
Total Time (ms)	Total amount of time spent replicating the data. This value will be greater than the sum of the other timing values in this log because it contains the time for overhead and phases not specifically logged.
Txn Count	Number of transactions replicated as part of an INCREMENTAL_UPDATE action. When the action is BULK_LOAD, this value is reported as -1, indicating there are no transactions to replicate.
Delete Count	Number of items deleted from the index as part of the INCREMENTAL_UPDATE action. When the action is BULK_LOAD, this value is reported as -1, indicating that the index is cleared in its entirety instead of deleting individual items.
Delete Time (ms)	Amount of time spent deleting items from the index.
Load Count	Number of items loaded from the source for replication.
Load Time (ms)	Amount of time spent loading items from the source for replication.
Upsert Count	Number of items updated or inserted into the destination index. This value will sometimes be less than the Load Count value because certain types of objects are excluded from replication.
Upsert Prepare Time (ms)	Amount of time spent preparing the items for updating or inserting into the destination index.
Upsert Persist Time (ms)	Amount of time spent updating or inserting items into the destination index.

Smart Services performance logs

These logs only report the performance of Java Smart Services, including both Appian and plug-in Smart Services. They do not cover other types of nodes such as gateways, tasks, and script nodes.

Trace file metrics (smart_services_trace.csv)

Metric	Description
Timestamp	Date and time when Smart Service is executed.
Activity Name	Fully qualified Java class name of the Smart Service.
Process Model ID	Local ID of the process model to which this Smart Service belongs.
Process ID	Local ID of the process to which this Smart Service belongs.
Username	Username of the user context in which this Smart Service is executing.
Run by Initiator	True if the executing user is also the process initiator, even if this is a coincidence and not configured to be the case, otherwise false.
Run by Designer	True if the executing user is also the process designer, even if this is a coincidence and not configured to be the case, otherwise false.
Run in Activity Chain	True if this Smart Service is executing as part of an activity chain, otherwise false.
Run as Quick Task	True if this Smart Service is executing as part of a quick task, otherwise false.
Total Time (ms)	Time required to execute the Smart Service.

Summary file and details file metrics (smart_services_summary.csv / smart_services_details.csv)

Metric	Description
[Details only] Activity Name	Fully qualified Java class name of the Smart Service.
Total Count	Number of Smart Services executed.
Mean Total Time (ms)	Average amount of time each Smart Service took to execute, including the system's setup time.
Initiator Count	Number of Smart Services that ran as the process initiator.
Designer Count	Number of Smart Services that ran as the process designer.
Chained Count	Number of Smart Services that ran as part of an activity chain.
Quick Task Count	Number of Smart Services that ran as quick tasks.
Minimum Total Time (ms)	Shortest measured execution time of a Smart Service.
Maximum Total Time (ms)	Longest measured execution time of a Smart Service.

Stored procedure execution logs

These logs contain information about calls made to execute stored procedures in the database using the following smart service and functions:

• Execute Stored Procedure smart service
• executeStoredProcedureForQuery function
• executeStoredProcdureOnSave function

Trace file metrics (stored_procedures_trace.csv/stored_procedures_slow.csv)

The stored_procedures_trace.csv file captures information about every call made to execute stored procedures. The stored_procedures_slow.csv has the same columns but only records the calls that take more than 15 seconds to execute. Use this to identify slower executions of stored procedures. You can change the 15 second threshold for this log using the conf.executeStoredProcedure.SLOW_PROCEDURE_THRESHOLD_MS property in custom.properties file. It takes an integer value in milliseconds.

Metric	Description
Timestamp	Date and time when the metric is taken.
Data Source Name	Name of the data source for admin console data sources and ID of the data source for data source connected systems.
Procedure Name	Name of the stored procedure.
Data Source Lookup Time (ms)	Time taken to identify the business data source used.
Data Source Connect Time (ms)	Time taken to retrieve connection from the connection pool. It could be higher if no connection is available in the pool and a brand new connection is required.
Validate Time (ms)	Time taken to verify if the input and output parameters match to an available stored procedure.
Prepare Time (ms)	Time taken to register the stored procedure parameters and set the configurations with JDBC before execution.
Execute Time (ms)	Time taken by the database to execute the stored procedure.
Transform Time (ms)	Time taken to process and format the data received from the database into Appian's internal structure.
Total Time (ms)	Total time required by all operations from beginning to end.
Error Message	Error message in case of a failure.
Model ID	ID of the process model when the stored procedure is called using the smart service.
Process ID	ID of the associated process instance when the stored procedure is called using the smart service.
Is Chained	Whether the smart service is activity-chained.
Task Name	Name of the task if the node is attended.
Total Row Count	Sum of all the rows returned by the stored procedures in the result sets.
Parameters	Names and values of IN, INOUT and OUT parameters.

Summary file metrics (stored_procedures_summary.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Count	Total number of calls made to execute stored procedures with the smart service or functions.
Total Smart Service Calls	Total number of calls made to execute stored procedures with the smart service.
Total Query Function Calls	Total number of calls made to execute stored procedures with the executeStoredProcedureForQuery function.
Total Save Function Calls	Total number of calls made to execute stored procedures with the executeStoredProcedureOnSave function.
Total Datasource Lookup Operations	Number of times business data source lookup operation was performed to identify the data source used.
Data Source Lookup Time	Time taken to identify the business data source used.
Mean Datasource Lookup Time (ms)	Average time taken to identify the business data source used.
Max Datasource Lookup Time (ms)	Longest time taken to identify the business data source used.
Total Datasource Connect Operations	Number of times data source connection was retrieved.
Mean Datasource Connect Time (ms)	Average time taken to retrieve data source connection.
Max Datasource Connect Time (ms)	Longest time taken to retrieve data source connection.
Total Validations Count	Number of times verification of input and output parameters was done to match to an available stored procedure.
Mean Validate Time (ms)	Average time taken to verify if the input and output parameters match to an available stored procedure.
Max Validate Time (ms)	Longest time taken to verify if the input and output parameters match to an available stored procedure.
Total Prepare Count	Number of times registration of stored procedure parameters and set up of configurations with JDBC was done.
Mean Prepare Time (ms)	Average time taken to register the stored procedure parameters and set the configurations with JDBC before execution.
Max Prepare Time (ms)	Longest time taken to register the stored procedure parameters and set the configurations with JDBC before execution.
Total Execute Count	Number of times the stored procedure was executed by the database.
Mean Execute Time (ms)	Average time taken by the database to execute the stored procedure.
Max Execute Time (ms)	Longest time taken by the database to execute the stored procedure.
Total Transform Count	Number of times the data received from the database was processed and formatted.
Mean Transform Time (ms)	Average time taken to process and format the data received from the database into Appian's internal structure.
Max Transform Time (ms)	Longest time taken to process and format the data received from the database into Appian's internal structure.
Mean Total Time (ms)	Average time required by all operations from beginning to end.
Max Total Time (ms)	Longest time required by all operations from beginning to end.
Total Row Count	Total rows returned in the result sets.

Stored procedure metrics (stored_procedures_details.csv)

The stored_procedures_details.csv file aggregates metrics individually based on data source and stored procedure name.

Metric	Description
Timestamp	Date and time when the metric is taken.
Data Source Name	Name of the data source connected from the Admin Console, or the ID of the data source connected by a data source connected system.
Procedure Name	Name of the stored procedure.
Total Count	Total number of calls made to execute stored procedures with the smart service or functions.
Total Smart Service Calls	Total number of calls made to execute stored procedures with the smart service.
Total Query Function Calls	Total number of calls made to execute stored procedures with the a!executeStoredProcedureForQuery() function.
Total Save Function Calls	Total number of calls made to execute stored procedures with the a!executeStoredProcedureOnSave() function.
Total Failure Count	Total number of failed calls made to execute stored procedures with the smart service or functions.
Total Datasource Lookup Operations	Number of times business data source lookup operations were performed to identify the data source used.
Mean Datasource Lookup Time (ms)	Average time taken to identify the business data source used.
Max Datasource Lookup Time (ms)	Longest time taken to identify the business data source used.
Total Datasource Connect Operations	Number of times data source connection was retrieved.
Mean Datasource Connect Time (ms)	Average time taken to retrieve data source connection.
Max Datasource Connect Time (ms)	Longest time taken to retrieve data source connection.
Total Validations Count	Number of times input and output parameters were verified to match an available stored procedure.
Mean Validate Time (ms)	Average time taken to verify if the input and output parameters match to an available stored procedure.
Max Validate Time (ms)	Longest time taken to verify if the input and output parameters match to an available stored procedure.
Total Prepare Count	Number of times the stored procedure parameters were registered and the configuration was set with JDBC.
Mean Prepare Time (ms)	Average time taken to register the stored procedure parameters and set the configurations with JDBC before execution.
Max Prepare Time (ms)	Longest time taken to register the stored procedure parameters and set the configurations with JDBC before execution.
Total Execute Count	Number of times the stored procedure was executed by the database.
Mean Execute Time (ms)	Average time taken by the database to execute the stored procedure.
Max Execute Time (ms)	Longest time taken by the database to execute the stored procedure.
Total Transform Count	Number of times the data received from the database was processed and formatted.
Mean Transform Time (ms)	Average time taken to process and format the data received from the database into Appian's internal structure.
Max Transform Time (ms)	Longest time taken to process and format the data received from the database into Appian's internal structure.
Mean Total Time (ms)	Average time required by all operations from beginning to end.
Max Total Time (ms)	Longest time required by all operations from beginning to end.
Mean Row Count	Average rows returned in the result sets.
Max Row Count	Max rows returned in the result sets.
Total Row Count	Total rows returned in the result sets.

Web API performance logs

Trace file metrics (web_apis_trace.csv)

Web API trace logging can be enabled and disabled via the Admin Console.

Metric	Description
Timestamp	Date and time when the API is called.
Username	Username of the user that executed the Web API.
Endpoint	Endpoint of the Web API.
UUID	UUID of the Web API.
Status code	HTTP status code of the Web API response.
Execution time(ms)	How long it took to execute the Web API.
Response size (bytes)	The size of the response of the Web API.
HTTP Method	The HTTP method of the Web API. One of GET, POST,PUT,DELETE,PATCH,OPTIONS, or HEAD.

Summary file and details file metrics (web_api_summary.csv / web_api_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
[Details only] Endpoint	Endpoint of the Web API.
[Details only] UUID	UUID of the Web API.
Execution Count	Number of times the a Web API was executed in the time interval.
Status code 1xx count	Number of times a Web API returned a 100 series HTTP status code.
Status code 2xx count	Number of times a Web API returned a 200 series HTTP status code.
Status code 3xx count	Number of times a Web API returned a 300 series HTTP status code.
Status code 4xx count	Number of times a Web API returned a 400 series HTTP status code.
Status code 5xx count	Number of times a Web API returned a 500 series HTTP status code.
Mean Execution Time (ms)	Average amount of time each Web API took to execute.
Minimum Execution Time (ms)	Shortest measured execution time of a Web API.
Maximum Execution Time (ms)	Longest measured execution time of a Web API.
Mean Response Size (bytes)	Average size of a Web API response.
Minimum Response Size (bytes)	Smallest size of a Web API response.
Maximum Response Size (bytes)	Largest size of a Web API response.
HTTP Method	The HTTP method of the Web API. One of GET,POST,PUT,DELETE, or HEAD.

Work poller performance logs

Work poller items are activity from unattended processes that are processed by the application server.

Summary file and details file metrics (work_poller_summary.csv / work_poller_details.csv)

Metric	Description
Timestamp	Date and time when the metric is taken.
Work Items Started	Number of work items that were begun in the time period.
Work Items Completed	Number of work items that were completed in the time period.
Maximum Threads In Concurrent Use	Maximum number of threads that were used to process work items in the period.
Total Completion Time (ms)	Total amount of time spent completing work items.
Mean Completion Time (ms)	Average time it took to complete a work item.
Minimum Completion Time (ms)	Time it took to complete the fastest work item.
Maximum Completion Time (ms)	Time it took to complete the longest work item.

Analyzing data metrics

Data metrics logs are written to the APPIAN_HOME/logs/data-metrics directory and contain information about the quantity of data in the Appian system. You can observe and analyze them using common spreadsheet tools.

They are written to every twelve hours and provide a view of how much data is in the system at the present time and how the amount of data is changing over time.

Action metrics log

The Action metrics log file (actions.csv) provides information about actions.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Actions	Total number of actions in all applications.
Offline Actions	Number of actions that are configured to be available for offline mobile.
Starred Actions	Number of actions that are starred at least once.
Total Applications with Actions	Number of applications containing at least one action.
Maximum Actions per Application	Number of actions in the application that has the most actions.

Administration branding log

The Administration branding log file (admin-branding.csv) provides a record of which Admin Console branding properties have been changed from their default values.

Metric	Description
Loading Bar Color Accent	This metric captures whether the loading bar color in the admin console is the environment's accent color (default) or whether a custom hex code color has been configured.

Admin Console log

The Administration Console log file (admin_console.csv) provides a record of which Admin Console properties have been changed away from their default values.

Metric	Description
Timestamp	Date and time when the metric is taken.
Property	The key of the property that has been modified.
Count	The number of customized values for the property. For properties with a single value, the count will be 1. For list properties, the count will be the number of items in the list.

This log does not cover changes to the following areas of the Admin Console:

• Plug-ins
• User Start Pages, except for Default Start Page
• Client Certificates
• Trusted Server Certificates
• Third-Party Credentials

Administration Permissions log

The Administration Permissions log file (admin-permission.csv) provides a record of which Admin Console permissions have been changed from their default values.

Metric	Description
Profile Photo Edit Permission	This metric captures whether users are allowed to upload a profile photo. If the Profile Photo option is enabled, users can upload a profile photo.
Cover Photo Edit Permission	This metric captures whether users are allowed to upload a profile photo. If the Profile Photo option is enabled, users can upload a profile photo.

API Key metrics log

The API Key metrics log file (api_key.csv) provides information about API keys.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Active API Keys in the System	The number of active API keys in your environment.
Number of Inactive API Keys in the System	The number of inactive API keys in your environment.
Number of Service Accounts	The number of groups in the Service Accounts system group in your environment.
Max Number of Keys Associate With One Account	The maximum number of API keys associated with a single service account in your environment.
Avg Number of Keys Associate per Account	The average number of API keys associated with a single service account in your environment.

Application documentation metrics log

The Application documentation log file (application_documentation.csv) provides information about developer use of the application documentation capability.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Applications with Documentation	Total number of applications to which developers have added at least one document or link.
Applications with Documents	Number of applications to which developers have added at least one document.
Applications with Links	Number of applications to which developers have added at least one link.
Applications with Between 1 and 5 Documents	Number of applications to which developers have added between 1 and 5 documents or links.
Applications with Between 6 and 10 Documents	Number of applications to which developers have added between 6 and 10 documents or links.

Cache metrics log

The Cache metrics log file (cache.csv) provides information about application server caches. One line will be written to the log file for every cache that has been initialized.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Cache Name	Name of the cache.
Total Objects	Total number of objects in the cache.
Hit Count	Number of times the data was served from the cache.
Miss Count	Number of times the data was not found in the cache.
Remove Count	Number of times objects have been removed from the cache.
Update Count	Number of times objects in the cache have been updated.

Cloud database schema metrics log

The Cloud Database Schema metrics log file (cloud_db_schemas.csv) captures information about the different schemas in your Appian Cloud database. A new row of data is captured in the file every thirty days or when your environment is restarted.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Schema Name Hash	Hashed value of the schema name to identify each schema in your environment.
Table Count	Number of tables created in the schema.
Column Count	Total number of columns in the schema across all the tables.
Row Count	Total number of rows in the schema across all the tables.

Connected system metrics log

The Connected System metrics log (connected_systems.csv) provides information about connected systems.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Connected Systems	Total number of connected system objects in all applications.
Number of Connected Systems with Custom Logos	Number of connected systems that have custom system logos.
Number of Connected Systems with OAuth Authentication	Number of connected systems configured with OAuth 2.0: Authorization Code Grant authentication.
Number of Connected Systems with Basic Authentication	Number of connected systems configured with HTTP Basic Authentication.
Number of Amazon Machine Learning Connected Systems	Number of Amazon Machine Learning Connected Systems.
Number of Connected Systems with Base URL	Number of connected systems configured with a Base URL.
Number of HTTP Connected Systems	The number of HTTP connected systems.
Number of OpenAPI Connected Systems	The number of OpenAPI connected systems.
Number of Connected System Versions	Total number of versions for all connected system objects.
Total Size of Connected Systems (bytes)	Total size of all connected system objects measured in bytes.
Number of Connected Systems using the Integration SDK	Number of connected systems that were built using the integration SDK.
Number of Connected Systems with Api Key Authentication	Number of connected systems configured with API Key authentication.
Number of Connected Systems with Client Credentials Authentication	Number of connected systems configured with OAuth 2.0: Client Credentials Grant authentication.
Number of Connected Systems with GSA Authentication without Domain Wide Delegation	Number of connected systems configured with Google Service Account authentication that doesn't impersonate a G Suite domain user.
Number of Connected Systems with GSA Authentication and Domain Wide Delegation	Number of connected systems configured with Google Service Account authentication that does impersonate a G Suite domain user.
Number of Connected Systems with AWS Signature V4 Authentication	Number of connected systems configured with AWS Signature V4 authentication.

Connected system aggregated log

The connected system aggregated log (connected_systems_aggregated.csv) provides information about connected systems and connected system plug-ins.

Metric	Description
Timestamp	Date and time when the metric is taken.
Connected System ID	Unique identifier for the Connected System plug-in template.
Connected System Count	Number of connected systems of this type in the system.
Total Count	Number of connected systems of this type in the system, including past versions.
Average Size (bytes)	Average amount of disk space used by a Connected System of this type.
Minimum Size (bytes)	Smallest amount of disk space used by a Connected System of this type.
Maximum Size (bytes)	Largest amount of disk space used by a Connected System of this type.
Total Size (bytes)	Total disk space used by connected systems of this type.

Content metrics log

The Content metrics log (content.csv) records metrics on data stored in the Content Engine Server.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Content	Total number of content objects of all types in the system.
Documents	Number of documents uploaded to the system, including past versions.
Folders	Number of folders in within knowledge centers.
Personal Knowledge Centers	Number of knowledge centers within the Personal and Teams folder.
Community Knowledge Centers	Number of knowledge centers within the Communities folder.
Communities	Number of communities within the Communities folder.
Rules and Constants	Number of rules and constants in the system, including past versions.
Applications	Number of applications in the system.
Custom Content	Number of objects created via the CustomContent API.
Total Downloads	Total number of times users have downloaded documents from the system.
Users Who Have Downloaded	Number of users who have downloaded at least one document.
Users Who Have Uploaded	Number of users who have uploaded at least one document.
Most Downloads of a Single Document	Number of times the most downloaded document has been downloaded.
Offline Interfaces	Number of interfaces that are made available for offline mobile.

Content object size metrics log

The content object size metrics log (rules.csv) records sizing information about individual object types stored in the Content Engine Server.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Constants	Total number of constant objects in the system.
Total Expression Rules	Total number of expression rule objects in the system.
Total Interfaces	Total number of interface objects in the system.
Total Query Rules	Total number of query rule objects in the system.
Total Decisions	Total number of decision objects in the system.
Total Integrations	Total number of integration objects in the system.
Total Rule Folders	Total number of rule folders in the system.
Max Constant Versions	Maximum number of versions for a single constant.
Avg Constant Versions	Average number of versions for a single constant.
Max Expression Rule Versions	Maximum number of versions for a single expression rule.
Avg Expression Rule Versions	Average number of versions for a single expression rule.
Max Interface Versions	Maximum number of versions for a single interface.
Avg Interface Versions	Average number of versions for a single interface.
Max Query Rule Versions	Maximum number of versions for a single query rule.
Avg Query Rule Versions	Average number of versions for a single query rule.
Max Decision Versions	Maximum number of versions for a single decision.
Avg Decision Versions	Average number of versions for a single decision.
Max Integration Versions	Maximum number of versions for a single integration.
Avg Integration Versions	Average number of versions for a single integration.
Max Constant Rolemap Entries	Maximum number of users and groups referenced in any constant's security rolemap.
Avg Constant Rolemap Entries	Average number of users and groups referenced in any constant's security rolemap.
Max Expression Rule Rolemap Entries	Maximum number of users and groups referenced in any expression rule's security rolemap.
Avg Expression Rule Rolemap Entries	Average number of users and groups referenced in any expression rule's security rolemap.
Max Interface Rolemap Entries	Maximum number of users and groups referenced in any interface's security rolemap.
Avg Interface Rolemap Entries	Average number of users and groups referenced in any interface's security rolemap.
Max Query Rule Rolemap Entries	Maximum number of users and groups referenced in any query rule's security rolemap.
Avg Query Rule Rolemap Entries	Average number of users and groups referenced in any query rule's security rolemap.
Max Decision Rolemap Entries	Maximum number of users and groups referenced in any decision's security rolemap.
Avg Decision Rolemap Entries	Average number of users and groups referenced in any decision's security rolemap.
Max Integration Rolemap Entries	Maximum number of users and groups referenced in any integration's security rolemap.
Avg Integration Rolemap Entries	Average number of users and groups referenced in any integration's security rolemap.
Max Rule Folder Rolemap Entries	Maximum number of users and groups referenced in any rule folder's security rolemap.
Avg Rule Folder Rolemap Entries	Average number of users and groups referenced in any rule folder's security rolemap.
Max Expression Rule Expression Size	Maximum number of characters in the expression definition of a single expression rule.
Avg Expression Rule Expression Size	Average number of characters in the expression definition of a single expression rule.
Max Interface Expression Size	Maximum number of characters in the expression definition of a single interface.
Avg Interface Expression Size	Average number of characters in the expression definition of a single interface.
Max Decision Expression Size	Maximum number of characters in the expression definition of a single decision.
Avg Decision Expression Size	Average number of characters in the expression definition of a single decision.
Max Integration Expression Size	Maximum number of characters in the expression definition of a single integration.
Avg Integration Expression Size	Average number of characters in the expression definition of a single integration.
Total Rule Inputs in Interfaces	Total number of rule inputs in all interface objects in this environment.
Total Rule Inputs in Expression Rules	Total number of rule inputs in all expression rule objects in this environment.
Total Rule Inputs in Integrations	Total number of rule inputs in all integration objects in this environment.
Total Rule Inputs in Decisions	Total number of rule inputs in all decision objects in this environment.
Total Rule Input Descriptions in Interfaces	Total number of rule inputs with a description in all interface objects in this environment.
Total Rule Input Descriptions in Expression Rules	Total number of rule inputs with a description in all expression rule objects in this environment.
Total Rule Input Descriptions in Integrations	Total number of rule inputs with a description in all integration objects in this environment.
Total Rule Input Descriptions in Decisions	Total number of rule inputs with a description in all decision objects in this environment.

Data service metrics logs

The data service metrics logs capture information about how the processes that make up the data service component of the Appian platform are functioning so that Appian Technical Support can help troubleshoot issues. The log files contain quantitative data only and no sensitive information.

The following files in the data-metrics directory are data service metrics logs:

• data-server-client.csv - Metrics for the calls made by the application through data service client.
• hs-gateway.csv - Metrics for the historical store gateway process.
• hs-engine.csv - Metrics for the historical store process.
• rts-gateway-<number>.csv - Metrics for the real-time store gateway process.
• rts-engine-<number>.csv - Metrics for the real-time store process.
• watchdog.csv - Metrics for the resource utilization by all the data service processes.
• sync-engine.csv - Metrics related to the data synchronization process between the data service nodes, only applicable for highly available installation.
• sync-gateway.csv - Metrics related to the data synchronization process between the data service nodes, only applicable for highly available installation.

Data source metrics log

The Data source metrics log file (data_sources.csv) captures information about various types of data sources that are created in your environment through the Admin Console, the application server, or connected systems.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total business data sources	Count of business data sources in your environment.
Administration console data sources	Count of data sources configured via Admin Console.
Application server data sources	Count of data sources configured via application server.
MySQL data sources	Number of MySQL data sources in your environment.
SQL Server data sources	Number of SQL Server data sources in your environment.
Oracle data sources	Number of Oracle data sources in your environment.
DB2 data sources	Number of DB2 data sources in your environment.
MySQL versions	Versions of MySQL data sources in your environment.
SQL Server versions	Versions of SQL Server data sources in your environment.
Oracle versions	Versions of Oracle data sources in your environment.
DB2 versions	Versions of DB2 data sources in your environment.
PostgreSQL data sources	Number of PostgreSQL data sources in your environment.
MariaDB data sources	Number of MariaDB data sources in your environment.
PostgreSQL versions	Versions of PostgreSQL data sources in your environment.
MariaDB versions	Versions of MariaDB data sources in your environment.
Unknown data sources	Data sources with unknown database information.
Data sources of connected system type	Number of data sources configured via connected systems.
Administration console data source versions	Versions of data sources configured via Admin Console.
Connected system data source versions	Versions of data sources configured via connected systems.
Application server data source versions	Versions of data sources configured via application server.
Unique connected system role maps	Number of unique role map security configurations across data sources of connected system type.

Data source connection pool metrics log

The Data source connection pool metrics log file (data_source_pool.csv) captures the connection pool information for each data source in your environment.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Data Source ID	Unique identifier for each data source in your environment
Active	Number of connections borrowed from this pool.
Idle	Number of open connections idle in this pool.
Waiting	Number of threads blocked waiting for a connection from the pool.
Total Created	The total number of connections created for this pool over the lifetime of the pool.
Total Borrowed	The total number of connections successfully borrowed from this pool over the lifetime of the pool.
Total Destroyed	The total number of connections destroyed by this pool over the lifetime of the pool.
Total Evicted	The total number of connections destroyed by the evictor associated with this pool over the lifetime of the pool.
Max Total Connection Pool	The maximum number of connections that can be allocated by the pool at a given time.

Data type metrics log

The Data type metrics log file (types.csv) provides information on the system and custom data types created in the system.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Types	Number of types in the system, both system and custom.
System Types	Number of types built into the system.
Namespaces	Number of namespaces containing types, including the built-in system type namespace.
Total Custom Types	Number of types created by designers, including list types and deactivated types.
Custom Complex Types	Number of active custom complex types, not including list types.
Custom List Types	Number of active custom list types.
Custom Deactivated Types	Number of custom types that are deactivated, including older versions of current custom types.
Visible Custom Types	Number of custom types not marked has hidden and potentially available for selection as a type for node inputs, node outputs, process and data store entities.
Designer-Created Custom Types	Number of custom types created in the Data Type Designer. Types created via XSD import are not included.
Web Service Custom Types	Number of custom types created from a web service's WSDL instead of the Data Type Designer or XSD import.
Temporary Types	Number of web service types that are not yet associated with a published process model.
Importing Types	Number of types that are in the process of being imported.

Decision metrics log

The Decision metrics log file (decisions.csv) provides information on the Decisions created in the system.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Average Number of Rows	Average number of rows per Decision.
Max Number of Rows	Maximum number of rows in a single Decision.
Decisions With 25 Rows or Less	Number of Decisions with 25 or less rows.
Decisions With 26 to 50 Rows	Number of Decisions with between 26 and 50 rows.
Decisions With More Than 50 Rows	Number of Decisions with more than 50 rows.
Average Number of Inputs	Average number of inputs per Decision.
Max Number of Inputs	Maximum number of inputs in a single Decision.
Average Number of Outputs	Average number of outputs per Decision.
Max Number of Outputs	Maximum number of outputs in a single Decision.
Decisions Using List of Values for Inputs	Number of Decisions with at least one list of values as an input.
Decisions Using List of Values for Outputs	Number of Decisions with at least one list of values as an output.
Decisions Using Appian Object Outputs	Number of Decisions with at least one output of type Document, Folder, Group, Process Model, User, or User or Group.
Decisions Using Between Exclusive Operator	Number of Decisions using the Between exclusive operator at least once.
Unique Hit Policy Decisions	Number of Decisions using the Unique hit policy.
Rule Order Hit Policy Decisions	Number of Decisions using the Rule Order hit policy.
First Hit Policy Decisions	Number of Decisions using the First hit policy.

Design guidance metrics log

The Design guidance metrics log (design_guidance.csv) records information about design guidance (warnings and recommendations) across your environment.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Guidance Count	Number of active and dismissed guidance (warnings and recommendations).
Active Guidance Count	Number of active guidance. (Equal to the sum of Active Security Warnings Count plus Active Recommendations Count).
Dismissed Guidance Count	Number of dismissed guidance.
Migrated Guidance Count	Number of new guidance flagged on existing objects during application server start up.
Total Objects with Guidance	Number of objects with at least one active OR at least one dismissed guidance. (Equal to the sum of Objects with Active Guidance plus Objects with Dismissed Guidance minus Objects with Both Active and Dismissed Guidance Count).
Objects with Active Guidance Count	Number of objects with at least one active guidance.
Objects with Dismissed Guidance Count	Number of objects with at least one dismissed guidance.
Objects with Both Active and Dismissed Guidance Count	Number of objects with at least one active AND at least one dismissed guidance. (Equal to the intersection of Objects with Active Guidance and Objects with Dismissed Guidance).
Active Security Warnings	Number of active security warnings.
Active Recommendations Count	Number of active recommendations.
Total Objects with Recommendations	Number of objects with at least one active OR dismissed recommendation. (Equal to the sum of Objects with Active Recommendations Count plus Objects with Dismissed Guidance Count minus their intersection).
Objects with Active Security Warnings Count	Number of objects with at least one active security warning.
Objects with Active Recommendations Count	Number of objects with at least one active recommendation.

Design guidance by finding metrics log

The Design guidance by finding metrics log (design_guidance_by_finding.csv) records information about the various findings (e.g. specific warnings and recommendations) across your environment.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Finding	Finding being tracked (e.g. specific warning or recommendation).
Total Guidance Count	Number of active and dismissed guidance for the given finding.
Active Guidance Count	Number of active guidance for the given finding.
Dismissed Guidance Count	Number of dismissed guidance for the given finding.

Design guidance by object type metrics log

The Design guidance by object type metrics log (design_guidance_by_object_type.csv) records information about design guidance (warnings and recommendations) for each design object type in your environment.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Object Type	Design object type being tracked.
Total Guidance Count	Number of active and dismissed guidance (warnings and recommendations) for all objects of the given type.
Active Guidance Count	Number of active guidance for all objects of the given type. (Equal to the sum of Active Security Warnings Count plus Active Recommendations Count).
Dismissed Guidance Count	Number of dismissed guidance for all objects of the given type.
Migrated Guidance Count	Number of new guidance flagged on existing objects of the given type during application server start up.
Total Objects with Guidance	Number of objects of the given type with at least one active OR at least one dismissed guidance. (Equal to the sum of Objects with Active Guidance plus Objects with Dismissed Guidance minus Objects with Both Active and Dismissed Guidance Count).
Objects with Active Guidance Count	Number of objects of the given type with at least one active guidance.
Objects with Dismissed Guidance Count	Number of objects of the given type with at least one dismissed guidance.
Objects with Both Active and Dismissed Guidance Count	Number of objects of the given type with at least one active AND at least one dismissed guidance. (Equal to the intersection of Objects with Active Guidance and Objects with Dismissed Guidance).
Active Security Warnings Count	Number of active security warnings for all objects of the given type.
Active Recommendations Count	Number of active recommendations for all objects of the given type.
Total Objects with Recommendations	Number of objects of the given type with at least one active OR dismissed recommendation. (Equal to the sum of Objects with Active Recommendations Count plus Objects with Dismissed Guidance Count minus their intersection).
Objects with Active Security Warnings Count	Number of objects of the given type with at least one security warning.
Objects with Active Recommendations Count	Number of objects of the given type with at least one active recommendation.

Design library metrics log

The Design library log file (design_library.csv) provides information about the number of interfaces you've added to the design library in your environment.

Metrics include the following:

Metric	Description
Interfaces in the Design Library	Total number of interfaces in the design library for the environment.
Applications with Interfaces in the Design Library	Total number of applications that contain interfaces from the design library for the environment.
Applications with 25 or Fewer Interfaces in the Design Library	Number of applications that contain 25 or fewer interfaces from the design library for the environment.
Applications with 26 to 50 Interfaces in the Design Library	Number of applications that contain between 26 and 50 interfaces from the design library for the environment.
Applications with 51 to 100 Interfaces in the Design Library	Number of applications that contain between 51 and 100 interfaces from the design library for the environment.
Applications with More than 100 Interfaces in the Design Library	Number of applications that contain more than 100 interfaces from the design library for the environment.

Design object versions metrics log

The Design object versions log file (design_object_versions.csv) provides information on the version history created on export for different design objects. This version history is used for determining inspection statuses and is different than the versions that designers can access for interfaces, process models, etc.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Object Type	Design object type being tracked.
Total Count	Total number of objects of the given type with version history generated by export.
Min Number of Versions	Minimum number of versions for a single object of the given type.
Average Number of Versions	Average number of versions for a single object of the given type.
Max Number of Versions	Maximum number of versions for a single object of the given type.

DevOps Infrastructure metrics log

The DevOps Infrastructure Management log (devops_infrastructure.csv) provides information about the number of environments in your DevOps Infrastructure.

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Enabled Environments	The number of environments in your infrastructure with communication enabled.
Number of Disabled Environments	The number of environments in your infrastructure with communication disabled.

Disk usage metrics logs

The Engine disk usage metrics log (engine_disk_usage.csv) records the disk space used and available in a number of directories important to the engine server. One line is logged per monitored directory. The directories monitored are:

Directory Name	Location
Logs	<AE_HOME>/logs/
Archived Processes	<AE_HOME>/server/archived-process/
Engine Gateways	By default: one per non-process engine in <AE_HOME>/server/[engine name]/gw1 one for process design in <AE_HOME>/server/process/design/gw1/ three for analytics in <AE_HOME>/server/process/analytics/[engine id]/gw1/ three for process execution in <AE_HOME>/server/process/execution/[engine id]/gw1/

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Directory	Name of the monitored directory.
KDB File Count	Number of KDB files in the directory.
Partition Space Available (MB)	Amount of space used and free space on the partition mounting this directory.
Partition Space Used (MB)	Amount of space used on the partition mounting this directory.
Directory Space Used (MB)	Amount of space used on by the contents of this directory, including subdirectories.

Expression rule test cases metrics log

The Expression rule test cases metrics log file (expression_rule_test_cases.csv) provides information about the amount test cases and the types of assertions for expression rules in the system. All counts are for the current versions of every expression rule and not any previous versions of the rules.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Expression Rules	Total number of expression rules in the system, not including all versions of the rules.
Rules with 1 Test Case	Number of expression rules with only 1 test case.
Rules with Between 2 and 5 Test Cases	Number of expression rules with between 2 and 5 test cases.
Rules with Between 6 and 10 Test Cases	Number of expression rules with between 6 and 10 test cases.
Rules with Between 11 and 25 Test Cases	Number of expression rules with between 11 and 25 test cases.
Rules with more than 25 Test Cases	Number of expression rules with greater than 25 test cases.
Mean Test Cases	Average number of test cases per expression rule.
Max Test Cases	Maximum number of test cases for an expression rule in the system.
Test Cases with No Assertions	Total number of test cases that are not asserting a specific output or expression.
Test Cases with Asserted Outputs	Total number of test cases that assert a specific output.
Test Cases with Expression Assertions	Total number of test cases with expression assertions.

File extension blocking metrics log

The File extension blocking log (file_extension_blocking.csv) records metrics on file extension blocking settings in the Admin Console. This log can be used to track the level of file security controls over time.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Blocking Setting	The type of file extension list configured. Options: "Block List", "Allow List"
Number of File Extensions Specified	The number of unique extensions specified
Files Without Extension Setting	The value of the setting for whether to allow or block files without extensions. Options: "Enabled" or "Disabled"
File Type Verification Setting	The value of the setting for whether to block any file with an extension that does not match its type. Options: "Enabled" or "Disabled"

Group metrics log

The Group metrics log (groups.csv) provides information about groups and group types.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Groups	Number of groups in the system.
Group Types	Number of group types in the system.
Custom Groups	Number of groups of type Custom.
Department Groups	Number of groups of type Department.
Team Groups	Number of groups of type Team.
Groups with Rules	Number of groups with at least one rule.
Maximum Groups per Group Type	Maximum number of groups per group type (excluding Custom, Department, and Team).
Average Groups per Group Type	Average number of groups per group type (excluding Custom, Department, and Team).
Maximum Group Type Attributes	Maximum number of attributes on a single group type.
Groups with Parent	Number of groups with a parent group defined.

Health Check metrics log

The Health Check metrics log file (health_check.csv) provides information about Health Check settings and runs.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Health Check Enabled	Indicates whether Health Check has been set up.
Production Environment	Indicates whether the environment was identified as a production environment.
Automatic Upload Enabled	Indicates whether automatic upload has been enabled.
Autoapprove Enabled	Indicates whether autoapproval for data reviews has been enabled.
Scheduling Enabled	Indicates whether scheduling has been enabled.
Scheduling Frequency	Frequency of scheduled runs: 1 (every week), 2 (every other week), 3 (every three weeks), 4 (every four weeks).
Scheduling Week Day	Day of the week on which runs are scheduled.
Scheduling Hour	Hour at which runs are scheduled (in GMT time).
Health Check Runs	Total number of Health Check runs (includes successful, canceled, and failed runs).
Direct User Viewers	Number of users added directly to the Health Check Viewers group.
Indirect User Viewers	Number of users that are indirect members of the Health Check Viewers group.
Total User Viewers	Total number of users in the Health Check Viewers group (sum of direct and indirect users).
Direct Group Viewers	Number of groups added directly to the Health Check Viewers group.
Indirect Group Viewers	Number of groups that are indirect members of the Health Check Viewers group.
Total Group Viewers	Total number of groups in the Health Check Viewers group (sum of direct and indirect groups).

Integration metrics log

The Integration metrics log (integrations.csv) provides information about integrations.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Integrations	Total number of integration objects in all applications.
Number of Read Integrations	Number of integrations that query data.
Number of Write Integrations	Number of integrations that modify data.
Number of Integrations Using Expressions	Number of integrations that use expressions in their configuration fields (other than the Body).
Number of Integrations Using Connected Systems	Number of integrations that use connected systems.
Average Number of Integration Inputs	Average number of inputs per integration.
Max Number of Integration Inputs	Maximum number of inputs in a single integration.
Number of Integrations with Response Body Conversion	Number of integrations that convert a JSON response body to an Appian value.
Number of Integrations with Custom Error Handling	Number of integrations that use custom error handling.
Number of Amazon Machine Learning Integrations	Number of integrations that leverage an Amazon Machine Learning connected system.
Number of Integrations with Default Test Values	Number of integrations that have a set of default test values saved.
Number of Integrations that can inherit Base URL	The number of integrations that use a connected system with a base URL configured. Counts even those that choose to build a URL from scratch.
Number of Integrations inheriting Base URL	The number of integrations that inherit their base URL from a connected system.
Number of Integrations using Active OpenAPI Connected Systems	The number of integrations that use an OpenAPI connected system.
Maximum Number of Integrations per Active OpenAPI Connected System	The maximum number of integrations that use a single OpenAPI connected system.
Average Number of Integrations per Active OpenAPI Connected System	The average number of integrations that use a single OpenAPI connected system.
Total Size of Integration Expressions (bytes)	Total size of all integrations measured in bytes. Only the latest version is counted.
Total Number of Versions	Total number of versions for all integrations

Integration aggregated log

The Integration aggregated metrics log (integrations-aggregated.csv) provides information about integrations.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Integration Template ID	Unique identifier for the Integration template.
Integration Count	Number of Integrations of this type in the system.
Total Count	Number of Integrations of this type in the system, including past versions.
Average Size (bytes)	Average amount of disk space used by a Integration objects of this type.
Minimum Size (bytes)	Smallest amount of disk space used by a Integration objects of this type.
Maximum Size (bytes)	Largest amount of disk space used by a Integration objects of this type.
Total Size (bytes)	Total disk space used by Integration objects of this type.

Locales log

The Locales log (locales.csv) provides information about system and user locale configuration.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Primary Locale	Name of the primary locale for your environment.
Site-wide primary locale	True if the primary locale is configured to always override users’ selected locale, otherwise false.
Default locale user count	Number of users who have selected no locale and use the primary locale by default.
English (US) [en_US] is enabled	True if English (US) [en_US] is enabled in the system, otherwise false.
English (US) [en_US] user count	Number of users who have selected English (US) [en_US] as their locale.
Arabic [ar] is enabled	True if Arabic [ar] is enabled in the system, otherwise false.
Arabic [ar] user count	Number of users who have selected Arabic [ar] as their locale.
German [de] is enabled	True if German [de] is enabled in the system, otherwise false.
German [de] user count	Number of users who have selected German [de] as their locale.
English (UK) [en_GB] is enabled	True if English (UK) [en_GB] is enabled in the system, otherwise false.
English (UK) [en_GB] user count	Number of users who have selected English (UK) [en_GB] as their locale.
Greek [el] is enabled	True if Greek [el] is enabled in the system, otherwise false.
Greek [el] user count	Number of users who have selected Greek [el] as their locale.
Spanish [es] is enabled	True if Spanish [es] is enabled in the system, otherwise false.
Spanish [es] user count	Number of users who have selected Spanish [es] as their locale.
French (Canada) [fr_CA] is enabled	True if French (Canada) [fr_CA] is enabled in the system, otherwise false.
French (Canada) [fr_CA] user count	Number of users who have selected French (Canada) [fr_CA] as their locale.
French (Switzerland) [fr_CH] is enabled	True if French (Switzerland) [fr_CH] is enabled in the system, otherwise false.
French (Switzerland) [fr_CH] user count	Number of users who have selected French (Switzerland) [fr_CH] as their locale.
French (France) [fr_FR] is enabled	True if French (France) [fr_FR] is enabled in the system, otherwise false.
French (France) [fr_FR] user count	Number of users who have selected French (France) [fr_FR] as their locale.
Hebrew [iw] is enabled	True if Hebrew [iw] is enabled in the system, otherwise false.
Hebrew [iw] user count	Number of users who have selected Hebrew [iw] as their locale.
Italian [it] is enabled	True if Italian [it] is enabled in the system, otherwise false.
Italian [it] user count	Number of users who have selected Italian [it] as their locale.
Japanese [ja] is enabled	True if Japanese [ja] is enabled in the system, otherwise false.
Japanese [ja] user count	Number of users who have selected Japanese [ja] as their locale.
Korean [ko] is enabled	True if Korean [ko] is enabled in the system, otherwise false.
Korean [ko] user count	Number of users who have selected Korean [ko] as their locale.
Dutch [nl] is enabled	True if Dutch [nl] is enabled in the system, otherwise false.
Dutch [nl] user count	Number of users who have selected Dutch [nl] as their locale.
Polish [pl] is enabled	True if Polish [pl] is enabled in the system, otherwise false.
Polish [pl] user count	Number of users who have selected Polish [pl] as their locale.
Portuguese [pt] is enabled	True if Portuguese [pt] is enabled in the system, otherwise false.
Portuguese [pt] user count	Number of users who have selected Portuguese [pt] as their locale.
Russian [ru] is enabled	True if Russian [ru] is enabled in the system, otherwise false.
Russian [ru] user count	Number of users who have selected Russian [ru] as their locale.
Swedish [sv] is enabled	True if Swedish [sv] is enabled in the system, otherwise false.
Swedish [sv] user count	Number of users who have selected Swedish [sv] as their locale.
Thai [th] is enabled	True if Thai [th] is enabled in the system, otherwise false.
Thai [th] user count	Number of users who have selected Thai [th] as their locale.
Turkish [tr] is enabled	True if Turkish [tr] is enabled in the system, otherwise false.
Turkish [tr] user count	Number of users who have selected Turkish [tr] as their locale.
Chinese (Simplified) [zn_CH] is enabled	True if Chinese (Simplified) [zn_CH] is enabled in the system, otherwise false.
Chinese (Simplified) [zn_CH] user count	Number of users who have selected Chinese (Simplified) [zn_CH] as their locale.
Chinese (Traditional) [zn_HK] is enabled	True if Chinese (Traditional) [zn_HK] is enabled in the system, otherwise false.
Chinese (Traditional) [zn_HK] user count	Number of users who have selected Chinese (Traditional) [zn_HK] as their locale.

News metrics log

The News metrics log (news.csv) records metrics on the number of feeds, posts, comments, and events produced and used on the News tab of the Tempo interface.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Feed Count	Number of feeds in the system.
Feed Opt-Out Count	Total number of opted-out feeds across all users.
Unique Users Who Have Opted-Out	Number of users who have opted-out of at least one feed.
Personalized Subscription Count	Number of personalized feed subscriptions across all users.
Unique Users With Personalized Subscriptions	Number of users who have personalized subscriptions to at least one feed.
Total Event Count	Total number of feed events across all entry types but not including comments.
Business Event Count	Number of events posted by the Post Event to Feed Smart Service.
System Event Count	Number of events posted by the Post System Event to Feed Smart Service.
Message Event Count	Number of message events posted by users.
Kudos Event Count	Number of kudos given by users.
Starred Event Count	Number of starred events across all users.
Unique Event Author Count	Number of unique authors who have posted an event.
Events with Data Table Count	Number of events with associated data tables.
Events with Action Count	Number of events with configured action links.
Total Comments Count	Total number of comments, including hazards.
Hazard Count	Number of hazards.
Unique Comment Author Count	Number of unique authors who have commented on any event.
Most Comments By A Single Author	Number of comments posted by the author with the most comments posted.
Public Event Count	Number of events that are publicly visible.
Mean Users Targeted By A Single Event	Mean number of users that are targeted by non-public events.
Least Users Targeted By A Single Event	Least number of users that are targeted by a single non-public event.
Most Users Targeted By A Single Event	Most number of users that are targeted by a single non-public event.
Mean Groups Targeted By A Single Event	Mean number of groups that are targeted by non-public events.
Least Groups Targeted By A Single Event	Least number of groups that are targeted by a single non-public event.
Most Groups Targeted By A Single Event	Most number of groups that are targeted by a single non-public event.
Social Task Count	Number of social tasks created by all users in the system.
Closed Social Task Count	Number of social tasks closed by all users in the system.
Unique Social Task Author Count	Number of unique users who have sent a social task.
Unique Social Task Recipient Count	Number of unique users who have received a social task.
Unique Events with File Attachments	Number of unique events with at least one file attachment.
Total Event/File Relationships	Total number of links between events and files.
Most File Attachments By Event	Largest number of files attached to a single event.
Unique Files Attached To Events	Number of unique files attached to at least one event.
Most Events By File Attachment	Largest number of events a single file is attached to.
Unique Events with Related Records	Total number of events that are related to at least one record.
Total Event/Record Relationships	Total number of links between events and records.
Most Related Records By Event	Largest number of records associated with a single event.
Unique Records Related To Events	Number of unique records related to at least one event.
Most Events By Related Record	Largest number of events associated with any single record.

OAuth 2.0 Clients metrics log

The OAuth 2.0 Clients log file (oauth_clients.csv) provides information about OAuth 2.0 clients.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Active Clients in the System	The number of active clients in your environment.
Number of Inactive Clients in the System	The number of inactive clients in your environment.
Number of Service Accounts	The number of groups in the Service Accounts system group in your environment.
Max Number of Clients Associate With One Account	The maximum number of clients associated with a single service account in your environment.
Avg Number of Clients Associate per Account	The average number of clients associated with a single service account in your environment.

Package metrics log

The Package metrics log (packages.csv) records information about general package use in the system.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Applications	Total number of applications with at least one package.
Number of Packages	Total number of packages in the system.
Packages without Description	Number of packages without a description.
Packages without a Ticket	Number of packages without a link to a ticket.
Packages with common objects	Number of packages that contain the same objects.
Oldest package	Age of the oldest package in the system in days.
Users Creating Packages	Number of unique developers who have created a package.
Apps with between 1 and 9 packages	Number of applications with between 1 and 9 packages.
Apps with between 10 and 49 packages	Number of applications with between 10 and 49 packages.
Apps with between 50 and 100 packages	Number of applications with between 50 and 100 packages.
Maximum Packages Count	Largest number of packages in a single application.
Packages with between 1 and 9 objects	Number of packages with between 1 and 9 objects.
Packages with between 10 and 49 objects	Number of packages with between 10 and 49 objects.
Packages with between 50 and 99 objects	Number of packages with between 50 and 99 objects.
Packages with between 100 and 499 objects	Number of packages with between 100 and 499 objects.
Packages with between 500 and 999 objects	Number of packages with between 500 and 999 objects.
Packages with more than 999 objects	Number of packages with more than 999 objects.
Maximum Objects Count	Number of objects in the largest package.
Number of packages with just one database script	Number of packages with a single database script.
Packages with between 2 and 5 database scripts	Number of packages with between 2 and 5 database scripts.
Packages with between 6 and 10 database scripts	Number of packages with between 6 and 10 database scripts.
Packages with greater than 10 database script	Number of packages with more than 10 database scripts.
Largest number of scripts in a package	Highest number of database scripts in an individual package.
Packages with 1 plug-in	Number of packages with one plug-in.
Packages with between 2 and 5 plug-ins	Number of packages with between 2 and 5 plug-ins.
Packages with between 6 and 10 plug-ins	Number of packages with between 6 and 10 plug-ins.
Packages with 11 or more plug-ins	Number of packages with 11 or more plug-ins.
Maximum Plug-ins Count	Highest number of database scripts in an individual package.
Packages with application configurations	Number of packages with application configurations.
Packages without application configurations	Number of packages without application configurations.
Packages with an ICF	Number of packages that include an import customization file.

Patch metrics log

The Patch metrics log (patches.csv) provides general usage data about the patches in the system.

Metrics include the following:

Metric	Description
Total Patches	Total patches in the system.
Maximum Patches	Maximum number of patches for a single user in the system.
Mean Patches	Average number of patches for a single user in the system.
Maximum Objects	Maximum number of objects in a single patch.
Mean Objects	Average number of objects in a single patch.

Plug-in metrics logs

The Plug-in metrics log file (plugins.csv) provides information about plug-ins in the system.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Plug-ins	Total number of plug-ins.
Connected System Plug-ins	Total number of connected system plug-ins.
Component Plug-ins	Total number of component plug-ins.
Function and Smart Service Plug-ins	Total number of function and smart service plug-ins.
Plug-in Deployments Enabled	Whether or not the system accepts incoming deployments with plug-in changes. Possible value: true or false.
Update available	Total number of plug-ins with a version status of Update Available.
Not listed in AppMarket	Total number of plug-ins with a version status of Not Listed in AppMarket.

The AppMarket Plug-in Usage Metrics Log (app_market_plugins_usage.csv) provides information about plug-ins deployed in the system from the AppMarket.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Plug-in Key	Unique identifier of the plug-in.
Plug-in Name	Name of the plug-in.
Plug-in Version	Version of the plug-in.
Number of Dependents	Total number of objects that reference the plug-in.
Encryption Service Enabled	Whether or not the plug-in is allowed to encrypt or decrypt values of type Encrypted Text.

Portals metrics log

The Portals Metrics log file (portals.csv) provides information about the portal object.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Portals	Total number of portal objects in the environment.
Minimum Number of Role Map Entries	Least number of users and groups referenced in any portal object's security rolemap.
Maximum Number of Role Map Entries	Maximum number of users and groups referenced in any portal object's security rolemap.
Average Number of Role Map Entries	Average number of users and groups referenced across the portal object's security rolemaps in the system.
Portals with Squared Button Shape	Total number of portal objects that have squared buttons.
Portals with Semi-Rounded Button Shape	Total number of portal objects that have semi-rounded buttons.
Portals with Rounded Button Shape	Total number of portal objects that have rounded buttons.
Portals with Default Loading Bar Color	Total number of portal objects that have the default loading bar color.
Portals with Hex Loading Bar Color	Total number of portal objects that have a loading bar color configured with a hex code.
Portals with Squared Input Shape	Total number of portal objects that use the squared shape for inputs.
Portals with Semi-Rounded Input Shape	Total number of portal objects that use the semi-rounded shape for inputs.
Portals with a Service Account Specified	Total number of portal objects that use a service account.
Portals that are Published	Total number of published portals in the environment.
Portals that are Unpublished	Total number of unpublished portal objects in the environment.
Portals with Recaptcha	Total number of portal objects that use reCAPTCHA.
Portals Configured as PWA	Total number of portal objects that are configured as progressive web apps.
Number of Portal Pages	Total number of pages across all portal objects in the environment.
Portals with Header Bar	Total number of portal objects that have a navigation bar.
Single Page Portals with Header Bar	Total number of single page portal objects that have a navigation bar.
Portals with Display Name	Total number of portal objects that have a display name shown.
Portals with Default Header Bar Color	Total number of portal objects that have a navigation bar configured with the default color.
Portals with Hex Header Bar Color	Total number of portal objects that have a navigation bar configured with a hex code.
Portals with Default Selected Highlight Color	Total number of portal objects that have a selected page highlight color configured with the default color.
Portals with Hex Selected Highlight Color	Total number of portal objects that have a selected page highlight color configured with a hex code.
Number of Record Backed Pie Charts in Portals	Total number of pie charts being used across all portal objects in the environment.
Number of Record Backed Bar Charts in Portals	Total number of bar charts being used across all portal objects in the environment.
Number of Record Backed Scatter Charts in Portals	Total number of scatter charts being used across all portal objects in the environment.
Number of Record Backed Line Charts in Portals	Total number of line charts being used across all portal objects in the environment.
Number of Record Backed Area Charts in Portals	Total number of area charts being used across all portal objects in the environment.
Number of Record Backed Column Charts in Portals	Total number of column charts being used across all portal objects in the environment.
Number of Record Backed Card Choices in Portals	Total number of card choices being used across all portal objects in the environment.
Number of Record Backed Read-Only Grids in Portals	Total number of read-only grids being used across all portal objects in the environment.
Number of Portals with 1 Page	Total number of portals that have 1 page.
Number of Portals with 2 Pages	Total number of portals that have 2 pages.
Number of Portals with 3 Pages	Total number of portals that have 3 pages.
Number of Portals with 4 Pages	Total number of portals that have 4 pages.
Number of Portals with 5 Pages	Total number of portals that have 5 pages.
Number of Portals with 6 Pages	Total number of portals that have 6 pages.
Number of Portals with 7 Pages	Total number of portals that have 7 pages.
Number of Portals with 8 Pages	Total number of portals that have 8 pages.
Number of Portals with 9 Pages	Total number of portals that have 9 pages.
Number of Portals with 10 Pages	Total number of portals that have 10 pages.
Number of portals using rule inputs	Total number of portals that have a portal page using an interface that contains rule inputs.
Number of portals using secure context URLs	Total number of portals that have at least one portal page with rule inputs and the encryption checkbox checked.
Number of portals using plaintext context URLs	at least one portal page with URL parameters, the encryption checkbox unchecked, and at least 1 URL parameter parameter toggled-on.
Number of portals using default values	Total number of portals that have at least one default value.
Number of portals using default values as page inputs	Total number of portals that have at least one rule input that's toggled off and also has a default value.
Number of portals using default values as URL parameters	Total number of portals that have at least one rule input that's toggled on and also has a default value.
Number of Portals with 1 Page Group	Total number of portals that have 1 page group.
Number of Portals with 2 Page Groups	Total number of portals that have 2 page groups.
Number of Portals with 3 Page Groups	Total number of portals that have 3 page groups.
Number of Portals with 4 Page Groups	Total number of portals that have 4 page groups.
Number of Portals with 5 Page Groups	Total number of portals that have 5 page groups.
Number of Portals with 6 Page Groups	Total number of portals that have 6 page groups.
Number of Portals with 7 Page Groups	Total number of portals that have 7 page groups.
Number of Portals with 8 Page Groups	Total number of portals that have 8 page groups.
Number of Portals with 9 Page Groups	Total number of portals that have 9 page groups.
Number of Portals with 10 Page Groups	Total number of portals that have 10 page groups.
Number of Portals with at Least One Group That Has 0 Nested Pages	Total number of portals with at least one page group that has 0 nested pages.
Number of Portals with at Least One Group That Has 1 Nested Page	Total number of portals with at least one page group that has 1 nested page.
Number of Portals with at Least One Group That Has 2 Nested Pages	Total number of portals with at least one page group that has 2 nested pages.
Number of Portals with at Least One Group That Has 3 Nested Pages	Total number of portals with at least one page group that has 3 nested pages.
Number of Portals with at Least One Group That Has 4 Nested Pages	Total number of portals with at least one page group that has 4 nested pages.
Number of Portals with at Least One Group That Has 5 Nested Pages	Total number of portals with at least one page group that has 5 nested pages.
Number of Portals with at Least One Group That Has 6 Nested Pages	Total number of portals with at least one page group that has 6 nested pages.
Number of Portals with at Least One Group That Has 7 Nested Pages	Total number of portals with at least one page group that has 7 nested pages.
Number of Portals with at Least One Group That Has 8 Nested Pages	Total number of portals with at least one page group that has 8 nested pages.
Number of Portals with at Least One Group That Has 9 Nested Pages	Total number of portals with at least one page group that has 9 nested pages.
Number of Portals with at Least One Group That Has 10 Nested Pages	Total number of portals with at least one page group that has 10 nested pages.
Number of portals with HEADER BAR Primary Navigation Layout	Total number of portals that have the header bar layout selected for the navigation bar.
Number of portals with SIDEBAR Primary Navigation Layout	Total number of portals that have the sidebar layout selected for the navigation bar.
Number of portals with Show Display Name ON with HEADER BAR navigation layout	Total number of portals that have the header bar layout selected and "Show portal display name in navigation bar" turned on.
Number of portals with Show Display Name ON with SIDEBAR navigation layout	Total number of portals that have the sidebar layout selected and "Show portal display name in navigation bar" turned on.
Number of single page portals with HEADER BAR navigation layout	Total number of portals with only one page that have the header bar layout selected for the navigation bar.
Number of single page portals with SIDEBAR navigation layout	Total number of portals with only one page that have the sidebar layout selected for the navigation bar.
Number of portals with component plugins	Total number of portals using at least one component plug-in.
Number of Portals using 1 Component Plugin	Total number of portals using one component plug-in.
Number of Portals using 2 Component Plugins	Total number of portals using two component plug-ins.
Number of Portals using 3 Component Plugins	Total number of portals using three component plug-ins.
Number of Portals using 4 or more Component Plugins	Total number of portals using four or more component plug-ins.

Process execution metrics log

The Process execution metrics log file (process.csv) provides information about the different types of processes and nodes that exist in the system.

All counts are for the present time and do not include archived processes or their nodes. If, for example, a paused process is restarted before the log executes, it no longer counts as a paused process.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Processes	Total number of unarchived processes in the execution environment.
Active Processes	Number of processes currently executing.
Completed Processes	Number of processes that have completed but have yet to be archived.
Paused Processes	Number of processes that are paused. A paused process may or may not include a paused node.
Paused by Exception Processes	Number of processes that are paused by exception. A process paused by exception may or may not include nodes that have paused by exception.
Cancelled Processes	Number of processes that have been cancelled but have yet to be archived.
Unfinished Processes	Number of active subprocesses whose parent process has already completed.
Terminating Processes	Number of processes that have reached their end node but have not yet completed it.
Total Nodes	Total number of nodes that have executed as part of unarchived processes.
Completed Nodes	Number of nodes that completed successfully.
Waiting Nodes	Number of attended nodes waiting for user input.
In-Process Nodes	Number of nodes currently executing.
Paused Nodes	Number of nodes that have been paused. This does not include completed, waiting, or in-process nodes in paused processes.
Paused By Exception Nodes	Number of nodes that have paused by exception.

Process insights logs

These logs provide information about Appian's process insights capability. You can find relevant logs about process insights in follow log files:

• Process metrics log
• Process insights and investigations metrics log
• Process insights KPIs log
• Process views log
• Data governance metrics log

Process metrics log

The Process metrics log file (phq_process.csv) provides information about the processes and users involved in process insights.

Metric	Description
Timestamp	Date and time when the metric is taken.
Number Of Processes With Scheduled Updates	Number of processes with scheduled updates.
Number Of Processes Without Scheduled Updates	Number of processes without scheduled updates.
Number Of Processes With Daily Updates	Number of processes with daily updates.
Number Of Processes With Weekly Updates	Number of processes with weekly updates.
Number Of Processes With Monthly Updates	Number of processes with monthly updates.
Number Of Processes With Automation Type	Number of processes with an attribute mapped to the Automation attribute type. If multiple attributes are mapped to the Automation attribute type, only one attribute will be counted.
Number Of Processes Without Automation Type	Number of processes with no attribute mapped to the Automation attribute type.
Number Of Processes With Event User	Number of processes with an attribute mapped to an Event User attribute type. If multiple attributes are mapped to the Event User type in a single process, only one attribute will be counted.
Number Of Processes Without Event User	Number of processes without an attribute mapped to the Event User type.
Number Of Processes With Both Start And End	Number of processes with Start and End timestamps.
Number Of Processes With Only Start	Number of processes with only Start timestamps configured. If multiple Start timestamps are configured for a process, only one is counted.
Number Of Processes With Only End	Number of processes with only End timestamps configured. If multiple end timestamps are configured for a process, only one is counted.
Average Number Of Case Rows	Average number of cases per case record type in the environment.
Maximum Number Of Case Rows	Maximum number of cases per case record type in the environment.
Minimum Number Of Case Rows	Minimum number of cases per case record type in the environment.
Number Of Processes Using Record Events	Number of processes that use a case record type that is configured for record events.
Number Of Processes Not Using Record Events	Number of processes that use a case record type that is not configured for record events.
Number Of Processes With 1 to 5 Case Attributes	Number of processes with 1-5 case attributes.
Number Of Processes With 6 to 10 Case Attributes	Number of processes with 6-10 case attributes.
Number Of Processes With 11 to 20 Case Attributes	Number of processes with 10-20 case attributes.
Number Of Processes With 21 to 30 Case Attributes	Number of processes with 20-30 case attributes.
Number Of Processes With More Than 30 Case Attributes	Number of processes with more than 30 case attributes.
Number Of Processes With 1 to 5 Event Attributes	Number of processes with 1-5 event attributes.
Number Of Processes With 6 to 10 Event Attributes	Number of processes with 6-10 event attributes.
Number Of Processes With 11 to 20 Event Attributes	Number of processes with 10-20 event attributes.
Number Of Processes With 21 to 30 Event Attributes	Number of processes with 20-30 event attributes.
Number Of Processes With More Than 30 Event Attributes	Number of processes with more than 30 event attributes.
Average Attribute Values	Average number of unique attribute values in a process.
Maximum Number Of Event Rows	Maximum number of event rows.
Minimum Number Of Event Rows	Minimum number of event rows.
Average Number Of Event Rows	Average number of event rows.
Average Number Of Analysts	Average number of users with Analyst permissions per process.
Maximum Number Of Analysts	Maximum number of users with Analyst permissions per process.
Minimum Number Of Analysts	Minimum number of users with Analyst permissions per process.
Average Number Of Viewers	Average number of users with Viewer permissions per process.
Maximum Number Of Viewers	Maximum number of users with Viewer permissions per process.
Minimum Number Of Viewers	Minimum number of users with Viewer permissions per process.
Average Number Of Data Stewards	Average number of users with Data Steward permissions per process.
Maximum Number Of Data Stewards	Maximum number of users with Data Steward permissions per process.
Minimum Number Of Data Stewards	Minimum number of users with Data Steward permissions per process.
Groups Based On Date Difference Custom Attribute Count	Total number of groups based on date difference custom attributes in a process.
Minimum Groups Based On Date Difference Custom Attribute Count	Minimum number of groups based on date difference custom attributes in a process.
Average Groups Based On Date Difference Custom Attribute Count	Average number of groups based on date difference custom attributes in a process.
Maximum Groups Based On Date Difference Custom Attribute Count	Maximum number of groups based on date difference custom attributes in a process.
Groups Based On Range Custom Attribute Count	Total number of groups based on range custom attributes in a process.
Minimum Groups Based On Range Custom Attribute Count	Minimum number of groups based on range custom attributes in a process.
Average Groups Based On Range Custom Attribute Count	Average number of groups based on range custom attributes in a process.
Maximum Groups Based On Range Custom Attribute Count	Maximum number of groups based on range custom attributes in a process.
Groups Based On Aggregation Custom Attribute Count	Total number of groups based on aggregation custom attributes in a process.
Minimum Groups Based On Aggregation Custom Attribute Count	Minimum number of groups based on aggregation custom attributes in a process.
Average Groups Based On Aggregation Custom Attribute Count	Average number of groups based on aggregation custom attributes in a process.
Maximum Groups Based On Aggregation Custom Attribute Count	Maximum number of groups based on aggregation custom attributes in a process.
Processes With One Or More Groups Based On Date Diff Custom Attributes	Total number of processes with at least 1 group based on date difference custom attribute.
Processes With One Or More Groups Based On Range Custom Attribute Count	Total number of processes with at least 1 group based on range custom attribute.
Processes With One Or More Groups Based On Aggregation Custom Attribute Count	Total number of processes with at least 1 group based on aggregation custom attribute.
Maximum Number Of Unique Activities Per Process	Maximum number of unique activities in a process.
Minimum Number Of Unique Activities Per Process	Minimum number of unique activities in a process.
Average Number Of Unique Activities Per Process	Average number of unique activities in a process.

Process insights and investigations metrics log

The Process insights and investigations metrics log file (phq_insight.csv) provides information about investigations and insights saved in process insights.

Metric	Description
Timestamp	Date and time when the metric is taken.
Num Investigations Total	Total number of saved investigations in the environment.
Average Potential Savings	Average value of potential savings for saved insights in the environment.
Minimum Potential Savings	Lowest potential savings for saved insights in the environment.
Maximum Potential Savings	Highest potential savings for saved insights in the environment.
Number Of Insights	Total number of saved insights in the environment.
Saved Findings Count	Total number of saved findings across all insights in the environment.
Average Impact Days For Cycle Time Insight	How much (on average) a finding contributes to the total potential savings of saved insights in this environment.
Maximum Impact Days For Cycle Time Insight	The highest amount a finding contributes to the total potential savings of saved insights in this environment.
Minimum Impact Days For Cycle Time Insight	The lowest amount a finding contributes to the total potential savings of saved insights in this environment.
Average Number Of Factors In Insight	Average number of findings in an individual insight in this environment.
Minimum Number Of Factors In Insight	Lowest number of findings in an individual insight in this environment.
Maximum Number Of Factors In Insight	Highest number of findings in an individual insight in this environment.
Average Number of Comments on Insight	Average number of comments on an individual insight in this environment.
Minimum Number of Comments on Insight	Lowest number of comments on an individual insight in this environment.
Maximum Number of Comments on Insight	Highest number of comments on an individual insight in this environment.
Number of Insights with 1 to 5 Comments	Total number of insights with 1 to 5 comments in this environment.
Number of Insights with 6 to 10 Comments	Total number of insights with 6 to 10 comments in this environment.
Number of Insights with 11 to 15 Comments	Total number of insights with 11 to 15 comments in this environment.
Number of Insights with 16 to 20 Comments	Total number of insights with 16 to 20 comments in this environment.
Number of Insights with over 20 Comments	Total number of insights with more than 20 comments in this environment.

Process insights KPIs log

The Process insights KPIs log file (phq_kpi.csv) provides information about the custom KPIs created in process insights.

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Kpi Count	Total number of custom KPIs configured in this environment.
Number Of Sla Kpis	Number of custom SLA KPIs configured in this environment.
Number Of Duration Kpis	Number of custom duration KPIs configured in this environment.
Number Of Aggregation Kpis	Number of custom aggregation KPIs configured in this environment.
Number Of Count Kpis	Number of custom count KPIs configured in this environment.
Average Number Of Kpis	Average number of custom KPIs configured per process.
Minimum Number Of Kpis	Lowest number of custom KPIs configured per process.
Maximum Number Of Kpis	Highest number of custom KPIs configured per process.
Average Number Of Sla Kpis	Average number of custom SLA KPIs per process.
Average Number Of Duration Kpis	Average number of custom duration KPIs per process.
Average Number Of Aggregation Kpis	Average number of custom aggregation KPIs per process.
Average Number Of Count Kpis	Average number of custom count KPIs per process.
Average Number Of Pinned Kpis Per View	Average number of custom KPIs pinned to the Summary tab in a process view.
Minimum Number Of Pinned Kpis Per View	Lowest number of custom KPIs pinned to the Summary tab in a process view.
Maximum Number Of Pinned Kpis Per View	Highest number of custom KPIs pinned to the Summary tab in a process view.

Process views log

The Process views log file (phq_view.csv) provides information about process views created in process insights.

Metric	Description
Timestamp	Date and time when the metric is taken.
Invalid Views Count	Number of invalid process views across all processes in the environment. A view is invalid if the attributes used as filter in the view were missing or changed in the latest process update.
Views Count	Total number of user-created views in the environment.
Average Number of Views	Average number of user-created views per process.
Maximum Number of Views	Highest number of user-created views per process.
Minimum Number of Views	Lowest number of user-created views per process.
Views With Attribute Filters Applied Count	Total number of user-created views configured with at least one attribute filter.
Average Number of Views with Attribute Filters	Average number of user-created views configured with at least one attribute filter.
Maximum Number of Views with Attribute Filters	Highest number of user-created views configured with at least one attribute filter.
Minimum Number of Views with Attribute Filters	Lowest number of user-created views configured with at least one attribute filter configured.
Views with Activity Filter Applied Count	Total number of user-created views configured with at least one activity filter.
Average Number of View Activity Filters	Average number of user-created views configured with at least one activity filter.
Maximum Number of View Activity Filters	Highest number of user-created views configured with at least one activity filter.
Minimum Number of View Activity Filters	Lowest number of user-created views configured with at least one activity filter.
Average Number of View Attribute Value Filters	Average number of attribute value filters configured on a user-created view.
Maximum Number of View Attribute Value Filters	Maximum number of attribute value filters configured on a user-created view.
Minimum Number of View Attribute Value Filters	Minimum number of attribute value filters configured on a user-created view.

Data governance metrics log

The Data governance metrics log file (phq_governance.csv) provides information about data stewards assigned from the Data Governance page of Process HQ and information about the record types used in a process.

Metric	Description
Timestamp	Date and time when the metric is taken.
Unique Data Stewards Assigned Through Governance Count	The total number of unique data stewards assigned to a record type from the Data Governance page.
Data Stewards Assigned Through Governance Count	The total number of data stewards assigned to a record type from the Data Governance page.
Maximum Number of Data Governance Data Stewards	The highest number of data stewards assigned to a record type from the Data Governance page.
Data Governors Count	The total number of users assigned to the Data Governors group.
Record types With At Least One Governance Data Steward Count	The total number of record types with at least 1 data steward assigned from the Data Governance page.
Average Number Of Dependent Process Per Record Type	The average number of processes that use a record type as a data source.
Maximum Number Of Dependent Processes Per Record Type	The maximum number of processes that use a record type as a data source.
Record Types Used In At Least One Mining Process Count	The number of record types that are used as a data source for a process.

Process model metrics log

The Process model metrics log file (models.csv) provides information on the different process models and data types created in the system.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Published Models	Number of published process models.
Draft Models	Number of draft process models.
Past Versions of Models	Number of past versions of process models.
Model Attachments	Number of attachments to published process models.
Model Notes	Number of notes added to published process models (not including notes added to nodes).
Models Configured Without Cleanup	Number of published process models configured to not be archived or deleted after completion.
Models Configured for Archive Cleanup	Number of published process models configured for archival after completion.
Models Configured for Delete Cleanup	Number of published process models configured to be deleted after completion.
Models Configured for Default Cleanup	Number of published process models using the default cleanup action.
Maximum Archive Delay	Longest number of days any published process model is set to wait between completion and archival.
Maximum Deletion Delay	Longest number of days any published process model is set to wait between completion and deletion.
Models with Deadlines	Number of published process models with deadlines.
Swim Lanes	Number of swim lanes in all published process models.
Models Alerting Initiator	Number of published process models configured to alert the process initiator when encountering a problem.
Models Alerting Owners	Number of published process models configured to alert the process owners when encountering a problem.
Models Alerting by Expression	Number of published process models configured to alert based on the results of an expression when encountering a problem.
Models Alerting Users and Groups	Number of published process models configured to alert specific users and groups when encountering a problem.
Nodes	Number of nodes added to all published process models.
Minimum Nodes in a Model	Number of nodes in the published process model with the fewest nodes.
Maximum Nodes in a Model	Number of nodes in the published process model with the most nodes.
Attended Nodes	Number of attended nodes in all published process models.
MNI Nodes	Number of nodes configured to use either sequential or parallel multiple instances in all published process models.
Parallel MNI	Number of nodes configured to use parallel multiple instances in all published process models.
Repeating Nodes	Number of nodes configured to repeat in all published process models.
Scheduled Nodes	Number of nodes configured to start on a schedule in all published process models.
Escalating Nodes	Number of nodes configured to escalate in all published process models.
Quick Tasks	Number of quick tasks in all published process models.
Node Attachments	Number of attachments to nodes in all published process models.
Node Notes	Number of notes on nodes in all published process models.
Model Forms	Number of start forms in all published process models.
Node Forms	Number of node forms in all published process models.
Dynamic Forms	Number of dynamic forms in all published process models and their nodes.
JSP Forms	Number of JSP forms in all published process models and their nodes.
Internal Forms	Number of HTML or PDF forms in all published process models and their nodes.
Mobile Forms	Number of mobile-enabled forms in all published process models and their nodes.
Unchained Flows	Number of non-activity-chained flows in all published process models.
Chained Flows	Number of activity-chained flows in all published process models.
Maximum Rolemap Groups	Maximum number of groups referenced in any process model's security rolemap.
Maximum Rolemap Users	Maximum number of users referenced in any process model's security rolemap.
Mean Rolemap Groups	Average number of groups referenced in any process model's security rolemap.
Mean Rolemap Users	Average number of users referenced in any process model's security rolemap.

Product metrics log

The Product metrics log (product_metrics_details.csv) records information about how the Appian platform is functioning so that Appian Technical Support can help troubleshoot issues. It contains quantitative data only and no sensitive information.

Push notifications metrics log

The Push notifications metrics log file (push_notifications.csv) provides information about mobile users who are using push notifications.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Count of Users with Tokens	Number of mobile users with active tokens.
Count of Users without Tokens	Number of mobile users without active tokens.
Count of Tokens	Number of tokens issued.
Count of Android Tokens	Number of tokens in use on Android devices.
Count of iOS Tokens	Number of tokens in use on iOS devices.
Average Tokens per User	Total number of tokens divided by the total number of mobile users.
Max Tokens for a Single User	Maximum number of active tokens for a single user in the system.

Quick Apps metrics log

The Quick Apps metrics log file (quick_apps.csv) provides information about Quick App usage.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Quick Apps	Total number of Quick Apps created on the system.
Quick Apps in Metrics	Number of Quick Apps that are still editable in the Quick Apps Designer.
Mean Record Count	Average number of records created per Quick App.
Minimum Record Count	Minimum number of records created per Quick App.
Maximum Record Count	Maximum number of records created per Quick App.
Mean Activity Entry Count	Average number of entries in the activity history per Quick App record.
Minimum Activity Entry Count	Minimum number of entries in the activity history per Quick App record.
Maximum Activity Entry Count	Maximum number of entries in the activity history per Quick App record.

Records metrics log

The Records metrics log file (records.csv) provides information about record types.

Metrics in this log include the following:

Metric	Description
Record Type Count	Total number of record types.
Process Model Record Type Count	Number of record types that are backed by process models.
Data Store Entity Record Type Count	Number of record types that are backed by data store entities.
Exportable Data Store Entity Record Type Count	Number of record types that are backed by data store entities and also have the Show Export to Excel Button option enabled.
Unique Users Following Records Count	Total number of users following one or more records.
Average Records Followed By User	Total number of records being followed across all record types divided by the total number of users.
Record Types With Related Actions Count	Count of record types that have one or more related actions associated with them.
Related Actions Count	Total number of related actions across all record types.
Related Actions With Null Titles Count	Total number of related actions with a null display name.
Expression Record Type Count	Number of record types that are backed by expressions.
Exportable Process Model Record Type Count	Number of record types that are backed by process models and also have the Show Export to Excel Button option enabled.
Exportable Expression Record Type Count	Number of record types that are backed by expressions and also have the Show Export to Excel Button option enabled.
Expressionable Default Filters For Data Store Entity Record Type Count	Number of record types that are backed by data store entities and have default filters saved as an expression.
Expressionable Default Filters For Process Model Record Type Count	Number of record types that are backed by process models and have default filters saved as an expression.
Expressionable Default Filters For Expression Record Type Count	Number of record types that are backed by expressions and have default filters saved as an expression.
Default Filters By Field For All Record Types Count	Total number of record types that have default filters saved using the By Field option.
Default Filters By Field For Data Store Entity Record Type Count	Number of record types that are backed by data store entities and have default filters saved using the By Field option.
Default Filters By Field For Process Model Record Type Count	Number of record types that are backed by process models and have default filters saved using the By Field option.
Expression Record Type With Split Source Count	Number of record types that are backed by expressions and use two expressions for the source.
Expression Record Type With Single Source Count	Number of record types that are backed by expressions and use a single expression for the source.
Rule Record Type Count	Total number of rule-backed record types.
Record Type with Grid List View Count	Number of record types using a grid view.
Record Type with Feed List View Count	Number of record types using a feed view.
Data Store Entity Record Type using Grid List View Count	Number of entity-backed record types using a grid view.
Data Store Entity Record Type using Feed List View Count	Number of entity-backed record types using a feed view.
Process Model Record Type using Grid List View Count	Number of process-backed record types using a grid view.
Process Model Record Type using Feed List View Count	Number of process-backed record types using a feed view.
Expression Record Type using Grid List View Count	Number of expression-backed record types using a grid view.
Expression Record Type using Feed List View Count	Number of expression-backed record types using a feed view.
Record Types With User Filters Count	Total number of record types that have user filters.
Data Store Entity Record Types With User Filters Count	Number of record types that are backed by data store entities and have at least one user filter.
Process Model Record Types With User Filters Count	Number of record types that are backed by process models and have at least one user filter.
Expression Record Type with Picker With User Filters Count	Number of expression-backed record types that are configured using expression rule pickers and have at least one user filter.
Record Types With Record List Actions Count	Number of record types that have record list actions configured.
Minimum Number of Role Map Entries	Minimum number of users and groups referenced in any record's security rolemap.
Maximum Number of Role Map Entries	Maximum number of users and groups referenced in any record's security rolemap.
Average Number of Role Map Entries	Average number of users and groups referenced in any record's security rolemap.
Data Store Entity Record Types With Date Range User Filters Count	Number of record types that are backed by data store entities and have at least one date range user filter.
Process Model Record Types With Date Range User Filters Count	Number of record types that are backed by process models and have at least one date range user filter.
Related Actions with the Default Icon	Number of related actions with the default icon.
Related Actions with a Static Icon	Number of related actions with the static icon.
Record Types with the Default Icon	Number of record types with the default icon.
Record Types with a Static Icon	Number of record types with a static icon.
Record Types with the Default Icon Color	Number of record types with the default icon color.
Record Types with a Static Icon Color	Number of record types with a static icon color.
Record Types with an Expressionable Icon Color	Number of record types with an expressionable icon color.
Data Store Entity Record Types With List User Filters Count	Number of data store entity record types with list user filters.
Process Model Record Types With List User Filters Count	Number of process model record types with list user filters.
Hidden Record Type Count	Number of hidden record types.
Record Types with Record List Actions that Launch in a Dialog Count	Number of record types with record list actions configured to launch in a dialog.
Record Types with Record List Actions that Launch in the Same Tab Count	Number of record types with record list actions configured to launch in the same tab.
Record Types with Record List Actions that Launch in a New Tab Count	Number of record types with record list actions configured to launch in a new tab.
Record Views with Shortcuts that Launch in a Dialog Count	Number of record views with related actions configured to launch in a dialog.
Record Views with Shortcuts that Launch in the Same Tab Count	Number of record views with related actions configured to launch in the same tab.
Record Views with Shortcuts that Launch in a New Tab Count	Number of record views with related actions configured to launch in a new tab.
Expression Record Type with Picker Count	Number of expression-backed record types that are configured using expression rule pickers.
Exportable Expression Record Type with Picker Count	Number of expression-backed record types that are configured using expression rule pickers and also have the Show Export to Excel Button option enabled.
Expression Record Type with Picker using Grid List View Count	Number of expression-backed record types configured using expression rule pickers using a grid view.
Expression Record Type with Picker using Feed List View Count	Number of expression-backed record types configured using expression rule pickers using a feed view.
Expression Record Type with Picker With User Filters Count	Number of expression-backed record types that are configured using expression rule pickers and have at least one user filter.
Average Number of User Filters for Expression Record Type with Picker	Average number of user filters specified across expression-backed record types configured using expression rule pickers.
Expression Record Type with Picker with Search Text Mapped	The number of expression-backed record types configured using expression rule pickers that have Search Text mapped to a rule input.
Expression Record Type with Picker with Paging Info Mapped	The number of expression-backed record types configured using expression rule pickers that have Paging Info mapped to a rule input.
Record Types with no Header style or standard Header style	Number of record types with no header style or standard header style.
Record Types with a Static Header Color	Number of record types with a static header color.
Record Types with a Variable Header Color	Number of record types with a variable header color.
Record Types with an Expressionable Header Color	Number of record types with expressionable header color.
Record Types with a Document Header Image	Number of record types with a document header image.
Record Types with a URL Header Image	Number of record types with a URL header image.
Record Types with a Variable Header Image	Number of record types with a variable header image.
Record Types with a Expressionable Header Image	Number of record types with an expressionable header image.
Record Types with invalid JSON for their header config	Number of record types with invalid JSON for the header.
Record Types that have Record Action Uuids	Number of record types that just have the Appian 20.1 update to use record action field.
Record Types that use Field References and Records-Powered Grid	Number of record types updated in Appian 20.3 to use record data in grids.
Synced Database Record Type Count	Total number of synced record types with a database table as their source.
Synced Salesforce Record Type Count	Total number of synced record types with Salesforce as their source.
Exportable Synced Database Record Type Count	Number of synced record types that have a database as their source and also have the Show Export to Excel Button option enabled.
Exportable Synced Salesforce Record Type Count	Number of synced record types that have Salesforce as their source and also have the Show Export to Excel Button option enabled.
Expressionable Default Filters For Synced Database Record Type Count	Number of synced record types that have a database as their source and have default filters saved as an expression.
Expressionable Default Filters For Synced Salesforce Record Type Count	Number of synced record types that have Salesforce as their source and have default filters saved as an expression.
Default Filters By Field For Synced Database Record Type Count	Number of synced record types that have a database table as their source and have default filters saved using the By Field option.
Default Filters By Field For Synced Salesforce Record Type Count	Number of synced record types that have Salesforce as their source and have default filters saved using the By Field option.
Synced Database Record Types With Grid List View Count	Total number of synced record types that have a database table as their source and are also using a grid view.
Synced Database Record Types With Feed List View Count	Total number of synced record types that have a database table as their source and are also using a feed view.
Synced Salesforce Record Types With Grid List View Count	Total number of synced record types that have Salesforce as their source and are also using a grid view.
Synced Salesforce Record Types With Feed List View Count	Total number of synced record types that have Salesforce as their source and are also using a list view.
Synced Database Record Types With User Filters Count	Total number of synced record types that have a database table as their source and also have user filters.
Synced Salesforce Record Types With User Filters Count	Total number of synced record types that have Salesforce as their source and also have user filters.
Synced OWS Record Type Count	Number of synced record types backed by other web services.
Exportable Synced OWS Record Type Count	Number of synced record types backed by other web services with export enabled.
Expressionable Default Filters For Synced OWS Record Type Count	Number of expressionable default filters configured on synced record types backed by other web services.
Default Filters By Field For Synced OWS Record Type Count	Number of static default filters configured on synced record types backed by other web services.
Synced OWS Record Types With Grid List View Count	Number of synced record types backed by other web services with Grid list view.
Synced OWS Record Types With Feed List View Count	Number of synced record types backed by other web services with Feed list view.
Synced OWS Record Types With User Filters Count	Number of synced record types backed by other web services with user filters.
Record Types with hidden News view only	Record types with the News view hidden.
Record Types with hidden News view and Related Actions view	Record types with both the News and the Related Actions views hidden.
Record Types with hidden Related Actions view only	Record types with the Related Actions view hidden.
Synced Database Record Types With Source Filters Count	Count of database-backed record types that have a sync filter (formerly known as a source filter) configured to filter by source fields.
Synced Salesforce Record Types With Source Filters Count	Count of Salesforce-backed record types that have a sync filter (formerly known as a source filter) configured to filter by source fields
Many to One Relationship Type Count	Count of many-to-one relationships.
One to One Relationship Type Count	Count of one-to-one relationships.
Record Types with Relationships Count	Count of record types with at least one relationship.
Synced Record Types Where Max Reached Due To Total Number Of Fields	Number of synced record types that have reached the maximum number of custom record fields because the record type has the maximum number of record fields.
Synced Record Types Where Max Reached Due To Custom Record Field Max	Number of synced record types that have reached the maximum number of custom record fields because the record type has the maximum number of custom record fields.
Synced Record Types With Custom Record Fields Count	Number of synced record types that have custom record fields.
Custom Record Fields Count	Number of custom record fields across all synced record types.
Synced Record Type User Filter Count	Number of user filters on record types with data sync enabled.
User Filters from Foreign Key Count	Number of user filters created using a foreign key.
User Filters from Direct Related Record Fields Count	Number of user filters created using a related record field from a many-to-one relationship where the choice options are a list of related record field values.
One to Many Relationship Type Count	Number of one-to-many record type relationships.
Record Actions with Large Dialog Size	Number of record actions with a large dialog size.
Record Actions with Medium Dialog Size	Number of record actions with a medium dialog size.
Record Actions with Small Dialog Size	Number of record actions with a small dialog size.
Synced Records With Rate Limit Count	Number of synced record types that have the rate limit enabled.
Record Types With Multiple Record List Actions Count	Number of record types with multiple record list actions.
Total Record List Actions Count	Total number of record list actions.
Record Types with Record List Search Box Disabled	Number of record types with the record list search disabled.
Record Types with Custom Search Fields	Number of record types that limit the record list search to specific fields.
Record Types with Expressionable Placeholder Text	Number of record types that use a custom placeholder in the record list search.
Max number of record relationships on a single record type	The maximum number of record type relationships on a record type.
Synced records with skip failure enabled	Number of synced record types that have Skip Failed Syncs enabled.
Summary Tab With Expressionable Name Count	Number of record types with a summary view name configured with an expression.
Summary Tab With Default Name Count	Number of record types with the default summary view name.
RLS rules configured	Total number of security rules configured in your environment.
RLS rules configured with Group membership	Number of security rules configured with the Users found in groups option.
RLS rules configured with Group membership with multiple groups	Number of security rules configured with the Users found in groups option where more than one group is selected.
RLS rules configured with Field membership	Number of security rules configured with the Users found in fields option.
RLS rules configured with Field membership with multiple fields	Number of security rules configured with the Users found in fields option where more than one field is selected.
RLS rules configured with inheritance membership	Number of security rules configured with the Users who can view related records option.
RLS rules configured with any references to relationships	Number of security rules that reference a related record field.
Max number of RLS rules on a single record type	Maximum number of security rules configured on a record type.
RLS rules configured with condition sets	Number of security rules configured with a condition set.
Count of all disabled security rules	Total number of disabled security rules.
Record types with all security rules disabled	Number of record types that have all security rules disabled.
Max depth of RLS rules with nested condition sets	Maximum depth for condition set nesting across all security rules.
Number of Relationships Between Record Types With Different Source Types	Number of relationships between record types that have a different source type (database, process model, Salesforce, or web service).
Record Types with a Fixed Header	Number of record types that use a fixed header.
Record Types without a Fixed Header	Number of record types that don't use a fixed header.
Record Types with a Fixed Header and No Header Style	Number of record types that use a fixed header and no header style.
Record Types with a Fixed Header and Color Header Style	Number of record types that use a fixed header and a color header style.
Record Types with a Fixed Header and Image Header Style	Number of record types that use a fixed header and an image header style.
Record Types that use a sync expression	Number of service-backed record types that have a sync expression configured.
Synced Records With Sequence Count	Number of record types that use a sequence to generate primary key values for records created by Appian.
User Record is Sync Enabled	Whether or not the User record type was updated to have data sync enabled.
Count of relationships with the User Record as the target record type	Number of relationships to the User record type.
Count of custom fields that contain a reference to a User Record Field	Number of custom record fields that reference a field in the User record type.
Record Types With Data Stewards	Total number of record types that have at least one user or group assigned Data Steward permissions.
Average Number Of Data Stewards On a Record Types	Average number of record types that have at least one user or group assigned Data Steward permissions.
Minimum Number Of Data Stewards On a Record Type	Minimum number of record types that have at least one user or group assigned Data Steward permissions.
Maximum Number Of Data Stewards On a Record Type	Maximum number of record types that have at least one user or group assigned Data Steward permissions.
Record Types With Record Events And Data Stewards	Total number of record types that have record events configured and have at least one user or group assigned Data Steward permissions.
Record Types With Record Events And No Data Stewards	Total number of record types with record events configured, but do not have any users or groups assigned Data Steward permissions.
Record Types With Data Stewards And No Record Events	Total number of record types without record events configured, but have at least one user or group assigned Data Steward permissions.
Record Types With Data Stewards And Record-Level Security (RLS)	Total number of record types with record-level security configured and at least one user or group assigned Data Steward permissions.
Record Types With Data Stewards And No Record-Level Security (RLS)	Total number of record types without record-level security configured and at least one user or group assigned Data Steward permissions.
Records-Backed Record Type Count	Number of records-backed record types.
Exportable Records-Backed Record Type Count	Number of records-backed record types that have the Show Export to Excel Button option enabled.
Records-Backed Record Types With Grid List View Count	Number of records-backed record types using a grid view for the record list.
Records-Backed Record Types With Feed List View Count	Number of records-backed record types using a list view for the record list.
Records-Backed Record Type With User Filters Count	Number of records-backed record types that have at least one user filter.
Synced Database Record types with Recovery Sync Count	Number of database-backed record types that have the Recover smart service syncs option enabled.
Synced Salesforce Record Types with Recovery Sync Count	Number of Salesforce-backed record types that have the Recover smart service syncs option enabled.
Synced OWS Record Types with Recovery Sync Count	Number of service-backed record types that have the Recover smart service syncs option enabled.

Reports metrics log

The Tempo report metrics log file (tempo_reports.csv) provides information about Tempo reports.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Tempo Reports	Total number of Tempo reports in the system.
Minimum Number of Role Map Entries	Minimum number of users and groups referenced in any Tempo report's security rolemap.
Maximum Number of Role Map Entries	Maximum number of users and groups referenced in any Tempo report's security rolemap.
Average Number of Role Map Entries	Average number of users and groups referenced in any Tempo report's security rolemap.

Search server metrics log

The Search server metrics log file (search_server.csv) provides information on the search server component of the Appian architecture. This information is written by an agent within the application server, so in a multiple application server environment this log will be written on each application server running rather than the machine(s) running the search server (if separate).

If there is an error when connecting to the search server to gather the metrics, the values in the numeric columns will be -1 and the text-based columns will have an error message or be blank.

All of the total Count and Time columns are calculated since the last startup of the search server. Restarting the application server running the search server will cause these values to reset to 0 in the next write to the log.

The full set of metrics are as follows:

Metric	Description
Timestamp	Date and time when the metric is taken.
Node UUID	Unique identifier of the node to which this row of metrics belongs.
Node Name	Name of the node to which this row of metrics belongs.
Host	Hostname of the server running the node.
Transport Address	IP address and port on which the node of the search server is listening.
Document Count	Number of non-deleted documents in all indices combined.
Deleted Document Count	Number of documents marked as deleted in all indices combined. The system automatically reclaims deleted document space as needed.
Store Disk Size (MB)	Amount of disk space used by this node.
Data Partition Space Remaining (MB)	Amount of disk space remaining on the disk partition mounting the search server data directory.
Disk Throttling Time (ms)	Amount of time in milliseconds the search server spent throttling the disk I/O since the last startup. This can happen when the writes overwhelm the disk I/O. A rapidly increasing number can be indicative of insufficient disk speed.
Active Indexing Count	Number of items that are being indexed at the current time.
Indexing Count	Total number of items indexed.
Indexing Time (ms)	Total amount of time in milliseconds that the search server spent indexing since the last startup. The ratio of index count to index time can give you a sense of indexing efficiency. The difference between the current printout and the previous printout can give a more granular view of the current indexing health.
Indexing Queue Count	Number of work items in the indexing queue waiting to be processed.
Indexing Rejection Count	Number of work items that were rejected because the indexing queue was full.
Bulk Indexing Queue Count	Number of work items in the bulk indexing queue waiting to be processed.
Bulk Indexing Rejection Count	Number of work items that were rejected because the bulk indexing queue was full.
Search Query Count	Total number of search queries performed.
Search Query Time (ms)	Total amount of time in milliseconds that the search server spent in search queries since the last startup.
Search Fetch Count	Total number of fetches that result from search queries.
Search Fetch Time (ms)	Total amount of time in milliseconds that the search server spent in fetching query results since the last startup. A fetch time that is greater than query time can be indicative of a slow disk.
Search Queue Count	Number of work items in the search queue waiting to be processed.
Search Rejection Count	Number of work items that were rejected because the search queue was full.
Active Merge Count	Number of merges that are taking place at the current time.
Merge Count	Total number of merges performed.
Merge Time (ms)	Amount of time the search server has spent merging since the last startup.
Merge Queue Count	Number of work items in the merge queue waiting to be processed.
Merge Rejection Count	Number of work items that were rejected because the merge queue was full.
Filter Cache Memory Size (MB)	Amount of memory used by the filter cache.
Filter Cache Evictions	Number of evictions that have taken place in the filter cache.
ID Cache Memory Size (MB)	Amount of memory used by the memory cache.
Field Data Memory Size (MB)	Amount of memory used by field data.
Field Data Evictions	Number of evictions field data. A value greater than 0 can be an indication of not enough memory is available to the search server.
Field Data Breaker Triggers	Number of times the circuit breaker has triggered for field data. This happens when the field data memory usage is greater than 15% of heap size. A value other than 0 means the JVM needs more memory to efficiently handle data queries.
Segment Count	Number of segments in the search index.
Segment Memory Size (MB)	Amount of memory used by segments.
Thread Count	Current number of threads used by JVM that is running the search server.
Thread Count Peak	Peak number of threads used by JVM that is running the search server.
Open File Descriptors	Number of file descriptors currently in use by JVM that is running the search server. It is not uncommon to have several thousand open file descriptors.
Used Heap Space (MB)	Amount of Java heap space (memory) used by JVM that is running the search server.
Used Heap Percentage	Percentage of the available Java heap space used by the JVM running the search server. A value approaching 100 indicates insufficient memory the JVM.
Available Heap Space (MB)	Total amount of Java heap space (memory) available to JVM that is running the search server. This is the value configured as max heap the JVM.
Young Collection Count	Number of Java garbage collections that have occurred in the young generation space for the JVM that is running the search server.
Young Collection Time (ms)	Amount of time spent in garbage collection for the young generation collections since the last search server startup.
Young Space Used (MB)	Amount of Java heap space (memory) used by the young (eden) generation space for the JVM that is running the search server.
Survivor Space Used (MB)	Amount of Java heap space (memory) used by the survivor space for the JVM that is running the search server.
Tenured Collection Count	Number of Java garbage collections that have occurred in the tenured generation space for the JVM that is running the search server.
Tenured Collection Time (ms)	Amount of time spent in garbage collection for the tenured generation collections since the last search server startup.
Tenured Space Used (MB)	Amount of Java heap space (memory) used by the tenured (old) generation space for the JVM that is running the search server.

Search server cluster metrics log

The Search server cluster metrics log file (search_server_cluster.csv) provides information on the overall health of the search server cluster and the number of nodes and shards in the cluster. The information is written to the file even in environments where there is only a single search server node. In that case it is a cluster of one node. This information is written by an agent within the application server, so in a multiple application server environment this log will be written on each application server rather than the machine(s) running the search server (if separate).

If there is an error when connecting to the search server to gather the metrics, the values in the numeric columns will be -1 and the text-based columns will have an error message or be blank.

Metric	Description
Timestamp	Date and time when the metric is taken.
Cluster Name	Name of the search server cluster. The default cluster name is appian-search-cluster.
Status	Overall health status of the cluster. An error statement is printed to the status column if an error occurs while attempting to query the cluster health. GREEN - All of the configured nodes are up and running and all shards are allocated to those nodes. The search server can accept reads and writes. YELLOW - Some shards are not allocated to nodes, most likely because one or more of the configured nodes are unavailable. The search server can accept reads and writes. RED - The search server cluster no longer has a master node because fewer than half plus one of the configured nodes are available. The search server will continue to serve read requests, but will not be able to accept writes.
Timed Out	Whether or not the attempt to query the cluster health timed out. Possible value: true or false
Number of Nodes	Total number of nodes currently running in the cluster.
Number of Data Nodes	Number of nodes currently running in the cluster that can accept data, either as writes from the Appian EAR or as replicated data from other nodes.
Active Primary Shards	Number of shards that are active and accept writes from the Appian EAR.
Active Shards	Total number of shards that are active, including both primary and replica shards. This number is the number of active shards times the number of nodes in the cluster.
Relocating Shards	Number of shards that are in the process of moving from one node to another. It is important not to make changes to the search cluster while this number is non-zero.
Initializing Shards	Number of shards that are currently being initialized. This occurs when the indices are first created either at system startup or on first usage.
Unassigned Shards	Number of shards that are currently not assigned to any nodes. This number will be non-zero when one or more of the configured nodes is unavailable.

Self-Service Analytics log

The Self-Service Analytics log file (self_service_analytics.csv) provides information about the record types available to business users in data fabric insights (formerly called self-service analytics), and the types of reports and dashboards they've created.

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Number of Saved Reports	Total number of saved reports.
Total Number of Saved Reports That Are Marked Private	Total number of saved reports that are not shared.
Total Number of Saved Reports That Are Marked Shared	Total number of saved reports that are shared.
Number of Reports Using the Grid Design	Number of saved reports that use the Grid design.
Number of Reports Using the Pie Chart Design	Number of saved reports that use the Pie Chart design.
Number of Reports Using the Line Chart Reports	Number of saved reports that use the Line Chart design.
Number of Reports Using the Area Chart Reports	Number of saved reports that use the Area Chart design.
Number of Reports Using the Bar Chart Reports	Number of saved reports that use the Bar Chart design.
Number of Reports Using the Column Chart Reports	Number of saved reports that use the Column Chart design.
Number of Reports KPI Chart Reports	Number of saved reports that use a KPI design.
Number of Reports With an Aggregated Grid	Number of saved reports that use the Grid design with aggregated data.
Number of Reports With a Non-Aggregated Grid	Number of saved reports that use the Grid design with non-aggregated data.
Number of Reports With a Charts Design and the Grid Shown Below	Number of saved reports that use a chart design and show the grid of selected data below.
Number of Reports With Export Enabled	Number of saved reports that show the Export to Excel button.
Number of Reports With Image Download Enabled	Number of saved reports that show the Download Chart Image button.
Count of record types shown in SSA - all sources	Count of record types available in self-service analytics.
Count of record types shown in SSA - MariaDB Cloud (Appian default db)	Count of record types available in self-service analytics that use Appian’s cloud database (MariaDB) as the source.
Count of record types shown in SSA - MariaDB	Count of record types available in self-service analytics that use MariaDB as the source.
Count of record types shown in SSA - MySQL	Count of record types available in self-service analytics that use MySQL as the source.
Count of record types shown in SSA - Postgres	Count of record types available in self-service analytics that use Postgres as the source.
Count of record types shown in SSA - SQL Server	Count of record types available in self-service analytics that use SQL Server as the source.
Count of record types shown in SSA - Oracle	Count of record types available in self-service analytics that use Oracle as the source.
Count of record types shown in SSA - DB2	Count of record types available in self-service analytics that use DB2 as the source.
Count of record types shown in SSA - Salesforce	Count of record types available in self-service analytics that use Salesforce as the source.
Count of record types shown in SSA - Expression backed record	Count of record types available in self-service analytics that use a web service as the expression.
Minimum Number of Fields Across Reports	Minimum number of fields used on a saved report.
Maximum Number of Fields Across Reports	Maximum number of fields used on a saved report.
Average Number of Fields Across Reports	Average number of fields used on a saved report.
Minimum Number of Filters Across Reports	Minimum number of filters on a saved report.
Maximum Number of Filters Across Reports	Maximum number of filters on a saved report.
Average Number of Filters Across Reports	Average number of filters on a saved report.
Minimum Number of Sorts Across Reports	Minimum number of sorts applied to a saved report.
Maximum Number of Sorts Across Reports	Maximum number of sorts applied to a saved report.
Average Number of Sorts Across Reports	Average number of sorts applied to a saved report.
Count of Reports with at least one Action	Count of saved reports that have at least one record action.
Count of Reports with at least one Record List Action	Count of saved reports that have at least one record action.
Count of Reports with at least one Related Action	Count of saved reports that have at least one related action.
Minimum number of Actions on single report	Minimum number of record actions displayed on a saved report.
Maximum number of Actions on a single report	Maximum number of record actions displayed on a saved report.
Average number of Actions on a single report	Average number of record actions displayed on a saved report.
Minimum number of Record List Actions on a single report	Minimum number of record list actions on a saved report.
Maximum number of Record List Actions on a single report	Maximum number of record list action on a saved report.
Average number of Record List Actions on a single report	Average number of record list actions on a saved report.
Minimum number of Related Actions on a single report	Minimum number of related actions on a saved report.
Maximum number of Related Actions on a single report	Maximum number of related actions on a saved report.
Average number of Related Actions on a single report	Average number of related actions on a saved report.
Number of KPI Reports	Number of saved reports that use a KPI design.
Total Number of Saved Dashboards - All	Total number of saved dashboards.
Total Number of Saved Dashboards - Private	Number of saved dashboards that are not shared.
Total Number of Saved Dashboards - Shared	Number of saved dashboards that are shared.
Minimum Number of Reports Across Dashboards	Minimum number of reports displayed on a saved dashboard.
Maximum Number of Reports Across Dashboards	Maximum number of reports displayed on a saved dashboard.
Average Number of Reports Across Dashboards	Average number of reports on a saved dashboard.

Sites metrics log

The Sites metrics log file (sites.csv) provides information about sites.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Sites	Total number of sites in the system.
Number of Site Pages	Total number of pages across all sites in the system.
Number of Task Report Pages	Total number of pages containing a task report across all sites in the system.
Number of Action Pages	Total number of pages containing an action across all sites in the system.
Number of Pages with Titles Configured via Expression	Total number of pages that have titles configured via expression across all sites in the system.
Number of Pages with Visibility Configured via Expression	Total number of pages that have visibility configured via expression across all sites in the system.
Number of Record List Pages	Total number of pages containing a record list across all sites in the system.
Number of Report Pages	Total number of pages containing a Tempo report across all sites in the system.
Number of Branded Sites	Total number of sites that have branding configured in the system.
Number of Sites with Record News	Total number of sites that are configured to show record news.
Minimum Number of Role Map Entries	Minimum number of users and groups referenced in any site's security rolemap.
Maximum Number of Role Map Entries	Maximum number of users and groups referenced in any site's security rolemap.
Average Number of Role Map Entries	Average number of users and groups referenced in any site's security rolemap.
Sites with Mobile Task List Enabled Always	Total number of sites that have the mobile task list configuration enabled.
Sites with Mobile Task List Disabled	Total number of sites that have the mobile task list configuration disabled.
Sites with Mobile Task List Enabled for Select Groups	Total number of sites that have mobile task list configuration enabled only for selected groups.
Sites with Squared Button Shape	Total number of sites that are configured to have squared buttons.
Sites with Semi-Rounded Button Shape	Total number of sites that are configured to have semi-rounded buttons.
Sites with Rounded Button Shape	Total number of sites that are configured to have rounded buttons.
Sites with Accent Loading Bar Color	Total number of sites that utilize the default loading bar color.
Sites with Hex Loading Bar Color	Total number of sites that have a loading bar color configured with a hex code.
Sites with Expressionable Loading Bar Color	Total number of sites that have a loading bar color configured with an expression.
Sites with Helium Header Bar Style	Total number of sites that utilize the helium header bar style.
Sites with Mercury Header Bar Style	Total number of sites that utilize the mercury header bar style.
Number of Interface Pages	Total number of sites pages containing an interface across all sites in the system.
Sites with Squared Input Shape	Total number of sites that use the squared shape for inputs.
Sites with Semi-Rounded Input Shape	Total number of sites that use the semi-rounded shape for inputs.
Sites with Static Display Name	Total number of sites that have a display name configured with static text.
Sites with Expressionable Display Name	Total number of sites that have a display name configured with an expression.
Number of sites with 0 pages	Total number of sites that have 0 pages.
Number of sites with 1 page	Total number of sites that have 1 page.
Number of sites with 2 pages	Total number of sites that have 2 pages.
Number of sites with 3 pages	Total number of sites that have 3 pages.
Number of sites with 4 pages	Total number of sites that have 4 pages.
Number of sites with 5 pages	Total number of sites that have 5 pages.
Number of sites with 6 pages	Total number of sites that have 6 pages.
Number of sites with 7 pages	Total number of sites that have 7 pages.
Number of sites with 8 pages	Total number of sites that have 8 pages.
Number of sites with 9 pages	Total number of sites that have 9 pages.
Number of sites with 10 pages	Total number of sites that have 10 pages.
Number of sites with 0 page groups	Total number of sites that have 0 page groups.
Number of sites with 1 page group	Total number of sites that have 1 page group.
Number of sites with 2 page groups	Total number of sites that have 2 page groups.
Number of sites with 3 page groups	Total number of sites that have 3 page groups.
Number of sites with 4 page groups	Total number of sites that have 4 page groups.
Number of sites with 5 page groups	Total number of sites that have 5 page groups.
Number of sites with 6 page groups	Total number of sites that have 6 page groups.
Number of sites with 7 page groups	Total number of sites that have 7 page groups.
Number of sites with 8 page groups	Total number of sites that have 8 page groups.
Number of sites with 9 page groups	Total number of sites that have 9 page groups.
Number of sites with 10 page groups	Total number of sites that have 10 page groups.
Number of sites with 0 pages per page group	Total number of sites that have 0 pages per page group.
Number of sites with 1 page per page group	Total number of sites that have 1 page per page group.
Number of sites with 2 pages per page group	Total number of sites that have 2 pages per page group.
Number of sites with 3 pages per page group	Total number of sites that have 3 pages per page group.
Number of sites with 4 pages per page group	Total number of sites that have 4 pages per page group.
Number of sites with 5 pages per page group	Total number of sites that have 5 pages per page group.
Number of sites with 6 pages per page group	Total number of sites that have 6 pages per page group.
Number of sites with 7 pages per page group	Total number of sites that have 7 pages per page group.
Number of sites with 8 pages per page group	Total number of sites that have 8 pages per page group.
Number of sites with 9 pages per page group	Total number of sites that have 9 pages per page group.
Number of sites with 10 pages per page group	Total number of sites that have 10 pages per page group.
Sites with HEADER BAR Primary Navigation Layout	Total number of sites that have the header bar layout selected for the navigation bar.
Sites with SIDEBAR Primary Navigation Layout	Total number of sites that have the sidebar layout selected for the navigation bar.
Sites with SIDEBAR Primary Navigation Layout and Show Display Name	Total number of sites that have the sidebar layout selected and "Show site display name in navigation bar" turned on.
Number of sites using rule inputs	The number of sites that have a site page using an interface that contains rule inputs
Number of sites using an encrypted URL parameter	The number of sites that have at least one site page with supported rule inputs and the encryption checkbox checked.
Number of sites using a plaintext URL parameter	The number of sites that have at least one site page with URL parameters, the encryption checkbox unchecked, and at least one URL parameter toggled-on.
Number of sites using a default value	Count of sites with at least one default value.
Number of sites using a default value without URL parameters	Count of sites with at least one rule input that is toggled off and also has a default value.
Number of sites using a default value with URL parameters	Count of sites with at least one rule input that is toggled on and also has a default value.

Solution versions metrics log

The Solution versions metrics log file (solution_versions.csv) provides information about the versions of Appian Solutions present on the environment. Each solution application includes a constant that tracks its major and minor version.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Solution Name	Name of the solution present on the environment.
Constant UUID	UUID for the constant.
Version	Version of the solution present on the environment, according to the constant.
Last Modified Timestamp	Date and time when the constant was last modified.

SSL Certificates metrics log

The SSL Certificates metrics log file (ssl_certificates.csv) provides information about SSL Certificates.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Number of Client Certificates in the System	The number of certificates uploaded to the Client Certificates grid in the admin console.
Number of Trusted Certificates in the System	The number of certificates uploaded to the Trusted Server Certificates grid in the admin console.

System metrics logs

The System metrics log file (system.csv) provides information about the JVM environment.

Due to the fluid nature of this data, these are recorded every five minutes. In certain environments one or more metrics may not be available. When not available, a column remains present but the value is set to -1. Deprecated columns are left blank.

Some columns are not available on Windows.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Thread Count	Total number of threads running within the JVM. - This includes threads in pools for application server requests and external data sources.
Daemon Thread Count	Number of daemon threads running within the JVM. - Daemon threads are long-lived threads that perform system tasks.
Used Heap Space (MB)	Amount of memory currently in use by the JVM heap.
Available Heap Space (MB)	Amount of memory available for use by the JVM heap.
Tenured Generation Usage After Collection (MB)	Amount of memory used by Java's tenured or "old" generation after the most recent garbage collection.
Tenured Generation Used (MB)	Amount of memory currently used by Java's tenured or "old" generation.
Tenured Generation Available (MB)	Amount of memory available for use by Java's tenured or "old" generation.
Permanent Generation Used (MB)	Java 8 does not have a permanent generation space. This column will always have the value -1.
Permanent Generation Available (MB)	Java 8 does not have a permanent generation space. This column will always have the value -1.
Young Collection Count	Number of minor garbage collections in the last interval.
Young Collection Time (ms)	Time spent on minor garbage collections in the last interval.
Tenured Collection Count	Number of major garbage collections in the last interval.
Tenured Collection Time (ms)	Time spent on major garbage collections in the last interval. - This only includes time spent with the rest of the JVM paused and does not include time spent on concurrent garbage collection.
Disk Partition Used (MB)	Formerly, the amount of disk space used on the partition hosting /_admin/.
Disk Partition Available (MB)	Formerly, the amount of disk space available on the partition hosting /_admin/.
Load Average	Average number of runnable CPU processes over the past five minutes.
CPU Core Count	Number of cores on the system, provided here to aid in interpreting the load average.
Total System Memory (MB)	Amount of system memory available on this server.
Used System Memory (MB)	Amount of system memory currently used on this server. This number includes only memory used for applications and does not include space used for transient caches and buffers.
Total Swap Space (MB)	Amount of swap space available on this server.
Used Swap Space (MB)	Amount of swap space currently used on this server.
Session Count	Number of active application server sessions.

The Engine System metrics log file (engine_system.csv) provides information about the engine server.

Like system.csv, these metrics are recorded every five minutes.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Load Average	Average number of runnable CPU processes over the past five minutes.
Configured Engine Count	Number of engines configured to run on this server, provided here to aid in interpreting the load average.
CPU Core Count	Number of cores on the system, provided here to aid in interpreting the load average.
Total System Memory (MB)	Amount of system memory available on this server.
Used System Memory (MB)	Amount of system memory currently used on this server. This number includes only memory used for applications and does not include space used caches and buffers.
Total Swap Space (MB)	Amount of swap space available on this server.
Used Swap Space (MB)	Amount of swap space currently used on this server.
Rollbacks	Number of rollback .l files present in the <AE_HOME>/logs/ directory.
Transaction Replay Errors	Number of transaction replay error .l files present in the <AE_HOME>/logs/ directory.
Write To Disk Errors	Number of write to disk error .l files present in the <AE_HOME>/logs/ directory.
Incremental Update Errors	Number of incremental update error .l files present in the <AE_HOME>/logs/ directory.
Replication Failures	Number of replication failure .l files present in the <AE_HOME>/logs/ directory.
Memory Spike Warnings	Number of memory spike warning .l files present in the <AE_HOME>/logs/ directory.
Long Transaction Warnings	Number of long transaction warning .l files present in the <AE_HOME>/logs/ directory.

Translation set metrics log

The Translation set log (translationSet.csv) records metrics on the translation sets in the environment.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Total Number Of Translation Sets In The System	Total number of translation sets in the environment.
Maximum Number Of Translation Strings For Any Translation Set In The System	The number of the most translation strings within any translation set in the environment.
Minimum Number Of Translation Strings For Any Translation Set In The System	The number of the least translation strings within any translation set in the environment.
Average Number Of Translation Strings Per Translation Set	The average number of translation strings per translation set in the environment.
Average Number Of Translation Sets Per Application	The average number of translation sets per application in the environment.
Most Used Primary Locale for The Translation Set	The most commonly used primary translation locale for the translation sets in the environment.
Most Used Supported Locale for The Translation Set	The most commonly used translation locale for the translation sets in the environment.

Typefaces metrics logs

The Typefaces log (typefaces.csv) records metrics on the typefaces enabled in the environment.

Metrics include the following:

Metric	Description
Number of Custom Typeface	This metric captures whether an Appian environment has a custom typeface enabled.
Custom Typeface Active	This is the total number of custom typefaces an administrator has added to their Appian environment.

User metrics logs

The User metrics log (users.csv) records metrics on the users in the system.

Metrics include the following:

Metric	Description
Total Users	Number of users in the system, including deactivated users but not including the Administrator user.
Active Users	Number of active users in the system, not including the Administrator user.
Active System Administrators	Number of active system administrator users in the system, not including the Administrator user.
Active SAML Users	Number of active users that authenticate through SAML.
Active LDAP Users	Number of active users that authenticate through LDAP.

User settings logs

The User settings log (user_settings.csv) records metrics on the user settings applied by users in the system.

Metrics include the following:

Metric	Description
Number of Users with a11y Increase Contrast On	Number of users who have turned on accessibility high contrast mode.
Number of Users with a11y Chart Pattern Fill On	Number of users who have turned on accessibility chart pattern fills mode.

Web API metrics logs

The Web API metrics log (web_apis.csv) records metrics on Web APIs.

Metrics include the following:

Metric	Description
Total Number of Web APIs	Total number of web API objects in the system.
Total Number of Web API Versions	Total number of web API versions in the system.
Maximum Number of Versions for any Web API	The maximum number of versions for a single web API.
Total Number of Web APIs that Upload Documents	The total number of web APIs that are configured to convert a binary request body to an Appian document.

Outdated type references metrics log

The Outdated type references metrics log (types_outdated_refs_summary.csv) records metrics on outdated type references.

Metrics include the following:

Metric	Description
Timestamp	Date and time when the metric is taken.
Data Store Count	The number of Data Stores that reference outdated data types.
Data Type Count	The number of Data Types that reference outdated data types.
Expression Rule Count	The number of Expression Rules that reference outdated data types.
Interface Count	The number of Interfaces that reference outdated data types.
Process Model Count	The number of Process Models that reference outdated data types.
Record Type Count	The number of Record Types that reference outdated data types.
Report Count	The number of Tempo Reports that reference outdated data types.
Web API Count	The number of Web APIs that reference outdated data types.

Troubleshooting

Log files are an important tool for troubleshooting system problems. Because logs are assumed to be only accessible by system administrators, information about problems arising from individual process models is made available through the interface and sent via notifications to the process designer. Information is written to logs about issues that affect the entire system, including those arising from the content of configuration files, availability of connections to other services, ability to interact with file system resources, and unexpected runtime errors.

Design error log

Expression errors in start forms, task forms, Tempo reports, record lists, record views, related actions, and Web APIs are written to a comma separated value (CSV) file (design_errors.csv) in the <APPIAN_HOME>/logs directory. This log has the following columns:

Metric	Description
Timestamp	Date and time when an error occurred.
Username	The username of the user who experienced the error.
Design Object Name	The name of the design object where the error occurred. Process model names are given in the en_US locale if available, otherwise the first is used.
Design Object Type	The type of the design object where the error occurred. Possible values: Start Form, Record Lists, Record View, Related Action, Report, Task Form, Web API.
Application Name	The name of the application containing the design object, or N/A if it is not in an application. If the object is in multiple applications, the names in a semicolon-delimited list.
Error Code	The Appian error code for the error.
Error Message	A message describing the error that occurred.
Evaluation ID	A unique identifier for the expression evaluation the error occurred in. The same ID will be displayed in the error message, so you can use it to find the corresponding log entry.
Object UUID	The UUID of the design object the error occurred in. You can search for objects by UUID in Appian Designer.
Record Instance ID	For errors that occur on record views, the identifier of the record the error occurred in.
Record View URL Stub	For errors that occur on record views, the URL stub of the view the error occurred in.
Environment	The environment where the error occurred. Possible values: "TEMPO", "SITES", and "EMBEDDED".
Site UUID	For Site errors only, the Site UUID where the error occurred. If the error occurred in Tempo or Embedded, this column is null.
Site Name	For Site errors only, the name of the Site where the error occurred. If the error occurred in Tempo or Embedded, this column is null.
Site Page Web Address Identifier	For Site errors only, the web address identifier for the Site where the error occurred. If the error occurred in Tempo or Embedded, this column is null.
Site Application Name	For Site errors only, the name of the application that contains the Site where the error occurred. If the Site exists in multiple applications, the application names are displayed in a semicolon-delimited list. If the Site exists outside of an application, the value "N/A" is logged. If the error occurred in Tempo or Embedded, this column is null.

Portal error logs

These logs capture errors encountered by end users for each published portal in an environment. They are written to a CSV file (portal_errors.csv) located in the APPIAN_HOME/logs/perflogs/portals/ subdirectory.

You can also view these errors in:

• The Troubleshoot tab of a portal object.
• The Portal Monitoring tab of the Monitor view, which allows you to view errors for connected environments.

Metric	Description
Timestamp	Date and time when the metric is taken.
Error Code	The Appian error code for the error.
Portal Name	Name of the portal object.
Portal ID	UUID of the portal object.
Error Message	A message describing the error that occurred.

Health Check log

Logs for Health Check are located in the <APPIAN_HOME>/logs directory. Health Check must be set up and configured on your environment in order for logging to take place.

The health-check.log file records details about Health Check runs and lists errors.

The <APPIAN_HOME>/logs/health-check directory contains files generated by the most recent Health Check run. These files can only be viewed by system administrators.

HTTP request/response logs

The HTTP request/response logs for integrations (integration_req_resp_activity.log) capture the raw HTTP request and response messages for integrations. These logs can be used for troubleshooting. They're located in the APPIAN_HOME/logs/perflogs/http-requests-and-responses/ subdirectory, which can only be accessed by system administrators.

Integration calls are only logged when they have been enabled in both the Admin Console and the individual integration objects. Developers can only turn on logging for integrations that use an HTTP or OpenAPI connected system.

Similarly, the HTTP request/response logs for web APIs (web_api_req_resp_activity.log) capture the raw HTTP request and response messages for web APIs. These logs can be used for troubleshooting. They're located in the APPIAN_HOME/logs/perflogs/http-requests-and-responses/ subdirectory, which can only be accessed by system administrators.

Web API calls are only logged when they have been enabled in both the Admin Console and the individual web API objects.

To view information about log rotation and retention, see Managing Log Files.

Deployment log

Logs for direct deployment are located in the <APPIAN_HOME>/logs directory. The deployment.log file records details about incoming and outgoing deployments from the environment. Deployment between environments in your infrastructure must be set up and enabled in order for logging to take place.

Application server

When the application server encounters an unexpected error, a message describing the error is logged to tomcat-stdOut.log in <APPIAN_HOME>/logs. Issues encountered during startup are written either to a separate file managed by the application server itself or to standard output.

You can refer to these files to acquire a specific error message and use it in a help ticket, News feed post, or documentation search as part of your troubleshooting.

For example, you may see the following error and report it:

The error means an unattended node, possibly one running a Custom Smart Service Plug-In, is taking an abnormally long time to complete.

All requests that are processed by the application server are logged to tomcat-access.log in <APPIAN_HOME>/logs. Tomcat access logs give you information about who has access to your application, what resources were accessed, the IP, queries, date, etc.

Plug-in functions running during high system memory

When the application server enters a state of high memory usage (i.e. memory used is greater than 75%), an entry is logged to plugin_functions_running_during_high_system_memory.csv for each plug-in function running at that time. The goal of this log is to help identify why the application server's memory usage is so high. Plug-in functions are often the culprits of memory spikes, and therefore all of the plug-in functions running while the application server is in a state of high memory usage warrant investigation. Pay special attention to those plug-ins with the longest elapsed time since plug-ins functions with long evaluation times tend to use more memory as well.

Metric	Description
Timestamp	Date and time when the metric is taken.
User UUID	UUID of user who invoked the plug-in function.
Function	Name of the plug-in function.
Evaluation Type	The type of object that contains the plug-in function. Possible values: record list, record view, report, start form, task form, related action (process start), related action (quick task), process node, web API, internal, interface designer.
Object UUID	The UUID of the design object where the plug-in was evaluated. You can search for objects by UUID in Appian Designer.
Record Instance ID	For evaluation types of record view, the record identifier (rv!identifier).
Record View URL Stub	For evaluation types of record view, the record view URL stub.
Process Instance ID	For evaluation types of start form, task form, related action, or process node, the process instance's ID (pp!id).
Task ID	For evaluation types of task form, the task's ID (tp!id).
Elapsed Time (ms)	Total time spent evaluating the plug-in function from its start until the log entry occurred. This is not the plug-in function's entire evaluation time.

Data service

Logs for the data service are located in the <APPIAN_HOME>/logs/data-server/ directory. The watchdog.log file contains information about data service startup and shutdown, configuration values being used by the data service, and entries for general data service operations and errors. The other logs in the directory contain log entries specific to the various subcomponents of the data service.

The logs in the <APPIAN_HOME>/logs/data-server directory do not contain any proprietary or sensitive data. In the event that sensitive data might be required to troubleshoot an issue with the data service, the data-server-client-errors-detail.log file in the <APPIAN_HOME/logs> directory will contain this information.

Search server

By default, logs for the search server are located in the <APPIAN_HOME>/logs/search-server/ directory. This can be controlled by editing <APPIAN_HOME>/search-server/conf/log4j.properties.

Service Manager

Service Manager, the process that coordinates the Appian Engines, records information about engine startup and shutdown, checkpointing, and transaction replication in /logs/service_manager.log.

Engine databases

Database communication events and errors are logged in text files within the <APPIAN_HOME>/logs/ directory.

Each database event and error log filename is constructed in the following syntax:

Examples:

Each database event and error log is written in the following syntax:

Examples:

Message Types include the following:

• te = transaction execution
• tg = table growth

By default, the logging level for all is set to INFO.

For diagnostic reasons, you may want to temporarily increase the amount of information that is logged. You can change this setting by creating a new log_XX_YY.properties file that configures logging for an individual gateway.

The logging property file names that can be used to customize logging for an individual application engine database include the following:

Server ID	Custom Server Logging File
CH Channels	log_db_CH.properties
CS Collaboration Statistics	log_db_CS.properties
CO Collaboration	log_db_CO.properties
NE Notifications Email	log_db_NE.properties
NO Notifications Service	log_db_NO.properties
PE Personalization	log_db_PE.properties
PO Portal	log_db_PO.properties
DF Discussion Forums	log_db_DF.properties
PA Process-Analytics	log_db_PA.properties
PX Process-Execution (All)	log_db_PX.properties
PD Process-Design	log_db_PD.properties

Engine event logs

The Appian engines produce .l files whenever they encounter certain types of unexpected events. These .l files contain diagnostic information about the event as well as the transaction that initiated it. The names of the .l files are all of the form <engine identifier>_<timestamp>_<event type>.l. Use the <APPIAN_HOME>/server/_scripts/diagnostic/convert_l_to_text.sh (.bat) script to convert these logs to text for review.

Name	Description	Recommended Action
incremental_update_error.l	Data could not replicate from a process execution engine to the corresponding process analytics engine, but the system should repair itself automatically	These errors are safe to ignore unless they continue. If the errors continue, contact Appian Support.
long_transaction_warning.l	A transaction took longer than 60 seconds for the engine to process	These errors are safe to ignore unless they continue, but this incident should be reported to Appian Support for diagnosis to help prevent future occurrences.
memory_spike_warning.l	A transaction resulted in the engine allocating more than 512 MB of memory	These errors are safe to ignore unless they continue. If the errors continue, contact Appian Support.
memory_spike_and_long_transaction_warning.l	A transaction resulted in the engine allocating more than 512 MB of memory and took longer than 60 seconds to process	These errors are safe to ignore unless they continue, but this incident should be reported to Appian Support for diagnosis to help prevent future occurrences.
replication_failure.l	A transaction could not replicate from the primary engine to a replica	Checkpoint the engine and restart the replica
rollback.l	The engine encountered an internal error when processing a transaction and had to restart	The automatic restart of the engine should allow the system to recover automatically, but this incident should be reported to Appian Support for diagnosis to help prevent future occurrences.
transaction_replay_error.l	The engine could not replay a transaction from its log when restarting	Contact Appian Support
write_to_disk_failure.l	The engine could not persist a transaction to disk and had to restart	Ensure that the engines have permissions to write to their gateway directory and that there is enough free disk space available.

Data type locks

The log for information regarding locks on data types (data-type-locks.log) is located in <APPIAN_HOME>/logs directory. The log shows all the calls to lock and unlock data types, at the INFO level, when a data type is updated by various mechanisms like application import, XSD import, etc. The log can help resolve issues regarding data types being locked when attempting to update them or their precedents.

MariaDB upgrade check logs

The logs regarding potential compatibility issues for upgrade to MariaDB as the Appian Cloud database are captured in <APPIAN_HOME>/logs. There are three corresponding logs:

1. The Database Incompatibility Check Log (mariadb-incompatibility-report.log) captures compatibility issues within scripts in the Cloud database.
2. Query Database Smart Service Incompatibility Check Log (query_node_mariadb_incompatibility.log) captures compatibility issues in the Query Database Smart Service.
3. MariaDB Column Type Conversion Log (mariadb-column-type-conversions.log) captures the database columns that changed their type after Appian Cloud database is upgraded from MySQL to MariaDB.

For more information regarding these logs and how to use them, see MariaDB Upgrade Guide page.

Auditing

Audit logs provide a record of specific kinds of actions that have previously taken place in the system for later investigative use.

API Keys

The OAuth 2.0 Clients log, located in the <APPIAN_HOME>/logs/audit directory is a CSV file, api_key.csv, that can be used to audit both the management and usage of OAuth 2.0 clients.

Column	Description
Timestamp	Date and time when an action occurred.
Key ID	The unique identifier associated with the API key.
Key Alias	The Description associated with the API key.
Service Account	The username of the Service Account associated with the API key.
Event	The event that took place. Possible values include CREATED, DEACTIVATED, REACTIVATED, RENAMED, DELETED, and USED.
Actor	The user that took the action.
Endpoint	The web API endpoint being accessed.
Client IP Address	The IP address of the client making the request.

Admin Console

Changes to configurations made through the Admin Console are logged in a comma-separated value (CSV) file, admin_console_audit.csv, in the <APPIAN_HOME>/logs/audit directory.

Data captured includes the following:

Column	Description
Timestamp	Date and time when the modification of a configuration value occurred. yyyy-mm-dd hh:mm:ss (Milliseconds are excluded.)
Username	The username of the user that changed the configuration value.
Property	The fully-qualified name of the configuration property that was changed.
Previous Value	The previous value of the configuration property.
New Value	The new value of the configuration property.

Also in the <APPIAN_HOME>/logs/audit directory is another CSV file, admin_console_user_start_pages_audit.csv, that logs a snapshot of the values on the User Start Pages view every time an administrator makes and saves changes.

Data captured includes the following:

Column	Description
Timestamp	Date and time when the corresponding configuration value was saved. yyyy-mm-dd hh:mm:ss (Milliseconds are excluded.)
Username	The username of the user that made and saved changes.
Row Number	The row number in the Start Pages grid on the User Start Pages view. "Default Start Page" if the corresponding configuration value is for the Default Start Page field.
Start Page URL	The configured URL with the base URL and application context truncated.
Groups	The group IDs corresponding to the configured groups. Null for Default Start Page field.

See also: Admin Console

Authorizations

The authorization audit log file (authz-audit.csv) records information about the authorization of already authenticated users within the system.

This covers user access to services, servlet paths, and URIs that are restricted to a particular type of user (i.e. designer users). By default only denials are logged.

Column	Description
Timestamp	Date and time when an action occurred.
Username	The username of the user who attempted the action. If for some reason the username is unknown, this column will be blank.
Action Target	The type of action that was attempted: One of uri, uri-filter, struts, java-service, hybrid-service, k-service- followed by a service name, or dao- followed by a data source JNDI name
Action Name	The specific action that was attempted. For example, a uri or method name.
Decision	The result of the action. One of ALLOWED, DENIED, or ERROR.
Details	Details about the attempted action, usually including the attempting user's roles and the roles required to complete the action

Blocked files

When a file upload is blocked by the virus scanner (Cloud only) or by file extension, information is logged in a comma-separated (CSV) file, blocked_files.csv, in <AE_HOME>/logs/audit/. Data captured include the following:

Column	Description
Timestamp	Date and time when the request was made in yyyy-mm-dd hh:mm:ss format.
User	The username of the user who uploaded the file.
Document Name	The name of the uploaded file, including the extension.
Reason	The reason why the file was blocked. Options: "Virus Detected", "File Extension", "File Type"
Details	The details depend on the reason the file was blocked: If the reason is "Virus Detected", the name of the virus signature that blocked the file from being uploaded. If the reason is "File Extension", the extension of the file. If the reason is "File Type", additional details on the underlying type and expected extension versus the found extension
Hash	The hash of the file that was blocked. This column provides insight into whether a single file or multiple file are being blocked. The "Document Name" column is not sufficient in identifying whether a file is being blocked multiple times since file names can be changed easily.

Cloud database requests

Requests sent to the business data source in the Appian Cloud relational database are captured in the rdbms-audit.log.yyyy-MM-dd file, located in the <APPIAN_HOME>/logs/audit/rdbms directory. The log only contains requests that were sent from Appian, the Cloud Database administrative interface (phpMyAdmin), or the Enhanced Data Pipeline. For data security compliance reasons, this log is only accessible to members of the Database Administrators group.

The following data is captured in this log:

Column	Description
timestamp	Time at which the event occurred.
serverhost	The RDBMS server host name.
username	RDBMS user under which the statement was executed.
host	Host from which the user connected.
connectionid	Connection ID number for the related operation.
queryid	Query ID number.
operation	Recorded action type.
database	Active database (as set by USE).
object	The query that was executed.
retcode	Return code of the logged operation.

Cloud database management

Changes to the cloud database made through the Update Enhanced Data Pipeline user credential endpoint are recorded in a comma-separated value (CSV) file, cloud_database_mgmt.csv in the <APPIAN_HOME>/logs/audit directory. You can use this file to see who made a change, where the request originated, and when the change occurred.

The following data is captured in this log:

Column	Description
Timestamp	Time at which the event occurred.
Event	The type of change requested.
Actor	The username of the user account that requested the change.
Actor UUID	The UUID of the user account that requested the change.
IP Address	The IP address of the user account that requested the change.
Database User	The username of the database user whose property was changed.
HTTP Response Code	The HTTP response code of the API request call.
APNX Error Code	The Appian error code of the API request call.

Connected system management

Changes to connected system properties made through the Update Connected System endpoint are recorded in a comma-separated value (CSV) file, connected-system-mgmt.csv in the <APPIAN_HOME>/logs/audit directory. You can use this file to see who made a change, where the request originated, and when the change occurred.

The following data is captured in this log:

Column	Description
Timestamp	Time at which the event occurred.
CS UUID	The identifier of the affected connected system object.
CS Name	The name of the affected connected system object.
Actor	The username of the user account that requested the change.
Actor UUID	The UUID of the user account that requested the change.
Event	The type of change requested.
Actor IP Address	The IP address of the user account that requested the change.
Event Status	A indication of whether the requested change was made.

Data governance security

Changes to the Data Stewards assigned to record type on the Data Governance page are logged in a comma-separated value (CSV) file, data_governance_security.csv, in the <APPIAN_HOME>/logs/audit directory.

Data captured includes the following:

Column	Description
Timestamp	Date and time when the change occurred formatted as yyyy-mm-dd hh:mm:ss.
Username	The username of the user that modified the record type permissions in the Data Governance page.
Name	The name of the record type where data stewards were assigned or removed.
UUID	The UUID of the record type that was modified.
Previous Rolemap	A text representation of the data stewards previously assigned to the record type on the Data Governance page.
New Rolemap	A text representation of the new value of the data stewards assigned to the record type on the Data Governance page.

Deletions

Object and plug-in deletions are recorded in a comma-separated value (CSV) file, deletion.log, in the <APPIAN_HOME>/logs directory. If an object or plug-in is deleted and you need to know when it was deleted and which user did it, you can refer to this log file.

The following object deletions are recorded:

• Connected System
• Constant
• Data Store
• Data Type
• Document
• Document Folder
• Expression Rule
• Feed
• Group
• Group Type
• Integration
• Interface
• Portal
• Process Model
• Process Model Folder
• Record Type
• Rule Folder
• Site
• Tempo Feed Entry
• Tempo Report
• Web API

Object version deletions are also recorded for objects that support versioning.

Note that for document files, only deletions (which are not reversible) are logged. Deactivations (which are reversible) are not logged because the files still exist in the system even though they do not appear in the interface.

You can also view object deletions in the design objects log.

Example Document Deletion

Example Document Version Deletion

Example Tempo Feed Entry Deletion

Design objects

Changes to design objects are recorded in a comma-separated value (CSV) file, design_objects.csv, in the <APPIAN_HOME>/logs/audit directory. You can refer to this log file to learn when an object was created, updated, or deleted, and which user took the action.

Column	Description
Timestamp	Date and time when an object change occurs. yyyy-mm-dd hh:mm:ss (Milliseconds are excluded.)
User UUID	The UUID of the user who took the action.
Username	The username of the user who took the action.
Object UUID	The object upon which the action is taken.
Object Type	The type of the object upon which the action is taken. (Valid values: English Appian Designer object type names).
Action	The action taken on the object.

Devops Infrastructure

The DevOps Infrastructure audit logs are split across three log files:

• DevOps Infrastructure Requests
• DevOps Infrastructure Management
• DevOps Infrastructure Handler

DevOps Infrastructure requests

The DevOps Infrastructure Request log, located in the <APPIAN_HOME>/logs/audit directory is a CSV file, devops_infrastructure_request.csv, that can be used to audit the request and approval process for adding environments to your infrastructure. This includes the request initiation, withdrawal, approval, denial, and timeout.

Column	Description
Timestamp	Date and time when an action occurred.
Status	The status of this request.
ID	A unique identifier for the request.
Name	The name of the remote environment.
URL	The URL of the remote environment.
Request Type	The action that triggered this log entry.
Initiated Date	The date of the initial request to add an environment.
Initiator Name	The display name of the system administrator that made the initial request.
Initiator Username	The username of the system administrator that made the initial request.
Initiator IP	The IP address of the system administrator that made the initial request.
Approver Name	The display name of the system administrator who approves or denies the initial request.
Approver Username	The username of the system administrator who approves or denies the initial request.
Approver IP	The IP address of the system administrator who approves or denies the initial request.
Decision Date	The date of the decision.
Expiration Date	The datetime at which the request is set to expire.

DevOps Infrastructure management

The DevOps Infrastructure management log, located in the <APPIAN_HOME>/logs/audit directory is a CSV file, devops_infrastructure.csv, that can be used to audit the management of environments in your infrastructure. This includes the addition of an environment to your infrastructure, the enabling and disabling of communication with an environment in your infrastructure, and the removal of an environment from your infrastructure.

Column	Description
Timestamp	Date and time when an action occurred.
Event	The action that triggered this log entry.
Name	The name of the environment in your infrastructure.
URL	The URL of the environment in your infrastructure.
Enabled	Indicates whether communication is enabled in your environment.
Remote Enabled	Indicates whether communication is enabled in the remote environment.
Created Date	The date that this environment was initially added to your infrastructure.
Last Action Type	The last action that took place with this environment.
Last Action Actor Name	The display name of the system administrator that took the last action.
Last Action Actor Username	The username of the system administrator that took the last action.
Last Action Date	The date of the last action.
Last Action IP	The IP address from which the system administrator took the last action.

DevOps Infrastructure handler

The DevOps Infrastructure handler log, located in the <APPIAN_HOME>/logs/audit directory is a CSV file, devops_infrastructure_handler.csv, that can be used to audit all communication between environments in your infrastructure.

Column	Description
Timestamp	Date and time when an action occurred.
Direction	Incoming or Outgoing. Incoming indicates that a capability was initiated from the remote environment and must be handled. Outgoing indicates that the capability was initiated from your environment.
Before or After Request Processed	Indicates the step in the request handling process. In the initiating environment, Before means you're sending a capability request and After indicates that the remove environment responded. In the environment handling the request, Before means you're receiving a request to handle and After indicates that you're responding with how the request was handled.
ID	A unique identifier in your infrastructure for the environment in your infrastructure.
Name	The name of the environment in your infrastructure.
URL	The URL of the environment in your infrastructure.
IP Address	The IP address of the request or response from the environment in your infrastructure.
Feature	Indicates which capability this exchange is associated with.
Sub Path	Indicates the specific action being leveraged for that capability.
Status Code	The HTTP status code.
Error Occurred	Indicates whether an error occurred.
Error Message	Error details.

File attachment downloads

Each attempted download of a file attached to a news entry is recorded in the log file <APPIAN_HOME>/logs/audit/file_attachment_downloads.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time when a user attempted to download a file.
User	The UUID of the user who attempted to download a file.
File ID	Identifier of the file.
File Opaque ID	Opaque identifier of the file.
File Name	Name of the file.
Download Successful	Indicates whether the download was successful. The download can fail if the file attachment or news entry to which it was attached is deleted or if the user loses privileges to the file or news entry.

Forgot password requests

User requests to reset a forgotten password are logged in a comma-separated (CSV) file, forgot_password_requests.csv, in <AE_HOME>/logs/audit/. Data captured includes the following:

Column	Description
Timestamp	Date and time when the request was made in yyyy-mm-dd hh:mm:ss format.
Username	The username entered in the reset request.
Email Address	The email address to which the email was sent. If no email was sent, this field will be blank.
Email Type	The type of email sent. Valid values are: "Password Reset," "Deactivated User," "Password Not Old Enough," and "Not Authenticated Through Appian." The value may also be blank if an email was not sent. In such a case, "Reason Email Was Not Sent" will have a value explaining why an email was not sent.
Requestor IP Address	The IP address that the application server associated with this request.
Reason Email Was Not Sent	The value will be empty if email was sent. Otherwise, value will be one of the following: User does not exist. User does not have an email address User email address is invalid Invalid "from address" in custom.properties

Group management

Any time a user makes a direct membership change to a group, this change is recorded in the group_management.csv file. This file is located in the <APPIAN_HOME>/logs/audit directory.

The following events are recorded:

• A user, group, or child group is added to a group.
• A user, group, or child group is removed from a group.

Data captured includes the following:

Column	Description
Timestamp	Date and time when an action occurred.
Action	The action performed by the user or system. Possible actions: Users Added Users Removed Groups Added Groups Removed Child Group Added Child Group Removed
Actor UUID	The UUID of the user who performed the action.
Actor Username	The UUID of the user who performed the action.
Acting On Behalf Of UUID	The UUID of the user who initiated the action.
Acting On Behalf Of Username	The username of the user who initiated the action.
Group UUID	The UUID of the group which had members added to it or removed from it.
Group Name	The name of the group which had members added to it or removed from it.
Member UUIDs	A semicolon-delimited list of UUIDs of the users and groups that were added or removed as members.
Member Names	A semicolon-delimited list of usernames or group names of the users and groups that were added or removed as members.

Logins

Each log in attempt is recorded in the login-audit.csv file. This file is located in the <APPIAN_HOME>/logs directory.

The following login events are recorded:

• Internal authentication through the login page.
• Single Sign On and/or an external directory service.
• Successfully authenticated web API call.

Data captured includes the following:

Column	Description
Login Timestamp	Date and time when a login or access attempt occurs. yyyy-mm-dd hh:mm:ss (Milliseconds are excluded.)
User	The username submitted by the login attempt.
Status	The login attempt status is recorded as Succeeded, Failed, or Transient (Appian Mobile Application logins only) .
IP	The IP address that the application server associated with this request.
Source	One of the following authentication sources is listed: Portal (includes LDAP and SAML authentication) Email JMS Message SharePoint Web Service Web API (if HTTP basic authentication logging is enabled)
User Agent	The self-reported client information (such as browser version) for web browsers. Mobile clients list the following details. Agent name, such as AppianiOS or AppianBB Appian Mobile application version number Device name, such as iPad, iPhone, or 9780Device Device OS version, such as 4.2.1 (iOS) or 6.0.0.359 (BB OS) Internal build number
Transaction ID	A unique identifier (UUID) for each login attempt. Can be utilized to group Appian Mobile application logins, for which both a "Transient" and "Succeeded" entry can be recorded.
Session UUID	The Appian user's unique identifier (UUID) for the session that was logged in. Also found in `logout-audit.csv`

A login is determined to have Succeeded when the following valid credentials are passed:

1. The username and password combination is correct.
2. The user is not deactivated.
3. The user is not locked.
4. The user has not reached the maximum allowed number of concurrent sessions.
5. (Appian Cloud only) If the Trusted IP Address feature is enabled, the login must also meet the established IP address or origination domain criteria.
6. The user's password is expired, but the user is prompted to change their password before proceeding.
   • It is possible for a user to repeatedly attempt to login and cancel the password change.
   • Each such attempt is logged as a success.
7. When Single Sign On is enabled, a successful login occurs when the user accesses Appian (according to each window opened during the session).
   • For example, should the user close the browser, then reopen it a few minutes later before the Appian session expired, another success is recorded.

Logins via the Appian Mobile application are handled via an in-app browser. For these logins, a Transient entry is recorded when the user identity has been validated in the in-app browser, but a session has not yet been created. When a valid session is established, a Succeeded entry is added. All successful mobile logins will be preceded by a Transient entry. If you are looking to count successful logins, ignore Transient entries and only count Succeeded entries.

The user agent information reported by the web browser often includes industry acronyms and jargon with unclear meaning.

For example:

• Mozilla/4.0 may be reported by any browser that is compatible with Firefox.
• Windows NT 6.1 is reported by browsers that are using Windows 7.

Special Consideration for Cloud

To view the login-audit file, access the navigation menu in Appian and select System Logs.

Logouts

User session logouts are recorded in the logout-audit.csv file. This file is located in the <APPIAN_HOME>/logs directory.

The following logout events are recorded:

• A user session has expired.
• A user manually logs themselves out.
• A user is renamed, logging out all active sessions.
• A user is deactivated, logging out all active sessions.
• A maintenance window is triggered, logging out relevant user sessions.

Data captured includes the following:

Column	Description
Login Timestamp	Date and time when the login occurred and session was created. yyyy-mm-dd hh:mm:ss
Last Activity Time	Date and time for the last session activity. yyyy-mm-dd hh:mm:ss
Session Deletion Time	Date and time when the user was logged out and the session deleted. yyyy-mm-dd hh:mm:ss
User Active Duration (HH:mm:ss)	Amount of time from login to "Last Activity Time".
Session Duration (HH:mm:ss)	Amount of time from login to logout.
User	The username for the user session.
Logout Reason	One of the following values: SESSION_EXPIRATION LOGOUT USER_RENAME USER_DEACTIVATION MAINTENANCE_WINDOWS
User UUID	The Appian user's unique identifier (UUID).
Session UUID	The Appian user's unique identifier (UUID) for the session that was logged out. Also found in `login-audit.csv`.

If the node hosting the web application server or the web application server itself is shutdown unexpectedly, any active user sessions will not be recorded in the logout audit at this time.

Session audits can easily be accomplished by joining login-audit and logout-audit data with Session UUID.

For example, below are three successfully created user sessions taken from a login-audit.

login-audit sample data

Login Timestamp	User	Status	IP	Source	Transaction ID	Session UUID
2022-06-21 15:27:19	joshua.ledge	Succeeded	12.3...	Portal	7eec7b33...	721491af...
2022-06-21 19:31:49	joel.redd	Succeeded	98.7...	Portal	d9df2346...	fc9986cd...
2022-06-21 21:31:49	talhah.hamm	Succeeded	90.8...	Portal	ebccd463...	977e83a8...

By identifying the matching rows using Session UUID in the logout-audit, a full session analysis can be done. Not all properties from both audit files are shown.

login + logout audit sample data

User	IP	Login Timestamp	Session Deletion Time	Session Duration (HH:mm:ss)	Logout Reason	Session UUID
joshua.ledge	12.3...	2022-06-21 15:27:34	2022-06-22 00:21:51	08:54:16	SESSION_EXPIRATION	721491af...
joel.redd	98.7...	2022-06-21 19:31:49	2022-06-22 00:32:51	05:01:02	SESSION_EXPIRATION	fc9986cd...
talhah.hamm	90.8...	2022-06-21 21:31:56	2022-06-22 04:09:55	06:37:59	LOGOUT	977e83a8...

Multi-factor authentication

When a user is configured to use multi-factor authentication (MFA) with Appian authentication, all verification code activity is recorded in the multi_factor_authentication.csv file. This file is located in the <APPIAN_HOME>/logs/audit directory.

The following events are recorded:

• A verification code is sent to a user.
• A valid verification code is entered successfuly.
• An invalid verification code is entered.

Data captured includes the following:

Column	Description
Timestamp	Date and time when the login occurred and session was created. Formatted as yyyy-mm-dd hh:mm:ss
Username	The user who either had a verification code sent to their email or attempted to enter a verification code.
Sent To Location	The email address that the verification code was sent to.
IP Address	The IP address of the user associated with this request.
Method	The MFA method used. For now, the only valid value for this column is "Email".
Event	One of the following values: Code Sent Code Verification Failed Code Verification Successful
Code ID	The ID associated with the verification code. This will be null when an invalid verification code is entered.

Mutual TLS (mTLS) certificate authentication

When an environment is configured to use mTLS and a web API request fails because the certificate fails authentication, the failure is logged in the mtls_for_web_api_certificate_authentication_failures.csv file. This file is located in the <APPIAN_HOME>/logs/audit directory.

Data captured includes the following:

Column	Description
Timestamp	Date and time when the request occurred and authentication was attempted. Formatted as yyyy-mm-dd hh:mm:ss.
Certificate Thumbprint	The certificate's identifying hash.
Request Path	The endpoint the request was sent to.

News usage

User activity related to the Tempo news feed is recorded in the log file <APPIAN_HOME>/logs/audit/news_usage.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time when an action occurred.
User	The UUID of the user who performed the action.
Action	The action performed by the user. Possible actions: Post From User, Message From User, Locked Message From User, Comment From User, Added Participants, Social Task From User, Kudos From User, Star a News Event, Un-star a News Event, Event From Process, Comment From Process, View Site Interface

OAuth 2.0: Authorization Code Grant for connected systems

Every time a user hits the OAuth callback for the Authorization Code grant, Appian will log a line to the log file, oauth_callback.csv, in the <APPIAN_HOME>/logs/audit directory with the following columns:

Column	Description
Timestamp	Date and time when the callback was hit. yyyy-MM-dd HH:mm:ss
User	The user hitting the callback endpoint
Connected System UUID	The UUID of the connected system that the user is authorizing. This value will be blank if a user reaches the callback endpoint without having followed an Authorization Link
Connected System Name	The name of the connected system that the user is authorizing. This value will be blank if a user reaches the callback endpoint without having followed an Authorization Link
Success	True if the authorization succeeded and an access token was stored, otherwise false
Scope	The requested scope for the access token
Token Expiration	If a token was retrieved, when it is set to expire if such data was provided by the resource
Is Test	True if the callback was for an authorization test, otherwise false

OAuth 2.0 Clients Credentials Grant for Web APIs

The OAuth 2.0 Clients log, located in the <APPIAN_HOME>/logs/audit directory is a CSV file, oauth_client_credentials_grant_for_web_apis.csv, that can be used to audit both the management and usage of OAuth 2.0 clients.

Column	Description
Timestamp	Date and time when an action occurred.
Client ID	The Client ID associated with the OAuth 2.0 client.
Client Description	The Description associated with the OAuth 2.0 client.
Service Account	The username of the Service Account associated with the OAuth 2.0 client.
Event	The event that took place. Possible values include CREATED, DEACTIVATED, REACTIVATED, RENAMED, DELETED, ACCESS_TOKEN_RETURNED, and ACCESS_TOKEN_USED.
Actor	The user that took the action.
Endpoint	The web API endpoint being accessed.
Client IP Address	The IP address of the client making the request.

Object rolemaps

Changes to the rolemaps of existing design objects are logged in a comma-separated value (CSV) file, object_rolemap_audit.csv, in the <APPIAN_HOME>/logs/audit directory. The rolemaps of the following objects are not logged:

• Discussion Thread
• Forum
• Process Instance
• User

Only rolemap changes to existing objects are logged; changes to other security properties (including changes due to inheritance) are not logged. Rolemaps are not logged on object creation.

Data captured includes the following:

Column	Description
Timestamp	Date and time when the rolemap change occurred. yyyy-mm-dd hh:mm:ss (Milliseconds are excluded.)
Username	The username of the user that changed the rolemap.
Name	The name of the object whose rolemap was changed.
Type	The type of the object whose rolemap was changed.
UUID	The UUID of the object whose rolemap was changed.
Previous Rolemap	A text representation of the object's rolemap prior to the change. The rolemap varies based on object type.
New Rolemap	A text representation of the new value of the object's rolemap.
Location	The location of where the rolemap change occurred. This column indicates when the rolemap change occurred during Import and is blank otherwise.

Outdated Type References

Every reference to an outdated type is recorded on start-up and every 12 hours following in a comma separated value (CSV) file (types_outdated_refs.csv) in the <APPIAN_HOME>/logs/audit directory.

Data captured includes the following:

Column	Description
Timestamp	Date and time of reporting.
Data Type	The name and namespace of the datatype, including version number.
Data Type Fields	A semi-colon separated list of the fields of this outdated version of the data type (e.g., fieldName1; fieldName2; …).
Design Object Type	The type of design object that is referencing the outdated data type version.
Name	The name of the design object referencing the outdated type.
UUID	The UUID of the design object referencing the outdated type.
URL	The URL to access the definition of the design object.
Location	The breadcrumbs location of where the object references the data type. If there are multiple, each instance will be its own row.

Password resets

When a user resets their password by following an email generated by the Forgot Password page, Appian logs information in a comma-separated (CSV) file, password_resets.csv, in <AE_HOME>/logs/audit/. Data captured includes the following:

Column	Description
Timestamp	Date and time when the request was made in yyyy-mm-dd hh:mm:ss format.
Username	The user whose password was reset.
User IP Address	The IP address that the application server associated with this request.
Source	The initiator of the password reset process. Valid values: "Forgot Password." More values may be added to this list in the future.

Received emails

Each email received is recorded in the log file mail-listener.log in the <APPIAN_HOME>/logs directory.

This log consists of the information such as the time-stamp, subject line of every email received and the status of the email handling service.

To learn more about setting up the mail server to receive emails, see the documentation for receiving emails.

Records usage

User activity related to records is recorded in the log file <APPIAN_HOME>/logs/audit/records_usage.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time when an action occurred.
User	The UUID of the user who performed the action.
Action	The action performed by the user. Possible actions: View Record Type List, View Record List, View Record Dashboard, View Related Action List, View Related News, Record List Search
Record Type Name	The name of the record type involved in the action, if applicable.
Record Type URL Stub	The URL stub of the record type involved in the action, if applicable.
Record Identifier	The identifier of the record involved in the action, if applicable.
View	The URL stub of the URL stub of the record view involved in the action, if applicable.
Filters	Facet filters and/or searches that were selected at the time of the action, if applicable. Searches are shown in the form "search=[search term]". When facets are selected, the underlying filter is shown. Multiple filters are shown combined with "AND".
Environment	Environment where the record type was used. Possible values are Tempo and Sites
Site URL Stub	The URL stub of the site where the record type was used, if applicable.

Removed processes

When processes are deleted or archived, these events are recorded in a comma-separated (CSV) log file in the <APPIAN_HOME>/logs/audit/ directory. Each log file is named according to the convention removed_processes_db_PX<ENGINE_NUMBER>_<TIMESTAMP>.csv. Only the primary engines will write to this log.

Example log file name:

Data captured in the log include the following:

Column	Description
Timestamp	Date and time when the action occurred in yyyy-mm-dd hh:mm:ss format
Transaction ID	The transaction ID of the action
Action	The type of action that occurred. Valid values are delete or archive
Username	The username of the user who attempted the action. If the deletion or archival is performed automatically by the system, the value will be Administrator.
User UUID	The UUID of the user who attempted the action. If the Username is Administrator, the UUID will be blank.
Process ID	The ID of the process
Process Name	The name of the process
Process Model Handle (Local)	The local, internal identifier for the process model on the execution engine, which may be useful for debugging purposes
Process Model ID (Design)	The ID of the process model
Process Model Name	The name of the process model

Secure Credentials Store

Access to credentials stored in the Secure Credentials Store are logged in a comma-separated value (CSV) file, secure_credentials_store.csv, in the <APPIAN_HOME>/logs/audit directory. All reads and modifications of third-party credentials are recorded in this file. No encrypted values are ever logged here.

Data captured includes the following:

Column	Description
Timestamp	Date and time when an access or modification of values occurs. yyyy-mm-dd hh:mm:ss (Milliseconds are excluded.)
Username	The username of the user accessing the secure credentials store values.
Action	Create Read Update Delete
Scope	System-Wide - the system-wide credentials for the external system were accessed Per-User - the user's personal credentials for the external system were accessed
External System Key	The key of the external system for which the credentials were accessed. ALL if all external systems are accessed in a bulk call, or ALL for username when accessing credentials for all external systems for a given user.
Attribute	The key of the specific attribute whose value was accessed. ALL if all attributes for an external system are accessed in a bulk call, or ALL for username when accessing all attributes for a given user.
Plug-in	If the secure credentials store is accessed from a plug-in, the key of the plug-in. Otherwise, N/A.

See also: Secure Credentials Store

Sites usage

User activity related to sites is recorded in the log file <APPIAN_HOME>/logs/audit/sites_usage.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time when an action occurred.
User	The UUID of the user who performed the action.
Action	The action performed by the user. Possible actions: View Site Task Report, View Process Task Form, Submit Process Task Form, View Site Action Start Form, Submit Site Action Start Form, View Site Record List, View Site Report,View Site Record View,View Site Related Actions List, Site Record List Search
Site	The URL stub of the site involved in the action.
Page	The URL stub of the page involved in the action.
Page Group	The URL stub of the page group involved in the action.

Portals usage

Visitor activity related to sites is recorded in the log file APPIAN_HOME/logs/perflogs/portals/portal_usage.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time of the interaction.
Session ID	A unique identifier for the session, which includes all interactions a visitor makes without closing or refreshing the portal.
Visitor ID	A unique identifier for the visitor.
Portal	The name of the portal that the visitor accessed.
Page	The name of the portal page that the visitor accessed.
Device Type	The type of device that the visitor used to access the portal.
Device Width	The page width used when loading the portal.

Task errors

Errors that occur when users access invalid tasks are recorded in the log file <APPIAN_HOME>/logs/audit/task_errors.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time when the error occurred in yyyy-mm-dd hh:mm:ss format.
User	The UUID of the user who performed the action.
Details	A brief description of the error. Possible errors: Task does not exist Task is canceled or completed User does not have permission to view this task User accessed a task using an integer in the URL. (Note: if this message is logged, the task ID is also returned in the error message.)

User deactivations

User accounts that are deactivated due to inactivity are listed at the INFO level in db_PE_yyyy-mm-dd_hhmm.log in the <APPIAN_HOME>/logs/ directory.

The following message appears in the logs before a comma-separated list of usernames.

These user accounts were deactivated automatically due to inactivity: [<usernames>]

User management

Activity related to user management is recorded in the log file <APPIAN_HOME>/logs/audit/user_management.csv. This is a comma-separated value (CSV) file with the following columns:

Column	Description
Timestamp	Date and time when an action occurred.
Action	The action taken on the user account. Possible actions: Create, Change Username, Change User Type, Change User Status, Change Lock Status, Change Password, Change Email
User UUID	The UUID of the user the action was taken on.
Username	The username of the user the action was taken on.
Original Value	The original value, before the action took place. Does not apply for Create and Change Password actions.
New Value	The new value, after the action took place. Does not apply for Create and Change Password actions.
Modified By UUID	The UUID of the user who performed the action.
Modified By Username	The username of the user who performed the action.

The first line of the log prints out the log initialization timestamp. The following actions have specific behavior:

• Change User Status - This action distinguishes between when a user is deactivated manually (in the Users view or via smart service) and when a user is deactivated due to inactivity. The logged values are Inactive (manual) and Inactive (idle user).
• Change Lock Status - This action is logged when an account is locked because of too many failed login attempts and when it is manually unlocked by a system administrator. The action does not log when an account is automatically unlocked based on the lock expiring.
• Change Password - This action is logged when the user changes their own password, someone clicks the Forgot Password link, or an administrator resets a password. See the forgot password requests log and password resets log for more details on those specific types of password changes.

Unscanned files

When the scan of an uploaded file is skipped by the virus scanner (Cloud only), information is logged in a comma-separated (CSV) file, unscanned_files.csv, in <AE_HOME>/logs/audit/. Data captured include the following:

Column	Description
Timestamp	Date and time when the file was uploaded in yyyy-mm-dd hh:mm:ss format.
User	The user who uploaded the file.
Document ID	The content ID of the uploaded file.
Reason	The reason that the file went unscanned. Possible values: "File too large", "Timeout", "Scanner unreachable", and "Other."

Feedback