Jetzt Ausprobieren

Helpdesk Agent Access & Roles with Teams

Helpdesk

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. Agent Access & Roles with teams

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

Show

Hide