monitor sql server audit log
Modified on 2025-06-10 13:57:18 +0200
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.
Important: We no longer maintain this article. The information might be out of date.
We are running SQL 2008 R2 and would like to monitor the audit log of the SQL server. Can PRTG do that?
Article Comments
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
Disclaimer:
The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.
Have you checked this other article about how to monitor the logins?
Jan, 2014 - Permalink