‎01-02-2017 04:02 PM
‎01-18-2017 02:59 PM
‎01-16-2017 05:45 PM
Select Top 1000000 htblusers1.name As [Ticket User],
htblticket.ticketid As [Ticket ID],
htblusers.name As [Ticket Creator],
htblticket.date As [Creation Date],
htblhistorytypes.name As [Creation Type]
From htblhistorytypes
Inner Join htblhistory On htblhistorytypes.typeid = htblhistory.typeid
Inner Join htblticket On htblticket.ticketid = htblhistory.ticketid
Inner Join htblusers On htblusers.userid = htblhistory.userid
Inner Join htblusers htblusers1 On htblticket.fromuserid = htblusers1.userid
And htblhistory.userid != htblusers1.userid
Where htblticket.date > '2017-01-01 00:00:00.000' And htblhistorytypes.typeid = 13
‎01-12-2017 01:42 PM
‎01-09-2017 01:07 PM
‎01-09-2017 04:04 PM
RTI_IT wrote:
Thank you, this is very close to what I was looking for! What would need to be done to limit the date ranges? When I run this as is it's showing tickets dating back to when we first started the Beta, really we are only interested in tracking the current year (2017).
Thank you so much,
-Ed
Select Top 1000000 htblusers1.name As [Ticket User],
htblticket.ticketid As [Ticket ID],
htblusers.name As [Ticket Creator],
htblticket.date As [Creation Date],
htblhistorytypes.name As [Creation Type]
From htblhistorytypes
Inner Join htblhistory On htblhistorytypes.typeid = htblhistory.typeid
Inner Join htblticket On htblticket.ticketid = htblhistory.ticketid
Inner Join htblusers On htblusers.userid = htblhistory.userid
Inner Join htblusers htblusers1 On htblticket.fromuserid = htblusers1.userid
And htblhistory.userid != htblusers1.userid
Where htblticket.date > '2017-01-01 00:00:00.000' And (htblhistorytypes.typeid = 13) Or
(htblhistorytypes.typeid = 31)
‎01-03-2017 03:46 PM
Select Top 1000000 htblusers1.name As [Ticket User],
htblticket.ticketid As [Ticket ID],
htblusers.name As [Ticket Creator],
htblticket.date As [Creation Date],
htblhistorytypes.name As [Creation Type]
From htblhistorytypes
Inner Join htblhistory On htblhistorytypes.typeid = htblhistory.typeid
Inner Join htblticket On htblticket.ticketid = htblhistory.ticketid
Inner Join htblusers On htblusers.userid = htblhistory.userid
Inner Join htblusers htblusers1 On htblticket.fromuserid = htblusers1.userid
And htblhistory.userid != htblusers1.userid
Where (htblhistorytypes.typeid = 13) Or
(htblhistorytypes.typeid = 31)
‎06-07-2017 03:53 AM
Nick.VDB wrote:
We have added an example report that should give back the information that you are after. The tests in our helpdesk did give back the wanted results.
Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:
- Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
- Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.
Select Top 1000000 htblusers1.name As [Ticket User],
htblticket.ticketid As [Ticket ID],
htblusers.name As [Ticket Creator],
htblticket.date As [Creation Date],
htblhistorytypes.name As [Creation Type]
From htblhistorytypes
Inner Join htblhistory On htblhistorytypes.typeid = htblhistory.typeid
Inner Join htblticket On htblticket.ticketid = htblhistory.ticketid
Inner Join htblusers On htblusers.userid = htblhistory.userid
Inner Join htblusers htblusers1 On htblticket.fromuserid = htblusers1.userid
And htblhistory.userid != htblusers1.userid
Where (htblhistorytypes.typeid = 13) Or
(htblhistorytypes.typeid = 31)
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now