CA Service Management

  • Private Community

  • 1.  Service target's object and sql table information

    Posted Feb 14, 2017 11:11 AM

    Hi Community,

    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?

     

    Thank you,

    Regards,

    Venkat



  • 2.  Re: Service target's object and sql table information

    Posted Feb 14, 2017 11:20 AM

    Hi,

     

    Have you reviewed the Logical Data Model?  It can be found in the Service Desk installation samples directory.

    nx_root/samples/data/



  • 3.  Re: Service target's object and sql table information

    Broadcom Employee
    Posted Feb 14, 2017 11:20 AM

    Take a look at the Service_Contract MDB table



  • 4.  Re: Service target's object and sql table information
    Best Answer

    Posted Feb 14, 2017 12:39 PM

    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

    /J



  • 5.  Re: Service target's object and sql table information

    Posted Feb 16, 2017 08:53 AM

    This might help with the tables...

    Service Type - CA Service Management - 14.1 - CA Technologies Documentation 

     

    Jon I.



  • 6.  Re: Service target's object and sql table information

    Broadcom Employee
    Posted Feb 16, 2017 01:04 PM

    Did the information provided assist you in locating the data you were looking for?



  • 7.  Re: Service target's object and sql table information

    Posted Feb 17, 2017 04:38 AM

    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!

     

    Regards,

    Venkat