jeezy43
New Member
- Messages
- 1
- Reaction score
- 0
- Points
- 1
Hello all,
I have been using this site for awhile now and appreciate all the help I have received. I have a question that I have not been able to find an answer on. I am looking to create a device collection that will find all windows 10 machines that can't upgrade to windows 11. I have this query, and it's coming back with results but I just want to make sure it's catching them all.
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 inner join SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS on SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExProp = "Red" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.Version = "CO21H2" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExU = "Red"
What are you guys doing to find windows 10 machines that can't upgrade? Many thanks.
I have been using this site for awhile now and appreciate all the help I have received. I have a question that I have not been able to find an answer on. I am looking to create a device collection that will find all windows 10 machines that can't upgrade to windows 11. I have this query, and it's coming back with results but I just want to make sure it's catching them all.
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 inner join SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS on SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExProp = "Red" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.Version = "CO21H2" and SMS_G_System_UPGRADE_EXPERIENCE_INDICATORS.UpgExU = "Red"
What are you guys doing to find windows 10 machines that can't upgrade? Many thanks.
