Skip to main content
Inspiring
Aug 5, 2024 7:31 AM UTC
Question

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

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
Aug 5, 2024 9:26 AM UTC

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

Inspiring
Aug 5, 2024 9:54 AM UTC

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
Aug 5, 2024 9:33 AM UTC

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
Aug 5, 2024 9:56 AM UTC

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
Aug 5, 2024 10:02 AM UTC

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)