record details needed

[pramn]

Hi Team , 

i need filter these data , in which table i will get these data

Config Item ID’s associated with these… as well as tickets opened against all the CI’s.

Upstream CI ID’s

Downstream CI ID’s

Main CI ID’s

[Dr Atul G- LNG]

Hi @pramn 

Main CI ID’s --> Incident table

Upstream CI ID’s

Downstream CI ID’s. for both cmdb_rel table

[Dr Atul G- LNG]

Like this

provide more accurate details.

[pramn]

Thanks Atul , 

the column they re looking for 

Columns needed are

Ticket #, Parent Ticket #, Task Type, Configuration Item ID, Configuration Item Name, Short Description, Description, Work Notes, Closure Notes, Actual Start Time, Actual End Time, Assignment Group

[Dr Atul G- LNG]

You can use the earlier shared report and add any columns you need. I’m still not clear on what exactly you want to achieve.