Add Nodes CSV File Requirements

The nodes CSV file defines the nodes, interfaces, and their details required to add them to CC-SG.

Node names must be unique. If you enter duplicate node names, CC-SG adds a number in parentheses to the name to make it unique, and then adds the node. If you are also assigning categories and elements to nodes in the CSV file, and you have duplicate node names, categories and elements may be assigned to the wrong nodes. To prevent this, give each node a unique name. Or, import nodes first, check their names in CC-SG, and then import a separate file to assign categories and elements to the correct node names.
To add out-of band interfaces, the associated port must not be configured in CC-SG.
You cannot import virtual infrastructure nodes and interfaces. Use the options in Nodes > Virtualization.
The first interface in the CSV file after the ADD NODE command is assigned as the node's default interface.
Export a file from CC-SG to view the Comments, which include all tags and parameters needed to create a valid CSV file. See Export Nodes.
Follow the additional requirements for all CSV files. See Common CSV File Requirements.
Some interfaces support IPv6. See Interfaces for In-Band Connections - RDP, VNC, SSH, RSA KVM, iLO Processor KVM, DRAC KVM, TELNET and Web Browser Interface. For more details, see Microsoft RDP Connection Details, Java RDP Connection Details, VNC Connection Details.

To add a node to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Description	Optional.

To add an out-of-band KVM interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-OOBKVM-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Enter the same value as entered for Raritan Port Name.
4	Raritan Device Name	Required field. The device must already be added to CC-SG.
5	Port Number	Required field.
6	Blade Slot/KVM Switch Port	If the node is associated with a blade, enter the slot number. If the node is associated with a tiered generic analog KVM Switch, enter the port number.
7	Raritan Port Name	If left blank, CC-SG will use the existing port name from the device. If you enter a new name, the name will be copied to the device, with the exception of SX devices.
8	Interface Name	Enter the same value as entered for Raritan Port Name.
9	Description	Optional.

To add an out-of-band serial interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-OOBSERIAL-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Enter the same value as entered for Raritan Port Name.
4	Raritan Device Name	Required field.
5	Port Number	Required field.
6	Raritan Port Name	If left blank, CC-SG will use the existing port name from the device. If you enter a new name, the name will be copied to the device, with the exception of SX devices.
7	Interface Name	Enter the same value as entered for Raritan Port Name.
8	Baud Rate	Valid for SX ports only.
9	Parity	Valid for SX ports only.
10	Flow Control	Valid for SX ports only.
11	Description	Optional.

To add an RDP interface to the CSV file:

Column number in CSV file	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-RDP-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	IP Address or Hostname	Required field.
6	TCP Port	Default is 3389.
7	Service Account Name	Optional.
8	Username	Optional.
9	Password	Optional.
10	User Type	`REMOTE` or `CONSOLE` Default is `REMOTE`.
11	Keyboard Type	`US, UK, Arabic, Danish, German, Spanish, Finnish, French, Belgian, Croatian, Italian, Japanese, Lithuanian, Latvian, Macedonian, Norwegian, Polish, Portuguese, Brazilian, Russian, Slovenian, Swedish,` or `Turkish` Default is `US`.
12	Description	Optional.
13	RDP Type	`Java` or `Microsoft` Default is `Java.`

To add an SSH or TELNET interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-SSH-INTERFACE` for SSH interfaces `NODE-TELNET-INTERFACE` for TELNET interfaces	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	IP Address or Hostname	Required field.
6	TCP Port	Default is 22 for SSH. Default is 23 for TELNET.
7	Service Account Name	Optional. Leave blank if specifying username and password.
8	Username	Optional. Leave blank if specifying service account.
9	Password	Optional.
10	Description	Optional.

To add a VNC interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-VNC-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	IP Address or Hostname	Required field.
6	TCP Port	Default is 5900.
7	Service Account Name	Optional. Leave blank if specifying password.
8	Password	Optional. Leave blank if specifying service account.
9	Description	Optional.

To add a DRAC KVM, DRAC Power, ILO KVM, ILO Power, Integrity ILO2 Power, or RSA Power interface to the CSV file:

When importing DRAC, ILO and RSA interfaces, you must specify both the KVM interface and the Power interface, or the import will fail.

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-DRAC-KVM-INTERFACE` for DRAC KVM interfaces `NODE-DRAC-POWER-INTERFACE` for DRAC Power interfaces `NODE-ILO-KVM-INTERFACE` for iLO KVM interfaces `NODE-ILO-POWER-INTERFACE` for iLO Power interfaces `NODE-INT-ILO2-POWER-INTERFACE` for Integrity ILO2 Power interfaces `NODE-RSA-POWER-INTERFACE` for RSA Power interfaces	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	IP Address or Hostname	Required field.
6	Service Account Name	You must enter either a service account or a username and password. Leave blank if specifying username and password.
7	Username	You must enter either a service account or a username and password. Leave blank if specifying service account.
8	Password	You must enter either a service account or a username and password. Leave blank if specifying service account.
9	Description	Optional.
10*	TCP Port	*For `NODE-DRAC-POWER-INTERFACE` only, specify a TCP port. Default is 22.

To add a UCS KVM interface to the CSV file:

Specify a username and password for an account that has access to both the chassis and the blade.

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-UCS-KVM-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	UCS Chassis IP address or hostname	Required field.
6	TCP Port	Default is 443.
7	Blade IP address or hostname
8	Service Account Name	Optional. Leave blank if specifying username and password.
9	Username	Optional. Leave blank if specifying service account.
10	Password	Optional. Leave blank if specifying service account.
11	Description	Optional.

To add an RSA KVM interface to the CSV file:

When importing DRAC, ILO and RSA interfaces, you must specify both the KVM interface and the Power interface, or the import will fail.

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-RSA-KVM-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	IP Address or Hostname	Required field.
6	TCP Port	Default is 2000
7	Service Account Name	Leave blank if specifying username and password.
8	Username	Leave blank if specifying service account.
9	Password	Leave blank if specifying service account.
10	Description	Optional.

To add an IPMI power control interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-IPMI-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	IP Address or Hostname	Required field.
6	UDP Port	Default is 623
7	Authentication	`MD5`, `None`, `OEM`, or `PASSWORD` Default is `PASSWORD.`
8	Interval	Enter the check interval in seconds. Default is 550.
9	Service Account Name	Leave blank if specifying username and password.
10	Username	Leave blank if specifying service account.
11	Password	Leave blank if specifying service account.
12	Description	Optional.

To add a managed powerstrip interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-POWER-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	Powerstrip Name	Required field.
6	Outlet	Required field.
7	Managing Device	The name of the device that the power strip is connected to. Required field for all power strips except Dominion PX.
8	Managing Port	The name of the port on the device that the power strip is connected to. Required field for all power strips except Dominion PX.
9	Description	Optional.

To add a Web Browser interface to the CSV file:

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-WEB-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	URL	Required field.
6	TCP Port	Default is 80.
7	Service Account Name	Optional. Leave blank if specifying username and password.
8	Username	Optional. Leave blank if specifying service account. Apostrophe character ' is not supported.
9	Password	Optional. Leave blank if specifying service account. Apostrophe character ' is not supported.
10	Username Field	Optional. See Tips for Adding a Web Browser Interface
11	Password Field	Optional. See Tips for Adding a Web Browser Interface
12	Description	Optional.
13	Extra Parameter Field Name	Optional. See Web Browser Interface.
14	Extra Parameter Field Value	Optional. See Web Browser Interface.
		Use remaining columns in pairs if you need to add more parameter field names and values.

To add a Power IQ Proxy power control interface to the CSV file:

See Power Control of Power IQ IT Devices for details about configuring this interface type.

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command ADD.
2	`NODE-POWER-PIQ-INTERFACE`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Interface Name	Required field.
5	External Key	If the IT device has already been added to Power IQ, find the external key on the IT device's page in the Data Center tab, and enter the text in this field. If the IT device has not been added to Power IQ yet, enter a text value, but make sure to use the same value when adding the IT device to Power IQ. You can quickly make a file of all node and interface information by exporting. See Export Nodes.
6	Managing Power IQ Name	Enter the name of the Power IQ that manages the IT device. The name must match the value in the Power IQ Device Name field on the Access > Power IQ Services > "Power IQ Device Name" Configuration dialog. See Configuring Power IQ Services.
7	Description	Optional.

To assign categories and elements to a node to the CSV file:

Categories and elements must already be created in CC-SG.

You can assign multiple elements of the same category to a node in the CSV file.

Only the ADD command is supported for categories and elements. You cannot update or delete categories and elements using CSV import.

Column number	Tag or value	Details
1	`ADD`	The first column for all tags is the command.
2	`NODE-CATEGORYELEMENT`	Enter the tag as shown. Tags are not case sensitive.
3	Node Name	Required field.
4	Category Name	Required field.
5	Element Name	Required field.