Is there a table that joins Incidents tickets and STACKS tickets ?

[Ernesto Barron]

I need to create a report about  Change Request (CHG)   from INC and SCTASK tickets.

Is there a table that joins INC and SCTASK tickets together ?

[Dr Atul G- LNG]

Hi @Ernesto Barron 

So logically you want to build connection b/w 

change Request + Incident + SCtask

odd to me , what purpose sctask need to fulfil here and what exactly you need from change and Inc as one. Change contains Inc record in table and that can work. please provide more details. 

[Ernesto Barron]

Hi @Atul 

As you can see in the picture attached below we have some request SCTASK that are resolved with a change request CHG and some incidents INC that are resolved with Change Request CHG for the same Assigned Group.

I need a report with all tickets INC+SCTASK assigned to this support group with change Request to be able to see the progress of the attention of all the tickets.

I was thinking about "Task" table however this table does not contain change information CHG.

Thanks for your answer.

Ernesto Barrón

[Dr Atul G- LNG]

Hi @Ernesto Barron 

Greetings!!

Got the point, or this need to create the Database view or before that try standard reporting on sc task

This might solve your problem. Give a try and share feedback.