I am trying to find out who created an audit (found under Audits) but I don't seem to have any luck. I've already tried many queries such as these:
SELECT * FROM [sys].[objects] SELEcT * FROM sys.server_audits
They seem to work for all other objects, but not for audit. I need to know which user created the audit and which user altered it last. sys.server_audits does not help.