How to create a Data Connector import rule that can delete resource records

book

Article ID: 180766

calendar_today

Updated On:

Products

Symantec Products

Issue/Introduction

 

Resolution

A Data Connector import rule can be used to delete resource records, such as if many unwanted computers or users are accidentally imported or migrated into the database. The following instructions describe how this can be done.
 

  1. Create a new data file (.xls or .csv).
     
    a. Populate the data file with the resource records to delete. Only basic columns need be specified, such as the resource Name. For example, the following shows a basic .csv file that will delete two computer records named "Computer1" and "Computer2", with the Name column being the only data class being referenced. Then, save the file.

    Name
    Computer1
    Computer2
     
  2. Create a new Data Connector Data Source.

    a. On the Symantec Management Platform server, in a Symantec Management Platform Console, click on the Settings button > All Settings.
    b. Click to expand Notification Server > Connector > Data Sources.
    c. Right click on the Data Sources folder >New > Data Source.
    d. Configure the data source to point to the data file created in Step 1 and also as the other options show in the example in Figure 1, below:

    Figure 1: Example Data Source



    e. Click on the "Save changes" button.
     
  3. Create a new Data Connector Import Rule.

    a. In the Symantec Management Platform Console, click on the Settings button > All Settings.
    b. Click to expand Notification Server > Connector > Import/Export Rules.
    c. Right click on the Import/Export Rules folder > New > Resource Import Export Rule.
    d. Configure the import rule to point to the data source created in Step 2 and also as the other options show in the example in Figure 2, below:



    e. Click on the "Save changes" button.
     
  4. Click on the "Run now" button. Nothing will technically be done to the resource records as they already exist in the database, but it import rule records which records were "touched" by the process.
  5. Edit the data file and remove all resource records except the column names and then save the file. Only one row will then exist, which is the column names.
  6. Run the import rule again. The removed resources from the data file are compared to what was "touched" in Step 4 and then deleted from the database.
     

Related Article

Can bulk resource records be deleted from the Symantec Management Platform?
http://www.symantec.com/business/support/index?page=content&id=HOWTO60959

Symantec Management Platform 7.1 SP1 User Guide (which discusses how to use Data Connector)
http://www.symantec.com/business/support/index?page=content&id=DOC3940

Attachments