How to know which MCS profiles are applied on devices

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

How to know which MCS profiles are applied on devices and when they were updated?

Environment

Release: UIM 20.x

Resolution

Run the following query on UIM DB or From OC>SLM>SQL Query Editor

select ss.profileId,ss.profileName,ss.created,ss.updated,ss.template,ss.cs_id,ss.status,cm.name,cm.os_type,cm.mac
from SSRV2Profile ss left join CM_COMPUTER_SYSTEM cm on ss.cs_id = cm.cs_id where ss.cs_id is not null order by name asc

The output would be like below