AnsweredAssumed Answered

CABI last date of using categries (WI report)

Question asked by Emad_Almalki on Jul 24, 2017
Latest reply on Jul 24, 2017 by Jon_Israel

Hi Everybody,

I am using Ca SDM 14.1 integrated with CABI

Could you share with me SQL query that returns a list of categories aligned with its last used date in Web Inelegant report format?

I meant by last date, the date of creating last ticket on each category.

 

Example:

***************************************************************************************

*****Category Name**********Category Type*************Last used Date*******

***************************************************************************************

       SAP ERP Support            Incident                            1/5/2016

       New Oracle DB                 Request                           1/1/2017

 

Appreciate your response.

Outcomes