How do we find which USM groups have MCS templates applied

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

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