SELECT resource.RESOURCENAME "Resource Name",resource.ASSETTAG "Asset Tag",product.COMPONENTNAME "Product",resource.SERIALNO "Serial Number",resFields.UDF_CHAR4 "Make",aaaUser.FIRST_NAME "User",deptDef.DEPTNAME "Department",resFields.UDF_CHAR5 "Model",regionDef.REGIONNAME "Region", reslocation.siteid "siteid"
FROM Resources resource
LEFT JOIN ComponentDefinition product
ON resource.COMPONENTID=product.COMPONENTID
LEFT JOIN ResourceOwner rOwner
ON resource.RESOURCEID=rOwner.RESOURCEID
LEFT JOIN ResourceAssociation rToAsset
ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID
LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID
LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID
LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID
LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
LEFT JOIN RegionDefinition regionDef ON resLocation.REGIONID=regionDef.REGIONID
LEFT JOIN Resource_Fields resFields ON resource.RESOURCEID=resFields.RESOURCEID
WHERE  resLocation.siteid in('5134','5136','5138','5139','5140','5142','5148','5726')