In the im_incident table there is a field for the currently assigned analst - usr_currentassignedanalyst. This field reflects the actual name of an analyst in the tps_user.tps_title field. I need to locate a reference to the most recent current assigned analyst's guid in tps_user for incidents currently assinged to that analyst, but using usr_currentassignedanalyst from im_incident isn't an option, as there may be multiple analysts with the same name being assigned to the tps_user table from our company's active directory - I know it's unlikely, but my boss says if it's possible then we need to code for it. Is there a reference to the currently assigned user's guid in tps_user that can be located within the incident schema? If so, would i need to include any other field value comparisons or aggregate functions to isolate that guid?
Thanks in advance.