Audit settings and support on sqlserver Azure linux

Question

Hello
Is there any limitations on Azure sqlserver linux for audit?
im trying to setup audit all, and I cant
i can only seem to get working audit failures
LGIF LOGIN FAILED = Works
LGIS LOGIN SUCCEEDED = I cant get it to work

thank you!

Answer 1

i found the problem - sqlserver audits are not supported for Linux

however these are the selects

SELECT GETDATE();

SELECT
event_time AS Login_Time,
server_instance_name ,
statement AS Description
FROM sys.fn_get_audit_file('/backup/audit/*.sqlaudit', DEFAULT, DEFAULT)
WHERE
action_id = 'LGIF'

go

SELECT GETDATE();

SELECT
event_time AS Login_Time,
server_instance_name ,
statement AS Description
FROM sys.fn_get_audit_file('/backup/audit/*.sqlaudit', DEFAULT, DEFAULT)
WHERE
action_id = 'LGIS'

go