MIM Sync Health Report

The MIM Sync health check report shows health check results spanning a range of time.

By limiting results to health checks with the archive flag, only health checks that triggered a workflow, as well as the first check of each hour are included.

Required Customization

If you have configured separate health checks for multiple sync environments or renamed the health check to something other than "MIM Sync Health" it will be necessary to revise the Name parameter query data set. It may also be useful to add a second report parameter for Server following the pattern of the Server Performance report.

Optional Customization

If you have added, removed, or renamed probes in the MIM Sync health check(s) it will be necessary to make matching alterations to the the report fields.

To allow user friendly formatting and styling of results the report must re-calculate the pass/fail condition of each of the resultant probes. If you have customized the pass/fail thresholds in the health check settings the same adjustments should be made to the report Style strips.

JSON Definition

Copy the following JSON into a text file, and upload to report settings. Requires 3.3.10 or later. 

{
  "Data": [
    {
      "$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
      "Id": "0fc3130b-389e-41d9-8746-5c036b90a018",
      "Name": "MIM Sync Health Check",
      "UserId": null,
      "UserProfile": false,
      "Tags": null,
      "Roles": null,
      "CacheExpiration": "01:00:00",
      "Description": "Health check report for MIM Sync status over time",
      "Parameters": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
          "Name": "Days",
          "Description": "Number of days of health checks to display",
          "Required": true,
          "Validation": "Double",
          "DefaultValue": "30"
        }
      ],
      "DataSets": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
          "Aliases": null,
          "MapRule": "",
          "Name": "Health",
          "Type": "SoftwareIDM.PanelModel.Models.HealthCheck, SoftwareIDM.PanelModel",
          "Clauses": [
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Archive",
              "Operation": "Eq",
              "Value": "true"
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "TimeStamp",
              "Operation": "Gte",
              "Value": "AddTime(Now(), \"-\" + Days(Memo(\"Days\")))"
            },
            {
              "$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
              "Field": "Name",
              "Operation": "Eq",
              "Value": "\"MIM Sync Health\""
            }
          ],
          "SubQueries": []
        }
      ],
      "ReportSets": [],
      "Relations": [],
      "FieldProjections": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "TimeStamp",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "TimeTraveler(Id, null, context) + \"|\" + DateTimeFormat(TimeStamp, \"yyyy-MM-dd hh:mm:ss\")"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Passed",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "If(Passed, \"Yes\", \"No\")"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Schedule Running",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "$\"{Data.Schedule Running.Value} runs\""
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Service Running",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Data.Service Running.StringValue"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DB Available",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Data.DB Available.StringValue"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Backed Up",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Data.Backed Up.Value"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Disk Space",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Data.Disk Space.StringValue"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "DB Size",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Data.DB Size.StringValue"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Log Size",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Data.Log Size.StringValue"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Synced per Sec",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "Sum(Map(Data.Synced per Sec.Instances, Value))"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Imported per Sec",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "FormatDouble(Sum(Map(Data.Imported per Sec.Instances, Value)), \"####0\")"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
          "Name": "Exported per Sec",
          "RelationName": "",
          "RelationSide": null,
          "ValueRule": "FormatDouble(Sum(Map(Data.Exported per Sec.Instances, Value)), \"####0\")"
        }
      ],
      "Transformations": [],
      "Styles": [
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Passed"
          ],
          "ConditionRule": "Passed == \"Yes\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "g",
          "CellColor": "g"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Passed"
          ],
          "ConditionRule": "Passed == \"No\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "g",
          "CellColor": "r"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Schedule Running"
          ],
          "ConditionRule": "CoerceLong(ReplaceString(Data.Schedule Running, \" runs\", \"\")) == 0",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Service Running"
          ],
          "ConditionRule": "Data.Service Running != \"Running\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "DB Available"
          ],
          "ConditionRule": "Data.DB Available != \"Available\"",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        },
        {
          "$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
          "Fields": [
            "Backed Up"
          ],
          "ConditionRule": "Data.Backed Up > Days(7)",
          "Bold": false,
          "Italic": false,
          "Hide": false,
          "TextColor": "r",
          "CellColor": "r"
        }
      ],
      "Sort": {
        "Field": "TimeStamp",
        "Direction": "Descending"
      }
    }
  ],
  "Count": 1
}