How to show in query the ticket SLA result?

[rsregalado]

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

[Esben_D]

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