Error log entry search

jjesska

Is there a way to search through all error log entries in sql monitor for a specific string (ie. ip address in the case of pen test week)

chrisqtran

Hi there,

You can try querying the repository directly, but we don't officially support this.

select * from data.Cluster_SqlServer_Error_Instances_View<br>WHERE Cluster_SqlServer_Error_Text LIKE '%10.10.10.10%'

If you decide to do so, take a backup before modifying the repository, as the repository schema can change.