‎04-16-2018 08:04 PM
‎04-26-2018 03:53 PM
Select Top 1000000 Count(htblticket.ticketid) As [# of tickets]
From htblticket
Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
Where Cast(htblnotes.note As nvarchar(1000)) Like '%123%' And
htblticket.subject Like '%user locked out%'
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now