Skip to main content
July 31, 2024
Question

How to get rdbms-audit.log.yyyy-mm-dd.*

  • July 31, 2024
  • 2 replies
  • 0 views

Hi,

I am trying to get a day's worth of rdbms-audit logs.
However, I have tried the following expression, but could not get the logs that have been evacuated.
Any help would be appreciated. Thanks in advance.

Appian version:24.1

Log format: rdbms-audit.log.yyyy-mm-dd.*

readlogpaging(
logPath: "audit\rdbms\rdbms-audit.log." & tostring(year(today())) & "-" & substitute( padleft(tostring(month(today())), 2), " ", "0" ) & "-" & substitute( padleft(tostring(day(today())), 2) & "." & tostring(pv!LogCounter), " ", "0" ),
startIndex: 1,
batchSize: - 1
).rows

    2 replies

    July 31, 2024

    Try using readlog() or readlogpaging() function:

    davidj137213
    Brainy
    July 31, 2024

    Your expression returns:

    "audit\rdbms\rdbms-audit.log.2024-07-31.3"(Text)

    And accoirding to my system logs,  it should return

    "audit\rdbms\rdbms-audit.log.001.2024-06-07.3