Re: Table with Operations Management Services and CIs
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...
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.