SCCM SQL query to list all the content of distribution point group

There was a request from twitter friend who is trying to create SQL report to list the content of distribution point group with content status such as total targeted, installed, progress and errors. Distribution point groups is available in configuration manager for almost several years . This basically provide a logical grouping of distribution points…