Skip to main content
Known Participant
Jun 14, 2024 2:09 PM UTC
Solved

Log Reader Plug-in - login-audit.csv

Hi!

I'm trying to use the "Log Reader" pluging to read the login-audit.csv logs through expression rules, but it doesnt work.
According to the comments on the pluging it seems that this is a common failure, so does anybody knows how to make it work or any other way to store this information on the Appian Database?

yogip3177Answer
Brainy
Jun 14, 2024 2:47 PM UTC

readcsvlog() function is working for me. See sample code and screenshot for reference.

a!localVariables(
  local!logFile: readcsvlog(csvPath: "login-audit.csv"),
  local!logFile
)

7 replies

davidj137213
Brainy
Jun 14, 2024 2:23 PM UTC

Are you working in HA? if it's your case, I think that you have to append the node name to logs path

yogip3177Answer
Brainy
Jun 14, 2024 2:47 PM UTC

readcsvlog() function is working for me. See sample code and screenshot for reference.

a!localVariables(
  local!logFile: readcsvlog(csvPath: "login-audit.csv"),
  local!logFile
)

Known Participant
Jun 17, 2024 4:11 PM UTC

Hi! That's what I did but now I realize that it failed because I've been trying to read logs older than a month and in those cases the file extension changes from .csv to csv.gz  Do you know if there's a way to read those folders, which contains the csv that I need to read? ? 

Brainy
Jun 18, 2024 5:41 AM UTC
Appian Gzip files after a month or so i.e. files are not zip until a month. You can change this period using the log4j configuration. There should be some configuration change in your case since yesterday's files are getting zipped. Check the log4j configuration and increase the rolling period if possible.
karumurua531442
Participating Frequently
Jun 14, 2024 3:58 PM UTC

hi [mention:d9737c9b566a47159485a573139116ad:e9ed411860ed4f2ba0265705b8793d05] could share some information what are the errors you are receiving? when you are trying to implement