Client Management - How to use Import device Option from device Groups CSV

Version 30
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Client Management


    COMPONENT:

    BMC Client Management 12.9.00


    APPLIES TO:

    All BCM versions



    QUESTION:

    How to import devices using CSV file in BCM?

    How to Use Device Import in BMC Client Management?


    ANSWER:

    Step 1: Copy the the 'import_sample_inv.xls' file from following location on Master server and prepare your CSV file to import.
                C:\Program Files\BMC Software\Client Management\Master\data\Vision64Database\import

    How To sheet has the list of expected values against the respective fields that can be imported in BCM along with their description.
    Data sheet has the columns that need to be updated in order to import the devices in BCM.

       
    • Create a new Excel spreadsheet file and copy the columns from Data sheet and paste it in to newly created spreadsheet. So, we only have 1 sheet in the spreadsheet with the columns as heading.
       User-added image  
       
    • Remove the unwanted columns as per your requirement. In this example, we are going to import new devices along with DeviceType and DomainName fields. DeviceName is a mandatory field for the import.
       User-added image  
       
    • Save the file with CSV (Comma delimited *.csv) format.
       User-added image

    Step 2: Import the CSV file in to a Device Group
      
       
    • Login to BCM console and go to Device Groups node
    •  
    • Create a new device group and type the appropriate  name as per your requirement
       User-added image  
       
    • Right click on the newly created device group and click 'Import Devices'
       User-added image  
       
    • Browse to the location where you've saved the CSV file. Select it and click Open.
    •  
    • The source and destination columns will be mapped automatically. Click OK to proceed with Import.
       User-added image  
       
    • On the next screen, select 'Create not Existing Devices'. This will create new devices as per the list if it's already not in BCM.
    •  
    • Click OK
       User-added image  
       
    • The device group will show the imported devices as soon as the import is completed.
       User-added image
      

     


    Article Number:

    000230925


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles