Health: JSON for Report

{
"schemaVersion": "3.0",
"run": {
"RunId": "mock-run-003",
"Instances": [
"PROD-SQL01\SQL2019"
],
"GeneratedAt": "2026-03-26T10:00:00-07:00",
"DbatoolsVersion": "2.x"
},
"score": {
"OverallScore": 81.4,
"DomainScores": [
{
"Collector": "Instance",
"Score": 95,
"Coverage": 100,
"Weight": 1.0,
"Findings": 2
},
{
"Collector": "Databases",
"Score": 78,
"Coverage": 100,
"Weight": 1.3,
"Findings": 4
},
{
"Collector": "Backups",
"Score": 68,
"Coverage": 100,
"Weight": 1.6,
"Findings": 4
},
{
"Collector": "Jobs",
"Score": 65,
"Coverage": 100,
"Weight": 1.0,
"Findings": 3
},
{
"Collector": "HaDr",
"Score": 92,
"Coverage": 100,
"Weight": 1.6,
"Findings": 3
},
{
"Collector": "Storage",
"Score": 88,
"Coverage": 100,
"Weight": 1.3,
"Findings": 2
},
{
"Collector": "Security",
"Score": 60,
"Coverage": 100,
"Weight": 1.2,
"Findings": 2
},
{
"Collector": "Performance",
"Score": 80,
"Coverage": 100,
"Weight": 1.2,
"Findings": 2
},
{
"Collector": "Replication",
"Score": 100,
"Coverage": 100,
"Weight": 1.1,
"Findings": 1
},
{
"Collector": "TempDb",
"Score": 70,
"Coverage": 100,
"Weight": 1.0,
"Findings": 1
},
{
"Collector": "ErrorLog",
"Score": 75,
"Coverage": 100,
"Weight": 0.9,
"Findings": 1
},
{
"Collector": "Shares",
"Score": 100,
"Coverage": 100,
"Weight": 0.9,
"Findings": 1
}
],
"TotalFindings": 26,
"CriticalCount": 3,
"WarningCount": 8,
"UnknownCount": 0,
"HealthyCount": 9,
"InfoCount": 6
},
"findings": [
{
"CheckId": "BACKUP-LAST-LOG",
"TargetName": "SalesDB",
"State": "Critical",
"Message": "No log backup found for FULL recovery database.",
"Evidence": {
"LastLogBackup": "",
"WarnMinutes": 90
}
},
{
"CheckId": "JOB-FAILURES",
"TargetName": "LogBackupJob",
"State": "Critical",
"Message": "Last status for job 'LogBackupJob' is 0.",
"Evidence": {
"Enabled": true,
"LastRun": "2026-03-26T08:55:00",
"Message": "The step failed."
}
},
{
"CheckId": "CERT-EXPIRY",
"TargetName": "AGEndpointCert",
"State": "Critical",
"Message": "Certificate 'AGEndpointCert' expires in 9 day(s).",
"Evidence": {
"ExpiryDate": "2026-04-04",
"DaysRemaining": 9
}
},
{
"CheckId": "TEMPDB-FILES",
"TargetName": "tempdb",
"State": "Warning",
"Message": "TempDB data file count is below the warning threshold.",
"Evidence": {
"FileCount": 2,
"WarnThreshold": 4
}
},
{
"CheckId": "ERRORLOG-SCAN",
"TargetName": "PROD-SQL01\SQL2019",
"State": "Warning",
"Message": "Potentially important patterns found in SQL error log.",
"Evidence": {
"Sample": "I/O requests taking longer than 15 seconds | deadlock encountered | backup failed"
}
}
]
}