How do you use cloud databases? Take the survey.
Options

Error log entry search

jjesskajjesska Posts: 1 Bronze 1
in Redgate Monitor
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)
Tagged:
· Share on Twitter

Answers

  • Options
    chrisqtranchrisqtran Posts: 93 Silver 1
    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.
    · Share on Twitter
Sign In or Register to comment.