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