Plug-ins functions definitions

Question

Hii, 
 In the process of moving the log files from Appian to AWS cloud watch, I found a way i.e to possibly download the .csv and .log files in bulk amounts and then move them to the Aws S3 Bucket. 
 So to do so I found a function in the SFTP plug-in, "queryappianlogs()" but not sure what are the parameters to pass like the SQL statements. 
 Can you please help me to sort out this one, this allows me to download fixed to 1000 rows.

Mathieu Drouin · Answer

Query Appian Logs function returing different result set in different environments

Not Answered

HI I'm currently using below code to retrieve the audit log from Appian logs. queryappianlogs(
 sqlStatement: "SELECT * FROM login-audit",
 hasHeader: false()
 ).data Is there any way to call the audit…

By adithyay over 4 years ago in Discussions > General

2 replies

Latest by adithyay over 4 years ago

Replied to: Get data from Login Audit.csv in distributed environment?

Thanks, Will try it out. Can you suggest how we need to pull the previous day log? Currently I'm using below code and it is working fine. queryappianlogs(
 sqlStatement: "SELECT * FROM login-audit",…

By adithyay over 4 years ago in Discussions > General

Not sure if it supports a WHERE clause. Probably the easiest is to do a select * and either do the filtering via an expression or insert into a Record and do a query from there.

Mathieu Drouin · Answer

Doesn&rsquo;t work for me either. The function is not listed on the plugin page so it may have been deprecated. 
 Have you tried this plugin instead? 
 community.appian.com/.../log-reader