I have tried the following queries in SQL Editor:
SELECT * FROM sys.fn_get_audit_file ('\\"mydatabase"\Z$\NONDBDATA\SQLAudits\Audit-Test_*.sqlaudit',default,default);
SELECT * FROM sys.fn_get_audit_file ('\\"mydatabase"\Z:\NONDBDATA\SQLAudits\Audit-Test_*.sqlaudit',default,default);
SELECT * FROM sys.fn_get_audit_file ('\\"mydatabase"\C:\SQLAudits',default,default);
I receive the following error:
com.microsoft.sqlserver.jdbc.SQLServerException: The specified pattern did not return any files or does not represent a valid file share. Verify the pattern parameter and rerun the command.
No results found.
Thanks!
... View more