This documentation supports the 11.1 version of BMC Discovery.

To view an earlier version of the product, select the version from the Product version menu.

Importing network device data

The CiscoWorks import tool described on this page (and its command line equivalent tw_imp_ciscoworks) is deprecated in the version 11 release of BMC Discovery. It will be removed in a future release.

The CiscoWorks import tool creates network device entries in the datastore, and it creates and updates Network Device nodes. Entries in the datastore for a network device are overwritten if a network device in the input data has the same name.

A limitation of the importer is that a network device already in the datastore, for which a matching name cannot be found in the input data, is not removed. Therefore, if a network device has been renamed since a previous import, it appears in the datastore as a second network device.

Use of imported data and direct discovery is not supported

Using the CiscoWorks import tool to import network devices, and scanning the same network devices, can potentially generate duplicate network devices. BMC recommends that you use either direct discovery or import, not both.

The following topics are covered in this section:

Importing data from CiscoWorks

The CiscoWorks importer loads the data file exported from CiscoWorks LMS using the Campus Manager User Tracking tool and loads any existing network device data from the BMC Discovery datastore. It then compares the sets of data. The supported versions are Campus Manager 3.x and 4.x (UT CLI 1.0, 1.1, and 1.1.1).

The network device name is used as the index. Therefore, if two network devices have the same name, they are treated as the same network device.

  • If a new network device is found in the exported file, it is added to the BMC Discovery datastore. The name of the network device is used as its primary key. See the following note regarding deletion of network devices.
  • The ports on each network device are updated and indexed by IP address (the primary key). Port attributes that are updated include speed, duplex, and IP address. New ports (identified by IP address) are added, and any ports removed from the CiscoWorks data are removed from the datastore.

Importing a CiscoWorks data file

  1. From the main menu, click the  Administration icon.

    The  Administration page  opens.

  2. In the  Discovery section, click Ciscoworks Import.
    The following table describes the options on the page:

    Field Name

    Details

    File To Upload

    Click Browse... to display a file browser window. Select the file to import, and click Open.

    File Type

    From the File Type list, select either XML or Delimited.
    If you select XML, the lists for File Delimiter and File Has Header Line are dimmed.

    File Delimiter

    (For a delimited file only) Select the delimiter type from the File Delimiter list (Comma, Tab, or Space).

    File Has Header Line

    From the File Has Header Line list, select Yes or No depending on whether the delimited file has a heading line.

    Remove existing Network Devices

    (Optional) To remove existing network devices from the BMC Discovery datastore that are not present in the file you are importing, select Yes or No from the Remove existing Network Devices list.

    Logging Level

    Select a logging level from the list: Debug, Info, Warning, Error, or Critical.

  3. To import the CiscoWorks data file, click Apply.

A command line utility is also available for importing CiscoWorks data. For more information, see tw_imp_ciscoworks.

Generating CiscoWorks data

To export data from CiscoWorks in a layout the importer can use, you must create a custom layout.

  1. From the CiscoWorks LMS Portal, select Reports.
  2. Select Custom Layouts, and then click Create.
  3. In the Add Layout dialog box, select End Host.
  4. From the Available Sources list, select the columns that you want displayed in the report, and click Add to add them to the Selected Sources list.
  5. Arrange the columns in the required order by using the up and down arrows.
    The import file must be in the following order, otherwise data is imported into the wrong attribute, and the import fails. (More or fewer columns also cause the import to fail).

    CM 3 to 4 layout

    CM 4.0.6 layout

    UserName
    MACAddress
    HostName
    IPAddress
    Subnet
    DeviceName
    Device
    Port
    PortName
    PortState
    VTPDomain
    VLAN
    VLANType
    LastSeen
    Notes
    PortDuplex
    PortSpeed
    VLANId

    User Name
    MAC Address
    Host Name
    IP Address
    Subnet
    Device Name
    Device
    Port
    Port Name
    Port State
    VTP Domain
    VLAN
    VLAN Type
    Last Seen
    Prefix
    Port Duplex
    Port Speed
    VLAN Id

    1. Specify the name of the layout as StandardTideway, and enter a description.
    2. To create the StandardTideway layout, click Add.

Full instructions are available on the Cisco Systems website.

The following methods of generating the CiscoWorks data are supported.

Generating CSV files

Generating CSV files on the CiscoWorks server:

C:\Program Files\CSCOpx\campus\bin\ut -cli -query all
   -layout StandardTideway -export c:\data.csv 
   -u user -p password

This command produces a Java stack trace. This is a known issue and can be ignored.

The file that is produced can be imported by running the following command on the BMC Discovery appliance:

$TIDEWAY/bin/tw_imp_ciscoworks --delimiter=',' 
   --username name --password password 
   --file ~/tmp/data.csv

Generating XML import files

Generating XML files on the CiscoWorks server:

C:\Program Files\CSCOpx\campus\bin\cmexport ut -u userid 
   -p password -host -layout StandardTideway

The file is written into the following directory:
C:\PROGRAM FILES\CSCOpx\files\cmexport\ut

The file that is produced can be imported with the following command on the BMC Discovery appliance:

$TIDEWAY/bin/tw_imp_ciscoworks --xml --username name 
   --password password --file ~/tmp/2006516154526ut.xml

The following attributes are imported into the data store, where they exist in the input file:

Attribute

Description

Example

Notes

MacAddress

MAC address of the port on the connected device (not the MAC address of the network device)

01-23-45-67-89-ab

Must be a valid MAC address

IPAddress

IP address of the port on the connected device (not the IP address of the network device)

192.168.0.1

Must be a valid IP address

DeviceName

Name of the network device

switch1.tideway.com

Device

IP address of the network device

192.168.0.1

Must be a valid IP address

Port

Port name

3/19

PortDuplex

Duplex setting of the port

full-duplex

PortSpeed

Speed setting of the port

100M

Must be a power of 10 with K/M/G suffix

PortNegotiation

Negotiation setting of the port

AUTO

Must be AUTO or FORCED

Related topics

Was this page helpful? Yes No Submitting... Thank you

Comments