Why did my cdm configuration automatically change?
search cancel

Why did my cdm configuration automatically change?

book

Article ID: 131048

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction



Why did my cdm MCS profile configuration change on a large number of servers?

Environment

- UIM 8.5.1 or higher

Resolution

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;

<Please see attached file for image>

MCS profile query output for deployed profiles


You can save the 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.

Additional Information

For help on tracking Non-MCS configuration changes or restoring the configurations via global changes, please refer to the knowledge base article: 

How do we make global changes to cdm probe configurations
https://comm.support.ca.com/kb/how-do-we-make-global-changes-to-cdm-probe-configurations-on-multiple-systems/kb000034252

Attachments

1558687341512000131048_sktwi1f5rjvs16f90.png get_app