‎05-20-2016 08:14 AM
‎05-20-2016 02:57 PM
select ticketid, subject from htblticket INNER JOIN
htblagents ON htblagents.agentid = htblticket.agentid INNER JOIN
htblusers ON htblusers.userid = htblagents.userid
WHERE htblusers.name = 'Built-in admin'
select htblticket.ticketid, htblticket.subject, htblnotes.note AS description from htblticket INNER JOIN
htblagents ON htblagents.agentid = htblticket.agentid INNER JOIN
htblusers ON htblusers.userid = htblagents.userid
INNER JOIN htblnotes on htblnotes.ticketid = htblticket.ticketid
WHERE htblusers.name = 'Built-in admin' AND htblnotes.notetype = 3
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now