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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s