Central Management Server Daily Script

  • Comments posted to this topic are about the item Central Management Server Daily Script

  • Excellent script, just had to adjust the first row to:

    WITH Waits (servername, wait_type, wait_time_s, pct, rn) AS....

    to include the columns!

    Will use this in the daily reporting!

  • ...and I guess it's

    SELECT * FROM #waitstats

    and not

    SELECT * FROM ..sysprocesses

    right? 🙂

  • So glad you found it useful! Yes, sorry sometimes when you post the scripts it doesn' print out quite right. I am in a mixed environment so sometimes I get information from my 2000 servers... hence the ..sysprocesses.

    Thanks for your reply, enjoy!


  • What section of the code are you asking about in regards to the select * from ..sysprocesses? Sorry just want to be sure I give you the right feedback 😎



  • Thanks for the script and thanks for the updates.

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

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