Service Desk Practitioners Forum
cancel

Table with Operations Management Services and CIs

Highlighted
Robert S. Falko
Acclaimed Contributor.

Table with Operations Management Services and CIs

Hello,

In which table are the relations between Operations Management Services and CIs (that is, the managed CIs) to be found?

-Josh
2 REPLIES
Gyula Matics_1
Acclaimed Contributor.

Re: Table with Operations Management Services and CIs

The relation is on the CI itself.

itsm_configuration_items.cit_mgmt_service_oid = Managed by service
Saurabh Dubey
Acclaimed Contributor.

Re: Table with Operations Management Services and CIs

Hi Josiah,

This should help you...

select CIT_SEARCHCODE as 'Configuration Item', srv_name as 'Operation Management Service' from itsm_configuration_items as ci, itsm_services as ser
where CIT_MGMT_SERVICE_OID = srv_oid and srv_typ_oid = '281484180390192'

The field CIT_MGMT_SERVICE_OID in itsm_configuration_items tells you about the service that is related to the CI.

Hope this helps...

Regards,

Saurabh
Modesty is good!! But remember, all your life other people will try and take your achievements away from you, don't make it easy for them.