joins with devicedetails performed on measurement deviceid rather than measurement srcip