Simple WQL query issue

Question

The full query:

select 
  SMS_G_System_COMPUTER_SYSTEM.Name,
  SMS_G_System_COMPUTER_SYSTEM.Model,
  SMS_R_System.OperatingSystemNameandVersion,
  SMS_R_System.Build,
  SMS_R_User.UniqueUserName

from 
  SMS_R_System
    inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
    INNER JOIN SMS_UserMachineRelationship ON SMS_UserMachineRelationship.ResourceId = SMS_R_System.ResourceId
    INNER JOIN SMS_R_User ON SMS_UserMachineRelationship.UniqueUserName = SMS_R_User.UniqueUserName

WHERE 
  SMS_UserMachineRelationship.Types = 1
  SMS_R_User.UniqueUserName LIKE "%,%"

order by 
  SMS_G_System_COMPUTER_SYSTEM.Name

The issue I am here to discuss and need assistance with is jut this line:

SMS_R_User.UniqueUserName LIKE "%,%"

No matter what I try here after the LIKE operator, it is just always a syntax error. Have no idea what is wrong with it, it matches all the examples online, and previous queries I have written.

Any ideas?

Answer 1

You have a syntax error. You're missing an AND between the two conditions in your WHERE clause. This is standard SQL syntax, so it's nothing special related to WQL.

It should be

WHERE 
  SMS_UserMachineRelationship.Types = 1 AND
  SMS_R_User.UniqueUserName LIKE "%,%"