Inspector - missing ServerInfo causes blank Inspector Report

[markwdavies]

Issue
Empty Email body for Inspector reports run on a central server using PoSH

Cause
Stored Proc - [Inspector].[SQLUnderCoverInspectorReport] does not check if null returned when retrieving monitored server Information - this value is concatenated with the rest of the email body text rendering it all null.

Function - [Inspector].[GetServerInfo]
returns null If a row is not found in the [Inspector].[ServerInfo] table for a monitored server

To Reproduce
remove one of the rows in the table for a monitored server and run the Stored Proc to generate an email

workaround
Amend Line 360 in [Inspector].[SQLUnderCoverInspectorReport]
from
+[Inspector].[GetServerInfo](@Serverlist)
to
+ISNULL([Inspector].[GetServerInfo](@Serverlist),'--- no data ---')

[Adedba]

Thanks for reporting, apologies for not responding sooner. Will get this updated and rolled out as a hot fix.