Find Your Agent's Permissions, Roles and Teams
Get an overview of all your helpdesk agents, their access, role, team and whether they are using an agent license. Get an overview of all helpdesk agents within your Lansweeper installation and see which roles they currently have and if they are using an agent license. This overview allows you to manage your agent licenses and roles more efficiently.
Helpdesk Agent Access & Roles with Teams Query
Select Top 1000000 htblteams.teamname As Team, htblusers.name As Agent, htblusers.username, htblusers.userdomain, htblusers.email As Email, htblusers.mobile, htblusers.telephone, htblusers.company, htblusers.department, tsysLanguages.EnglishName As Language, tsysRoles.Name As Role, Case htblagents.active When 1 Then 'Yes' Else 'No' End As IsLicensed From htblusers Left Join tsysRoles On htblusers.Roleid = tsysRoles.RoleID Inner Join htblagents On htblusers.userid = htblagents.userid Inner Join tsysLanguages On tsysLanguages.LanguageId = htblusers.language Left Join htblagentteam On htblagents.agentid = htblagentteam.agentid Left Join htblteams On htblteams.teamid = htblagentteam.teamid Where htblusers.name <> 'System' Order By Team, Agent