How to know which MCS profiles are applied on devices

Document ID : KB000012866
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Can we know which MCS profiles are applied on devices and when they were updated?

Answer:

Run the following query on UIM DB

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

Capture_MCS_query.JPG