The followinf sql query lists all Distribution Points that belongs to a Distribition Point Group

SELECT     vDistributionPoints.ServerName, vDistributionPoints.SMSSiteCode, vDistributionPoints.IsPXE, vDistributionPoints.SupportUnknownMachines, 
                      vDistributionPoints.PreStagingAllowed, vDistributionPoints.IsPullDP, vDistributionPoints.IsProtected, vDistributionPoints.DPDrive, vDistributionPoints.MinFreeSpace, 
                      vSMS_DPGroupInfo.Name AS DPGroup
FROM         vDistributionPoints INNER JOIN
                      v_DPGroupMembers ON vDistributionPoints.NALPath = v_DPGroupMembers.DPNALPath INNER JOIN
                      vSMS_DPGroupInfo ON v_DPGroupMembers.GroupID = vSMS_DPGroupInfo.GroupID
WHERE     (vSMS_DPGroupInfo.Name LIKE '%windows%' and vDistributionPoints.SMSSiteCode = 'P01')
ORDER BY vDistributionPoints.ServerName