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