search

windows-admins / ConfigMgr

GNU General Public License v3.0
225 stars 57 forks source link

Fix DP collection #84

Closed Ebag333 closed 3 years ago

Ebag333 commented 5 years ago

Doesn't have Pull DPs in it 

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ResourceNames in (Select ServerName FROM SMS_DistributionPointInfo where SMS_DistributionPointInfo.IsPullDP = '1')