Novell Service Desk Importing item numbers using AMIE imports

  • 7012305
  • 10-Aug-2010
  • 29-May-2013

Environment

Novell Service Desk

Situation

Novell Service Desk has the ability to import item numbers from AMIE imports. This document shows an example of how this possible.

Resolution

This has been done with the LOGINventory template but the same basis can be applied for any of the templates.

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