Catalog Services and SLA
Hello guys
I have this query:
SELECT CategoryDefinition.CATEGORYNAME "Categoria", SubCategoryDefinition.NAME "SubCategoria" ,
ItemDefinition.NAME"Elemento" FROM CategoryDefinition left join SubCategoryDefinition on SubCategoryDefinition.CATEGORYID=CategoryDefinition.CATEGORYID left join ItemDefinition on ItemDefinition.SUBCATEGORYID = SubCategoryDefinition.SUBCATEGORYID where categorydefinition.Isdeleted = 0
order by CategoryDefinition.CATEGORYNAME
Can you help us to add to this query the follow information:
- SLA Name
- Resolution Time
- Response Time
My Version is:
9.1
Construir
9118
DB: MySql
Topic Participants
rodolfo.estrada
Jai Anand Krishnamoorthy
ServiceDesk Plus