Service Desk Practitioners Forum
cancel

Relation between CI and Service

SOLVED
Go to solution
Highlighted
Jan Gunnar Helg
Honored Contributor.

Relation between CI and Service

Hi

Running HPOVSD 4.5

Where in the database can I find the many-to-many link between CI and Service? And what are the respective keys?

Trying to write a select which would give me a list of all related CIs for a given Service and visa-versa.
2 REPLIES
The Pike
Acclaimed Contributor.
Solution

Re: Relation between CI and Service

From the top of my head, I recall the table ITSM_SERVICE_CIs. Not sure what keys are in there but now you can look up the table and confirm.

Hope this helps.
Points are welcome.

The Pike
Jan Gunnar Helg
Honored Contributor.

Re: Relation between CI and Service

Cheers, must have missed it =)