cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rsregalado
Engaged Sweeper
Hello Everyone,

I would like to ask your help on how to generate a report showing the ticket SLA result (3d 8h 19m) in my query. I can't find in the tables where it was located.

Appreciate for any feedback.


Regards
1 REPLY 1
Esben_D
Lansweeper Employee
Lansweeper Employee
This information is stored in the main helpdesk table "htblticket"
  • slaname
  • slainitial
  • slaresolved
  • resolvecalc
  • slabusiness
You can find more information about the contents of these field in the database dictionary. Instructions on how to find the database dictionary can be found here: https://www.lansweeper.com/Forum/yaf_postst9870_Lansweeper-database-dictionary.aspx#post38296