Health Report

• Volker.Bachmann

  SSC Enthusiast

  Points: 166

  More actions

  April 24, 2013 at 7:31 am

  #293020

  Hi,

  first of all a big "Thank You" for this script!

  This is exactly what I'm seraching for.

  On the first two server the Reports work fine but the third one has Replication configured and the Report was empty.

  I've found two points to correct.

  - added some Coalesce in the HTML Creation part of "Replication Publisher"

  - there was a warning: Null value is eliminated by an aggregate or other SET operation.

  this could be solved by adding an isnull around the Max of ja.start_execution_date and ja.stop_execution_date

  One question: the health report is quite long on our server so it would be a good idea to have a quickreport of the changes from one day to another. Do you think this is possible with the data that are collected right now?

  Thanks again and best regards,

  Volker Bachmann