How do we find which USM groups have MCS templates applied

Document ID : KB000015861
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How do we find which USM groups have MCS templates applied

Environment:
UIM 8.47UIMm 8.5.x
Answer:

Can run the below database query to find this information

select gp.profileName, t.probe, t.templateName, g.name as group_name from ssrv2profile gp

join ssrv2template t on t.templateid = gp.template

join ssrv2devicegroup dg on dg.id = gp.group_id

join cm_group g on g.grp_id = dg.cm_group_id

where gp.group_id is not null