SQL query for service contracts and their groups

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

This tech doc gives the SQL query statement for extracting Service Desk service contracts and their associated groups.

Environment

Release : 17.3

Resolution

select ca_contact.last_name as "Group", sdsc_map.map_contract as "Contract ID",svc_contract.sym as "Contract Name" from ca_contact
  JOIN sdsc_map ON SUBSTRING(CONVERT(nvarchar(34),ca_contact.contact_uuid,1),3,32) = SUBSTRING(sdsc_map.map_persid,5,32)
  JOIN svc_contract ON sdsc_map.map_contract=svc_contract.id