Post reply

One Query to Check All Registered Servers' Windows and SQL Logs?

  • February 8, 2012 at 1:38 pm

    #256532

    I know I can right click a folder under registered servers and do a query. How do I query all of these servers in one breath for any warnings or errors?

  • February 8, 2012 at 1:40 pm

    #1444768

    ahthomas (2/8/2012)

    I know I can right click a folder under registered servers and do a query. How do I query all of these servers in one breath for any warnings or errors?

    What warnings or errors do you mean?

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • February 8, 2012 at 1:42 pm

    #1444770

    Such as: SQL Server Agent > Error Logs > Current

    And the Windows NT logs that you can check off in the window that opens like Application, Security, etc etc.

  • February 9, 2012 at 7:17 am

    #1445052

    Bump...

  • February 10, 2012 at 4:47 am

    #1445461

    I personally loop through a list of linked servers and pick up the job and error logs. Collate them all and then attach to an email and send. Traditionally we have used SSIS to do this but Powershell would seem like a good candidate also.

    For examples of both techniques see Google.

  • February 14, 2012 at 7:22 am

    #1446839

    There should be a way to just run a simple select statement on the folder with the registered servers.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply