How do we find which USM groups have MCS templates applied

book

Article ID: 15861

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction



How do we find which USM groups have MCS templates applied

Environment

UIM 8.47UIMm 8.5.x

Resolution

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