Log Reader

Overview

Plug-in Notes:

  • Allows only System Administrators or members of the Designers group to access log data.  
  • Does not load files outside the logs directory or files that do not end in .log.* or .csv.*.
  • On multi-application-server environments, logs will only be shown from a single application server.
  • Custom headers can be specified as an optional parameter. This is meant to be used for .csv files that don't contain a header.

Key Features & Functionality

The Appian Log Reader Plug-in contains functionality to:

  • Read files in the Appian /log folder (.csv or .log) and return them as structured data
  • Aggregate data from a .csv file
  • Serve as the source for a service-backed record for viewing logs
  • The Log Reader application provided with the download demonstrates a service-backed record for viewing logs, as well as reports on specific log files. Administrators can view reports on system health over time, including design best practices, system load, and database performance. The application also contains a process that checks details from system.csv and alerts administrators if memory or CPU utilization exceeds a threshold.
  • Tail a log file with tailcsv and taillog. Note that tail is an expensive operation which is optimized for reading the last few lines of a large log file. It's not advisable to tail the entire log file from the end to the beginning. However, tail will perform much better than the other log functions when reading the last few lines from a very large log file. Use the batch size and timestamp filters to limit the number of lines read by the tailcsv and taillog functions.
  • Takes a line of text in CSV format and returns a text array
Anonymous
Parents
  • Hi, I want to filter rows from login-audit.csv based on the usernames I have. Any idea about that.

  • Hi, we are using this approach for getting data from specifically the login-audit.csv:

    We are using the Appian Usage Insights Plugin:  Appian Usage Insights
    Advantage is that for High Available environments it collects all audited logins (from all application server nodes) not only the one from the node you are running this on, which is one of the disadvantages mentioned to this plug-in, in the notes:

    • On multi-application-server environments, logs will only be shown from a single application server.

    Disadvantage is that it only captures the successful logins and not any other data than username and login timestamp. So if you need failed attemps and/or source-ip or other data in this csv, this plug-in cannot be used.

    For using the usage insights plugin you do not have to install the entire License Applications mentioned on the app market page, only the plug-in itself in the admin console is enough. 

    We use the results from this Usage Insights plug-in in a daily process to get all logins of the previous day (you will specify a specific audit-startdate and enddate for the timeframe required, which has a limit of max 30 days old). In a process model, which gets the csv as document output from this plug-in's smart-service, we then use Import csv to database plug-in smart service (part of excel tools plug-in: Excel Tools) to load this data in the database and perform logic on that dataset like filtering and use it in interfaces for user insights.

    Maybe this is a workable solution for you as well?



Comment
  • Hi, we are using this approach for getting data from specifically the login-audit.csv:

    We are using the Appian Usage Insights Plugin:  Appian Usage Insights
    Advantage is that for High Available environments it collects all audited logins (from all application server nodes) not only the one from the node you are running this on, which is one of the disadvantages mentioned to this plug-in, in the notes:

    • On multi-application-server environments, logs will only be shown from a single application server.

    Disadvantage is that it only captures the successful logins and not any other data than username and login timestamp. So if you need failed attemps and/or source-ip or other data in this csv, this plug-in cannot be used.

    For using the usage insights plugin you do not have to install the entire License Applications mentioned on the app market page, only the plug-in itself in the admin console is enough. 

    We use the results from this Usage Insights plug-in in a daily process to get all logins of the previous day (you will specify a specific audit-startdate and enddate for the timeframe required, which has a limit of max 30 days old). In a process model, which gets the csv as document output from this plug-in's smart-service, we then use Import csv to database plug-in smart service (part of excel tools plug-in: Excel Tools) to load this data in the database and perform logic on that dataset like filtering and use it in interfaces for user insights.

    Maybe this is a workable solution for you as well?



Children
No Data