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.
Settings --> All Settings --> Notification Server --> Connector --> CMDB Rule --> New --> CMDB Rule.
Re-Name the CMDB Rule --> Your Export Rule to identify theEg: "Export Computer Status"
In the CMDB Rule "Export Computer Status"
Resource Type:Select --> Computer
Target Using: Select --> All 'Computer Resources'
Step 2: Do not Modify This.
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".
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.
Imported Document ID: TECH192805
Subscribing will provide email updates when this Article is updated. Login is required.