SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_phone, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry WHERE emp_user_name LIKE '%%' AND bb_status='DEPLOYED' ORDER BY emp_user_name