Managing Servers › Manage Servers › Import Server Definitions from a CSV File › Create a CSV File

Create a CSV File

To get started quickly, add a comma-separated list of server names and IPv4 addresses to a CSV file.

If you do not include both a server name and IP address, you can edit the list of definitions before you complete the import. For example, you can create a CSV file with IP addresses only, and then specify the corresponding server names before you complete the import. The management console does not query DNS to resolve host names for imported servers.

Follow the steps below to create a CSV file that specifies the servers that you want the management console to monitor. When creating a CSV file, separate each field with a comma and enclose:

• Embedded commas or double quotes inside double quotes.
• Strings that contain one or more spaces in double quotes; for example: "Houston Office".

An example of CSV-formatted server definitions appears below. The Austin DNS Server entry specifies that ref-sa-coll, which is a CA Standard Monitor, sees the server traffic for 192.168.100.2 on its Packets monitor feed and, by default, should use the SNMP profile named "netqos" to poll the server:

"Austin DNS Server", 192.168.100.2, "ref-sa-coll", "Packets", "netqos"

Follow these steps:

1. Create a text file with a .CSV extension, for example, austin_servers.csv.
2. Specify each comma-delimited server definition on a separate line.
3. Use the following format for each entry: Server_Name,Server_IP,Monitoring_Device,Monitor_Feed,SNMP_Profile

   Server_Name

   Defines the name of the server, up to 50 characters, as you want it to appear in the management console.

   Note that when you import a list of servers, the management console does not automatically resolve the DNS host name.

   Server_IP

   Defines the IPv4 address of the server in four-part, dotted-decimal notation. If you do not specify the address format correctly, the import uses the IP address as the server name.

   Monitoring_Device

   (Optional) Defines the monitoring device that sees the server’s traffic. If you specify the monitoring device, you must also specify a monitor feed on the device. After you import the server, if necessary, the management console automatically reassigns the monitoring device and monitor feed. If you do not specify a monitor feed, the management console automatically assigns the best monitor feed.

   Monitor_Feed

   (Optional) Defines the monitor feed on the monitoring device that sees the server’s traffic. If you specify the monitoring device, you must also specify a monitor feed on the device, such as Packets for the Packets monitor feed. After you import the server, if necessary, the management console automatically reassigns the monitoring device and feed.

   If you do not specify a monitor feed, the management console automatically assigns the best monitor feed.

   To browse the list of available monitor feed names on a monitoring device, edit the CA Standard Monitor or CA Multi-Port Monitor.

   SNMP_Profile

   (Optional). Defines the SNMP profile name that you want the management console to use when polling the server, for example, as part of a Performance via SNMP investigation. Specify a null value ("") if you want the management console to discover a valid SNMP profile.

4. Save the file and import it into the management console.

More information:

How Monitoring Devices Work

How SNMP Profile Discovery Works