Create a somewhat random collection using SMSUniqueIdentifier
This query will allow you to create a somewhat random collection based on the SMSUniqueIdentifier add more or less numbers depending on your target deployment size
1 2 3 4 5 6 7 8 9 |
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.SMSUniqueIdentifier like "%[012]" --from SMS_R_System where SMS_R_System.SMSUniqueIdentifier like "%[0123456789ABCDEF]" |