Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to report on Change - > WO relations

SOLVED
Go to solution
Highlighted
Jan Gunnar Helg
Senior Member

How to report on Change - > WO relations

Hi

Im making some SQL selects and Im trying to figure out how to find the link between changes and WO's in the database.

Do anyone know in which table this is stored, or if there is a view I can use?
2 REPLIES
Solution

Re: How to report on Change - > WO relations

that realationship doesnt stored in itsm_service_relations, as expected.

itsm_workorders column wor_cha_oid

there is such nice thing Database dictionary. get it at System Panel -> Report Settings -> Generate Data Dictionary

HTH,
Igor Barinov
Jan Gunnar Helg
Senior Member

Re: How to report on Change - > WO relations

Thanks :)
//Add this to "OnDomLoad" event