SELECT Cs-username AS User,MyDeviceId AS DeviceId, COUNT(*) AS Hits
USING EXTRACT_VALUE(cs-uri-query,'DeviceId') AS MyDeviceId
FROM '[LOGFILEPATH]'
WHERE cs-uri-query LIKE '%Error:WrongObjectTypeException%'
GROUP BY DeviceId,User
ORDER BY Hits DESC