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

Read More