Skip to main content
Inspiring
August 5, 2024
Question

How can we save the System Log's 'Login Audit' file inside Appian's Knowledge Centre

  • August 5, 2024
  • 5 replies
  • 0 views

We have a requirement to save login-audit.csv files into the database and show them in grid format. The problem is that the files older than 1 month are saved in 'gzipped' format and I am unable to access them using 'Log reader' plugin. I thought of an approach that includes saving these files into appian and then unzipping them for further processing but I am unable to save them.
Any help is much appreciated.

5 replies

stefanhelzle0001
Brainy
August 5, 2024

There is no simple way to do that. But, what do you try to achieve?

Inspiring
August 5, 2024

I am trying to read these data and show them in a grid to the user who is requesting the login data for a particular date.

davidj137213
Brainy
August 5, 2024

YOu can usse the following app

 [mention:658bb2784a73446da4da1902ffbfcb71:f7d226abd59f475c9d224a79e3f0ec07] 

Will save the login information into a table in your database, that will be populated every day via batch process with the information contained in the login-audit-csv... in that way you won't need to work with gzip files

Inspiring
August 5, 2024

Yes that can be useful for the upcoming login sessions but the client can also request for the past data. That is why I was trying to create a workaround.

davidj137213
Brainy
August 5, 2024

Yes, we had to do the same.....

YOu can customize the application and use different log files located in diferent KNowledge centers (only for the first time, decompress the gzips, and load it into the database)