Query to get Active Technician key list with Technician info.

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'

                New to ADSelfService Plus?