CA Service Management

  • 1.  CA Database

    Posted Feb 09, 2016 01:00 AM

    hi

     

    This is related to CA Service desk manager. We see "DELAY REMAINING" field in SERVICE TYPE tab in the incident/request tickets. we are preparing a report so we need to know where it is located in the CA database. I would need tablename and column name for this field.



  • 2.  Re: CA Database
    Best Answer

    Posted Feb 09, 2016 11:20 AM

    It is a calculated value based on two attributes in the att_evt (Attached_Events) table, status_flag ( > 10 ) and fire_time.

     

    Look at the xx_stype_tab.htmpl file.



  • 3.  Re: CA Database

    Posted Feb 29, 2016 05:58 PM

    Hello Sonakshi,

     

    Did Lindsay's answer help?

     

    I'm flagging his post as "Correct Answer" in the meantime.

     

    Thanks, Kyle_R.

    Mod.