@salewski
In order for the Agent to view all of a User's tickets they have to view the User account in the User Directory. The final link you would want would be scp/users.php?id=XXX (where XXX is the actual User ID). So you could write a custom php file in the scp/ directory, name it custom-script.php for example, call it with scp/custom-script.php?erpid=666666666, the php script will take the custom field value via URL parameter (ie. $_POST['erpid']), lookup the User with this value set via ORM methods, grab the User's ID, create the final URL, and redirect to the final URL of scp/users.php?id=XXX.
Cheers.