We are running SQL 2008 R2 and would like to monitor the audit log of the SQL server. Can PRTG do that?

Article Comments

Have you checked this other article about how to monitor the logins?


Jan, 2014 - Permalink

Thanks. Just went over that article but that is using the SQL Server Error logs. I need to use the audit logs and haven't come across a SP that reads it.


Jan, 2014 - Permalink

It looks like you would have to create a custom sensor and use something like the query that is shown here then parse out your data that you want and put it into a format that can be read by PRTG.

http://technet.microsoft.com/en-us/library/cc280765.aspx

The formatting of custom sensors can be seen under Setup->PRTG API.


Jan, 2014 - Permalink