This query will allow you to report on the installation status of all packages on a specified Distribution Point. SELECT Name, Description, v_DistributionPoint.LastRefreshTime, Manufacturer, Version, Language, v_Package.SourceSite, v_Package.PackageID, case when v_DistributionPoint.IsPeerDP=1 then ‘*’ else ” end as BranchDP FROM v_Package INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID WHERE v_DistributionPoint.ServerNALPath LIKE ‘%BLRSCCM10001%’ Order by Name Sample Output
Read MoreWednesday, October 28, 2020
