TickectList Statistics with linked CI

[Gonzalo]

Hello!

I was triying to extract a ticketlist Statistic with the CI related to do a report, but I could not.

Is there any way to extract a Tickectlist with the configuration elements linked to these tickets?

Thanks

[jojo]

only via sql

[Gonzalo]

Thanks jojo!

I don't know how to do the sql query. The problem I have is that the table ticket(id,tn,totle,queue_id,ticket_lock_id,type_id,Service_id,sla_id,user_id,responsible_user_idticket_priority_id...) don't have any colunm related with the table configitem (id, configitem_number, class_id, last_version_id, cur_depl_state_id, cur_inci_state_id, create_time, create_by change_time, change_by )

Maybe there is another table which are related ... Any idea? Neither I see any relationship with the table link_object

Thanks!

[Gonzalo]

Can anyone help me in this topic?

[ardli]

only via sql

Can you give an example of a sql command jojo?

thx

[EXG133]

I can't give you an exact SQL query, it's not my thing and this is too complicated for me. But perhaps this will help:

Linking is done in the table link_relation supported by link_object, link_state and link_type. If you look at the values in the supporting tables it should be fairly easy to see how it works.

you will have to check the link_relation table for the actual links and the other tables to translate the ID's used in link_relation to human readable values.