Tech Tip: CSV override server configurations

Document created by petch08 Employee on Sep 28, 2015Last modified by petch08 Employee on Sep 28, 2015
Version 2Show Document
  • View in full screen mode

ISSUE: The auto mapping for configurations is incorrect or the server configuration is not fully defined in the server configuration spreadsheet.


Fix: Using the CSV file to override the configurations for the server. (See sample file attached). Using the CSV file data adapter will allow you to update many servers at once instead of updating each one through the server configuration spreadsheet from CCC.

Steps to match the server to the correct CML entry:


  1. Necessary fields:
    1. Server Name
    2. Time Stamp – Format: 2015-09-01 00:00:00
    3. Total Memory - (KB)


       2. Optional but important fields:

    1. cml_name – The exact name of the computer model that is present in the CCC computer model library (ie HP ProLiant DL380p Gen8 2000MHz Xeon E5-2620)
    2. Number of CPU Cores – The total number of cores on the system.
    3. Number of CPUs – The total number of threads on the system.
    4. num processor chip – The total number of physical chips in the system.
    5. cores per processor chip – The number of cores per physical chip.
    6. threads per processor core – The number of threads per core.

     3. To confirm the fields are correct:

    1. Number of CPU cores = (num processor chip) * (cores per processor chip)
    2. Number of CPUs = (num processor chip) * (cores per processor chip) * (threads per processor core)

     4. Save the file as a .csv

    1. Note – If using Excel to edit the file, open the saved CSV file with a text editor (Notepad ++) to confirm the time stamp format is correct.

     5. Stage and migrate the file into Data Manager with the CSV data adapter

     6.After staging and migrating the CSV, stage and migrate the DM Groups data adapter.


     7.Check CCC to run the Server and Group Configurations update.