CA Service Management

Hi Community,

The below Screenshot is from ticket service type tab

Can some one share the table name and object name of the attached service types events of a particular ticket

Thank you,

Hi.

The object name is "atev".

the underlaying SDM Schema table name is "Attached_Events".

and the physical db table name is "att_evt".

The ticket reference is stored in the "obj_id" attribute/field as the persistent_id of the ticket.

Hope this helps

Regards

............Michael  

Hey Michael. Is there a specific document you are referencing for this information?  I am trying to pull SLA violation times which are 'attached events' into variables on emails so we can display what time the ticket will break SLA.

Somehow. My starting Point was the file bopcfg/wwww/htmpl/web/analyst/detail_in.htmpl.

There I saw, that for displaying the Service Type tab the file ""xx_stype_tab.htmpl"" is used.

There I found that the the template iterates through "args.sla_events ".

using "bop_sinfo -dq cr" told me that "cr.sla_events " holds a list of atev objects.

The rest of the Information can be found in the technical documentation.

To use this Information in a notification, I'd suggest to use the ttv functionality and the "predicted_sla_violation" or "macro_predicted_violation" Attribute.

Regards

..............Michael