Environment
Situation
Resolution
In the XML template there is the following section that lists the fields and what fields are to be imported:
</ITEM_TYPE>
<ITEM_PROPERTY FIELD="field1" VALUE_PREFIX="" VALUE="cpu.PROPLINAME" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field2" VALUE_PREFIX="" VALUE="system.PROPLIPCMEMORY" VALUE_SUFFIX="MB" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field3" VALUE_PREFIX="" VALUE="net.PROPLIMACADDRESS" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field4" VALUE_PREFIX="" VALUE="net.PROPLIIPADDRESS" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field5" VALUE_PREFIX="" VALUE="pcinfo.PROPLIPCNAME" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field10" VALUE_PREFIX="" VALUE="system.PROPLISERIAL" VALUE_SUFFIX="" TYPE="LOOKUP" />
</ITEM>
Should the users want to import the network name of the machine, which is currently 'field5' in the list above, as the item number, this line needs to be copied and modified from 'field5' to 'itemNumber'. This would then be inserted as the first field in the list. As such, this section would then look like this:
</ITEM_TYPE>
<ITEM_PROPERTY FIELD="itemNumber" VALUE_PREFIX="" VALUE="pcinfo.PROPLIPCNAME" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field1" VALUE_PREFIX="" VALUE="cpu.PROPLINAME" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field2" VALUE_PREFIX="" VALUE="system.PROPLIPCMEMORY" VALUE_SUFFIX="MB" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field3" VALUE_PREFIX="" VALUE="net.PROPLIMACADDRESS" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field4" VALUE_PREFIX="" VALUE="net.PROPLIIPADDRESS" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field5" VALUE_PREFIX="" VALUE="pcinfo.PROPLIPCNAME" VALUE_SUFFIX="" TYPE="LOOKUP" />
<ITEM_PROPERTY FIELD="field10" VALUE_PREFIX="" VALUE="system.PROPLISERIAL" VALUE_SUFFIX="" TYPE="LOOKUP" />
</ITEM>
If other fields in the asset database were required, the itemNumber line could be modified accordingly.
Additional Information
AMIE Mappings for Servers
The Asset Management Import Engine (AMIE) integrates with the following Inventory Management Products:
ZENworks Asset Management 6.5+
ZENworks Desktop Management 6.5
ZENworks Configuration Management 11.1
ZENworks Configuration Management (Hardware)11.1
LANDesk 8.5
LANrev 5.1
LiveTime Discovery 2005, 2007
LOGINventory 4.3
HP Universal CMDB 8.0
Microsoft SMS Version 2003 SP1
Microsoft SCCM 2007
Spiceworks 4.0
Manage Engine Desktop Central 7.0
Express Software Manager 9.0, 9.5
Express Software Manager 9.5
Centennial Discovery 2005, 9.
The default AMIE mappings for each server type are as follows:
Zenwork Configuration Management 11.1
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
"NC_CPU.speed" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"NC_Workstation.totalMemory" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MB" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"NC_Workstation.lanaddress" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
" field4" |
VALUE |
" NC_Workstation.ipaddress" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
" field5" |
VALUE |
" NC_Workstation.machinename" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD7 = "OS Version" |
|
FIELD |
"field7" |
VALUE |
" NC_Workstation.osmodel" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"NC_Workstation.serialnumber" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
FIELD20 = "Platform String" |
|
FIELD |
"field10" |
VALUE |
"NC_Workstation.osproduct" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"NC_Product.model" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
ZENworks Asset Management 6.5+ and ZENworks Configuration Management 10.0
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
"NC_CPU.speed" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"NC_Workstation.totalMemory" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MB" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"NC_Workstation.lanaddress" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
" field4" |
VALUE |
" NC_Workstation.ipaddress" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
" field5" |
VALUE |
" NC_Workstation.machinename" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD6 = "Platform" |
|
FIELD |
"field6" |
VALUE |
"Windows" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"NC_Workstation.serialNumber" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"NC_Product.model" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
ZENworks Desktop Management 6.5
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD "field1" |
|
VALUE |
"T$processor.currentClockSpeed" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"T$component.totalVisibleMemorySize" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MB" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"T$networkAdapter.permanentAddress" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
"T$ipprotocolEndpoint.address" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
"T$managedSystemElement.name" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"T$physicalElement.serialNumber" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
|
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"T$product.version" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
LANDesk 8.5
ITEM CATEGORY |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
"Processor.mhzSpeed" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD2 = "RAM" -- |
|
FIELD |
"field2" |
VALUE |
"Memory.bytesTotal" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"B" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"NetworkSoftware.nicAddress" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
"TCP.address" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
"Computer.deviceName" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD6 = "Platform" |
|
FIELD |
"field6" |
VALUE |
"Windows" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"Computer.compSystem.serialNum" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
ITEM CATEGORY |
Software |
FIELD1 = "Path" |
|
FIELD |
"field1" |
VALUE |
"software.path" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"FileInfo.version" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
LANrev 5.1
ITEM CATEGORY |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
“hardware_info.CPUSpeed“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"Mhz" |
FIELD2 = "RAM" -- |
|
FIELD |
"field2" |
VALUE |
“hardware_info.PhysicalMemorySize†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"B" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
“hardware_info.PrimaryMACAddress“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
“network_adapter_info.IPAddress“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
“network_adapter_info.WinHost“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
“hardware_info.MachineSerialno†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
LOGINventory 4.3+
ITEM CATEGORY |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
"LI_CUP.LI_NAME" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD2 = "RAM" -- |
|
FIELD |
"field2" |
VALUE |
"LI_SYSTEM.LI_PCMEMORY" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MB" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"LI_NET.LI_MACADDRESS" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
"LI_NET.LI_IPADDRESS" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
"LI_PCINFO.LI_PCNAME" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"LI_SYSTEM.LI_SERIAL" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"LI_SOFTWARE.LI_VERSION" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
HP Universal CMDB 8.0
Item Category |
Hardware |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"CDM_NT_1.A_NT_PHYSICAL_MEMORY" |
VALUE_PREFIX |
"B" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
"CDM_HOST_1.A_HOST_HOSTNAME" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
FIELD1 = "Path" |
|
FIELD |
"field1" |
VALUE |
"CDM_APPLICATION_1.A_APPLICATION_PATH" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"CDM_APPLICATION_1.A_APPLICATION_VERSION_NUMBER" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Microsoft SMS 2003 SP1 and Microsoft SCCM 2007
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
"Processor_DATA.currentClockSpeed0" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"PC_Memory_DATA.totalPhysicalMemory0" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"B" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"Network_DATA.macaddress0" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
"Network_DATA.ipaddress0" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
"Computer_System_DATA.propName0" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD6 = "Platform" |
|
FIELD |
"field6" |
VALUE |
"Windows" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
ITEM CATEGORY |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"SoftwareProductMap.productVersion" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Manage Engine Desktop Central 7.0
Item Category |
Hardware |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"invcomputer.TOTAL_RAM_MEMORY_MB" |
VALUE_PREFIX |
"MB" |
VALUE_SUFFIX |
"" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"resourcemacip.MAC_ADDRESS" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
"resourcemacip.IP_ADDRESS" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"invcomputeros.SERIAL_NUMBER" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
|
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"invsw.SOFTWARE_VERSION" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Spiceworks 4.0
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
“devices.processor_type“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
“devices.memory†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"B" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
“devices.mac_address†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
“devices.ip_address†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
“devices.name†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
“devices.serial_number†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Printers & Scanners |
FIELD5 = "IP Address" |
|
FIELD |
"field5" |
VALUE |
“devices.ip_address“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD6 = "Serial Number" |
|
FIELD |
"field6" |
VALUE |
“devices.serial_number†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Network Infrastructure |
FIELD5 = "IP Address" |
|
FIELD |
"field5" |
VALUE |
“devices.ip_address“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD6 = "Serial Number" |
|
FIELD |
"field6" |
VALUE |
“devices.serial_number†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
“software_installations.version“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Express Software Manager 9.0 & 9.5
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
“machinehardware.c_processor†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"Mhz" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
“machinehardware.c_ram“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"B" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
“machine.nicaddress“ |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
“machine.ipaddress†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
“machine.name†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
“machinehardware.machineserialnumber†|
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Centennial Version 2005 & 9
Item Category |
Hardware |
FIELD1 = "CPU" |
|
FIELD |
"field1" |
VALUE |
"Hardware.size" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"MHz" |
FIELD2 = "RAM" |
|
FIELD |
"field2" |
VALUE |
"Hardware.size" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"KB" |
FIELD3 = "MAC Address" |
|
FIELD |
"field3" |
VALUE |
"Client.macAddr1" |
VALUE_PREFIX "" |
|
VALUE_SUFFIX |
"" |
FIELD4 = "Network Address" |
|
FIELD |
"field4" |
VALUE |
"Client.ipaddr1" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD5 = "Network Name" |
|
FIELD |
"field5" |
VALUE |
"Client.sysMachine" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD6 = "Platform" |
|
FIELD |
"field6" |
VALUE |
"Windows" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
FIELD10 = "Serial Number" |
|
FIELD |
"field10" |
VALUE |
"Hardware.driver" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Item Category |
Software |
FIELD3 = "Version" |
|
FIELD |
"field3" |
VALUE |
"Products.versionName" |
VALUE_PREFIX |
"" |
VALUE_SUFFIX |
"" |
Formerly known as 1001027