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.
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.