Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 JOIN SMS_UserMachineRelationship ON SMS_R_System.Name=SMS_UserMachineRelationship.ResourceName JOIN SMS_R_User ON SMS_UserMachineRelationship.UniqueUserName=SMS_R_User.UniqueUserName WHERE SMS_UserMachineRelationship.Types=1 AND SMS_R_User.UserGroupName="AKERSHUS-FK\\DL-900-SUP-AP002" AND SMS_R_System.OperatingSystemNameandVersion like "%Workstation 10%"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement