Skip to main content
somanathd7926
somanathd7926
July 7, 2023
Question

Plug-ins functions definitions

  • July 7, 2023
  • 5 replies
  • 0 views

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.

    5 replies

    mathieud0001
    mathieud0001
    Brainy
    July 7, 2023

    [View:https://community.appian.com/discussions/f/general/18541/query-appian-logs-function-returing-different-result-set-in-different-environments]

    [View:https://community.appian.com/discussions/f/general/18452/get-data-from-login-audit-csv-in-distributed-environment/72679#72679]

    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.

    somanathd7926
    somanathd7926Author
    July 7, 2023

    Hii,

        with the above quick fix, I tried to write the equation, but this displays an error like this

    mathieud0001
    mathieud0001
    Brainy
    July 7, 2023

    Does it return anything if you remove the order by?

    Terms & ConditionsAccessibility statement