HowTo Create SCCM collection based on failed advertisement
Hello
I came across with advertisment that failed 50% because of some setting wrong,
Before installation of the software requested was necessary to install a specific patch failed computers,
I found the following query that finds the computers that have failed in the original Advertisment
SELECT sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client FROM sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID WHERE AdvertisementID = ‘XXX#####’ and LastStateName = “Failed”
You know the rest here,
Yair
Categories: SCCM
Collecetion, Howto, SCCM
Comments (0)
Trackbacks (0)
Leave a comment
Trackback