SQL Query : All DPs with Site Codes

In a large client estate it is useful to understand as much as possible about your distribution points.  This simple query returns a variety of columns, but there are many more to choose from if required.

SELECT [DPID]
    ,[ServerName]
    ,[SMSSiteCode]
    ,[IsPeerDP]
    ,[IsPullDP]
    ,[IsPullDPInstalled]
    ,[MinFreeSpace]
    ,[Type]
 FROM [DistributionPoints]
 order by ServerName

Sample OUTPUT

Related posts

Leave a Comment