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

max.carp 6 months ago in reply to shubhamg7824

Are none of the logs working or is the problem only with login-audit.csv? And was this working for you prior to upgrading to 24.1?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
shubhamg7824 6 months ago in reply to shubhamg7824

Hi Appian AppMarket Can you please help on this query?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
shubhamg7824 6 months ago in reply to max.carp

Hi max.carp I tried that as well , but Still no rows are getting returned .

thanks
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
max.carp 6 months ago in reply to shubhamg7824

To include paging info as above, you should use the function readcsvlogpaging(), as in:

readcsvlogpaging(
csvPath: "login-audit.csv",
startIndex :1,
batchSize:20
)
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
shubhamg7824 7 months ago

Hi Team ,

I am some issue, I am trying the below expression but only getting the header values.

readcsvlog(
csvPath: "login-audit.csv",
startIndex :1,
batchSize:20
)

Currenlty we are working on Appian version 24.1

thanks
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
shubhamg7824 7 months ago in reply to bihitakd0002

hi bihitakd0002 Jason Ruvinsky Gregor Gisler-Merz

I am also facing the similar issue , I am trying the below expression but only getting the header values.

readcsvlog(
csvPath: "login-audit.csv",
startIndex :1,
batchSize:20
)

Did you guys got any solution ? Currenlty we are working on Appian version 24.1.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Rayudu Addagarla 9 months ago

Is the plugin compatible with 23.4 to read audit log ?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Jason Ruvinsky 10 months ago in reply to bihitakd0002

We are having the same issue as well, and it turns out it's due to the new column. When the log file rolled over, it pulled from the new one fine, but we can't retrieve data from older files. We are relying on this plugin to build auditing reports, so missing data is a big issue for us!
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
lorenzot0001 11 months ago in reply to chandimas0001

Hi chandimas0001 , ti seems to be working for us. We tried to retrieve design_errors.csv and we was able to do it. We used the following.

readcsvlogpagingwithheaders(
"serverName/design_errors.csv",
1,
100,
{},
"",
"",
"",
"Timestamp",
adddays(now(), -3),
now()
)

You will need to substitute serverName with your server name. In this way you will retrieve only the logs from serverName server, to retrieve the log for the others you need to substitute this with the other servers name, e.g. serverName-2 and serverName-3.

Just check what the rule getlogpath() responds. In our HA environment it responds "LOG_DIR : /usr/local/appian/ae/shared-logs".
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
chandimas0001 over 1 year ago

Hi All

the plugin is failing to read logs for HA environments as the log path is different. for example the path for the login-audit.csv is at /usr/local/appian/ae/shared-logs/login-audit.csv oppose to /usr/local/appian/ae/logs/login-audit.csv.

any way we can use the plugin or any alternate way to read the logs?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel