I am trying to modify a report but I am unable to find the TECHNICIANID Below is an example of the script that I have and I tried looking in aaaUser but I'm unable to find the technician I am looking for.

(select sum(ct1.timespent) from ChargesTable ct1 where ct1.TECHNICIANID = 1503 and CREATEDTIME >= <from_yesterday> and CREATEDTIME <= <to_yesterday>)/3600000)+':'+right('0'+CONVERT(varchar(19)