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'
Topic Participants
abdul samad
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?