Query to get Active Technician key list with Technician info.
Version : 13004
DB : PGSQL
OUTPUT:
select au.first_name,
techkey.techniciankey,
techkey.status from techniciankeydefinition techkey
left join AaaLogin al on techkey.LOGIN_ID = al.LOGIN_ID
Left join AaaUser au on al.user_id=au.user_id where techkey.status = 'active'
techkey.techniciankey,
techkey.status from techniciankeydefinition techkey
left join AaaLogin al on techkey.LOGIN_ID = al.LOGIN_ID
Left join AaaUser au on al.user_id=au.user_id where techkey.status = 'active'