cancel
Showing results for 
Search instead for 
Did you mean: 

HANA audit log query

SAPSupport
Employee
Employee
174

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.
View Entire Topic
SAPSupport
Employee
Employee

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;