AnsweredAssumed Answered

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

Question asked by Nsmadmin on Sep 6, 2016
Latest reply on Sep 6, 2016 by Lindsay_Estabrooks

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.