Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Nick_VDB
Champion Sweeper III
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

0 REPLIES 0

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now