SELECT Max(workstation.workstationname)"Machine Name", 
       Max(aaauser.first_name) "User" FROM   systeminfo workstation 
       LEFT JOIN resources rs 
              ON workstation.workstationid = rs.resourceid 
       LEFT JOIN softwareinfo si 
              ON workstation.workstationid = si.workstationid 
       LEFT JOIN softwarelist sl 
              ON si.softwareid = sl.softwareid 
       LEFT JOIN resourceowner rOwner 
              ON rs.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 
WHERE  workstation.workstationid NOT IN (SELECT workstationid 
                                         FROM   softwareinfo wi 
                                                LEFT JOIN softwarelist wl 
                                                       ON 
                                                wl.softwareid = wi.softwareid 
                                         WHERE 
       wl.softwarename LIKE '%Microsoft%') 
GROUP  BY workstation.workstationname