File Share Audit

[Guest Anonymous562646]

Hello,

 

I'm having a request come in my way to audit a file share location on our

network where some SQL Server Reporting Services reports are being written

to. We extend different set of reports for different clients and some of

these reports are scheduled to be written to the file share as excel files.

We would like to audit who is accessing those folders and how many times etc.

Is there any way to log them to a different log file other than the default

files (Event Viewer), so that we can build a report on top of this

information?

 

Hence I would like to know from peers in this area whether they have any

solution with respect to such type of audit in a detailed step by step.

 

TIA