HANA audit log query

[SAPSupport]

Dear SAP Team,

We need SQL query to extract PERSON_NAME DB audit log from PERSON_NAME studio for specific day.

Kindly help us.

Regards,

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello,

You can run the query below to get the data of a specific date.
Example below is for 2024-06-15.

select * from audit_log where left(TIMESTAMP, 10) = '2024-06-15' ORDER BY TIMESTAMP;


With query below, you can see the data from 2024-06-15 01:00:00 to 2024-06-15 02:00:00

select * from audit_log where TIMESTAMP between '2024-06-15 01:00:00' and '2024-06-15 02:00:00' ORDER BY TIMESTAMP;