The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find change ID in service call report

SOLVED
Go to solution
Highlighted
Jan Gunnar Helg
Senior Member

How to find change ID in service call report

We are running HPOVSD 4.5 SP21

Im writing a simple service desk report, where I display several fields.
I want the ability to list all changes related to a service call, but I cant figure out where to retrive this as v_servicecall doesn't contain this

Any ideas?
2 REPLIES
Vasily Kamenev
Honored Contributor
Solution

Re: How to find change ID in service call report

Hi
Where are you create report? if this on separate system as Crystal reports, then you can to do that. CH and SC you can relate by ITSM_SERVICE_RELATIONS table.

Vasily
Jan Gunnar Helg
Senior Member

Re: How to find change ID in service call report

Thank you that was exaclty what I was looking for :)

We are writing the reports using MS Reporting, which is based on SQL selects.
//Add this to "OnDomLoad" event