TMACUL

CA SDM SQL Script configuration item x service type

Blog Post created by TMACUL Champion on Jul 1, 2016

select nr_service_type , srv.sym

from usp_owned_resource as unr

left join srv_desc as srv on unr.nr_service_type = srv.persid

 

select nr.resource_name , srv.sym

from ca_owned_resource as nr

left join usp_owned_resource as unr on nr.own_resource_uuid = unr.owned_resource_uuid

left join srv_desc as srv on unr.nr_service_type = srv.persid

 

 

Referências cruzadas de tabelas e objetos - CA Service Management - 14.1 - Portuguese - Brazil

Editar metas de serviço - CA Service Management - 14.1 - Portuguese - Brazil - CA Technologies Documentation

Technical Reference Guide r12.6

https://support.ca.com/phpdocs/0/common/impcd/MDBMain/schema/viewer/atomic_cond.htm

Outcomes