We’re currently experiencing a high volume of support requests, which may result in longer response times — Thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BradWilcox
Engaged Sweeper
If I want to know all of the tickets that were closed in a certain timeframe, what field would I look at in the database?
1 REPLY 1
Karel_DS
Champion Sweeper III
You'll have to look at the date column in htblhistory, specifically the last entry where typeid = 1 and ticketstateid = 1, if the row exists for a ticket.

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now