Why did my cdm MCS profile configuration change on a large number of servers?
MCS-based changes:
If the change was due to an MCS profile being pushed out/distributed, and you need to determine which machines/devices were affected as a result, see the query below.
Change the value of the b.profileName in the WHERE clause for the particular profile that you are interested in determining which machines it was pushed to and note that if the same profile was pushed to robots in different groups, or to a specific device, you may have to adjust the query further.
SELECT ccs.name, b.cs_id, b.status, b.profileid, b.ancestorprofile, a.id, a.timestamp, a.objectname, a.objectvalue, a.action
FROM SSRV2AuditTrail a
JOIN SSRV2Profile b
ON a.objectid = b.profileId
JOIN (SELECT objectid, max(id) AS id FROM SSRV2AuditTrail GROUP BY objectid) c
ON a.id = c.id AND a.objectid = c.objectid
JOIN CM_COMPUTER_SYSTEM ccs
ON b.cs_id = ccs.cs_id
WHERE b.profileName = 'Setup cdm'
ORDER BY name;
You can save the query results to a csv file in MS SQL Server Studio by selecting the rows and copying them into Excel or save results as a csv file. Note the 'name' e.g., hostname and 'action' e.g., DEPLOYED, field values.