How do we find which USM groups have MCS templates applied
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