Helpdesk: Agent Access & Roles with teams (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists all the agents in the helpdesk and their related information.

The report will only list users that meet all of the following criteria:

• The user is an agent.

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