Import/Export Rules pulls the partial data, Status Window remains blank.

Products

• CMDB Solution

Issue/Introduction

Import/Export Rules pulls the partial data, Status Window remains blank, even when explicitly Associating the status of Asset.

Status Column appears to be blank when data is been exported from the Import Export Rule.

Cause

.

Resolution

 

Go To:

Settings --> All Settings --> Notification Server --> Connector --> CMDB Rule --> New --> CMDB Rule.

Re-Name the CMDB Rule --> Your Export Rule to identify the  Eg: "Export Computer Status"

In the CMDB Rule "Export Computer Status"

 Step 1:

Resource Type:  Select --> Computer

Target Using: Select --> All 'Computer Resources'

 Step 2: Do not Modify This.

Step 3:

Select Asset Status --> Select Lookup Key --> <Value> --Set This to "Active"

Save the Changes made and Execute the rule by pressing the button "Run Now".

Applies To

7.1 SP2. 8280 AMS, Data Connector, CMDB Rules.
Import Rule Not able to fetch the Active resources even the resources appear Active in the console.
Created the Data Source:
Eg:  New OLEDB Data Source
The Details here required
Path of the Excel File
Excel File along with the worksheet Name.
 

Then  created a  Import/Export Rules:
Eg:  New Resources Import Export Rule.
Associated the Dataclass:
Column Mapping is done as follows:
Resource name: RIS TAG
Resource type: Equipment Type
Resource GUID:  Resource GUID

Rest kept same in Data Class except;

Removal of Cost Items: Status --- Null

Association Mappings is done in  to
Location Asset : Location
Asset's Status Asset : Status
Asset Department Owners Asset : Department
Cost Center Asset : BU

Then Executed the New Resources Import Export Rule by pressing the

Problem occurred is that Status Column appears to be blank when data is been exported excel file, rest all data appeared successfully.