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

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

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