CA Service Management

 View Only
Expand all | Collapse all

How to get the assignee group detail from Service Type of a CI

  • 1.  How to get the assignee group detail from Service Type of a CI

    Posted Sep 06, 2016 05:00 AM
      |   view attached

    Dear CA,

     

    Currently we are using CA Service Desk Manager 12.7. And we have few CIs in CA CMDB for which we will tag a service type under CMDB Attributes-> Service Tab. 

    This service type will be nothing but a MACRO which will be calling a event and that event will assign a assignee group for that CI.

    What I need is a query in which if I give a Name of a CI, it should a return a assignee group tagged to that CI.

     

    My Investigations till now:

    - select * from ca_owned_resource where resource_name = 'sqlapp'

    /* My CI is present in the above table*/

    -select * from evt where sym = 'assign group_it_mssql_apps_intl'

    /* Event and macro details are present in above table */

     

    I am not able to join the CI with the MACRO it is calling......I am not sure about the DB design

     

    It will great if somebody can help. Thanks in advance. Please let me know for any clarifications.



  • 2.  Re: How to get the assignee group detail from Service Type of a CI

    Posted Sep 06, 2016 11:38 AM

    When you have a CI that has been given a Service Type it means that when a ticket is opened with that CI as the (affected) Configuration Item, then that Service Type gets added to the ticket. It is the same as when you give a Priority a Service Type. When a ticket is opened with that Priority, then that Service Type gets added to the ticket.

     

    The Service Type does not act on the CI itself.