DX Operational Intelligence

Tech Tip: CSV override server configurations 

09-28-2015 04:55 PM

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.

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
zip file
GenericConfiguration.csv.zip   1K   1 version
Uploaded - 05-29-2019

Tags and Keywords

Comments

11-18-2015 05:33 PM

In fact, I do this so often, I have recorded it as a macro in Personal.xlsm and assigned it to Ctrl-d - I couldn't begin to count the cumulative time this must have saved me over the years...

 

Macro snippet:

 

Sub DateFormat_DM()

'

' DateFormat_DM Macro

' To match what's needed for DM

'

' Keyboard Shortcut: Ctrl+d

'

    Selection.NumberFormat = "yyyy-mm-dd hh:mm:ss"

End Sub

 

  • Assign this to whichever short-cut you like (for me Ctrl-d - 'd for date' helps me remember)
  • Select whatever cells you need, I typically apply to the entire column
  • Ctrl-d (or your short-cut of choice)

 

Simple, but effective...

09-28-2015 05:03 PM

Thanks Charles!

In Excel you can select the date column, right click, Format cells... and then pick Custom from the Number tab and put in yyyy-mm-dd hh:mm:ss in the format.

Excel will always try to be "helpful" and format dates to your workstation's Region and Language date format settings.

Related Entries and Links

No Related Resource entered.