How to know which MCS profiles are applied on devices and when they were updated?
Release: UIM 20.x
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