Determine which Distribution Points are Offline
select distinct ServerName,vss.percentfree, vss.status, dp.sitecode, dp.bitsenabled, vss.DownSince,vss.TimeReported from vSummarizer_SiteSystem as vss left join v_DistributionPointInfo as dp on vss.SiteSystem = dp.NALPath where vss.role = ‘SMS Distribution Point’ and vss.status > 0 order by servername, downsince