SCCM SQL Qury - SCCM Client Distribution Point

SCCM SQL Qury - SCCM Client Distribution Point

This Query will help to identify SCCM client DP details, if you want to know from which DP you client download the content, Use the below SQL query

select
rsys.Name0 as 'Client Name',
"Content Source Type" = CASE cdh.DistributionPointType
WHEN 1 THEN 'Cloud DP (Distribution Point)'
WHEN 2 THEN 'Management Point'
WHEN 3 THEN 'Peer Cache'
WHEN 4 THEN 'DP (Distribution Point)'
WHEN 5 THEN 'BranchCache'
END
,
cdh.HostName as 'Content Source Host Name',
pkg.Name as'Content Name',
cdh.ContentID,
cdh.BytesDownloaded
from
v_R_System as rsys
join v_ClientDownloadHistoryDP_BG as cdh on rsys.ResourceID = cdh.ClientId
join v_Content as con on con.Content_UniqueID = cdh.ContentID
join v_Package as pkg on con.PkgID = pkg.PackageID
where pkg.name = <your package, application, update name>