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 the Eg: "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.