CA Service Desk Manager
what are the SQL database tables related to the Service Targets in CA Service Desk Manager?
The table that stores the information between request/change order and service targets?
have a look into:
usp_target_srvtypes maintain the relation between the service type and associated target.
usp_target_time is storing the result for each object(ticket). I think this is the one you are looking for
usp_target_time_tpl store the target template as the name say
Hope this help
Have you reviewed the Logical Data Model? It can be found in the Service Desk installation samples directory.
Take a look at the Service_Contract MDB table
This might help with the tables...
Service Type - CA Service Management - 14.1 - CA Technologies Documentation
Did the information provided assist you in locating the data you were looking for?
I couldn't able to find out the 'Service_Contract' table is mdb database. however, i got the information about sql tables that I'm looking for thanks!
Retrieving data ...