IBM Endpoint Manager 9.0 db information to schema information
The following table lists the mapping expressions for database information to schema information, as defined in the integration adapter for Endpoint Manager 9.0.
Note: The IBM® Endpoint Manager adapter
does not process computers that have a Device Type in IBM Endpoint Manager of
"Plugin". Computers with this type are not loaded into the data source
or mapped into Deployed Assets.
Note: Properties that come from
Action Site are automatically activated.
| Database information | Schema information | |||
|---|---|---|---|---|
| Site | Analysis | Property Name | Integration Composer Class | Integration Composer Field |
| Action Site | datasource_name | Computer | Datasource name | |
| Action Site | Device Type | Computer | Computer type | |
| Action Site | dns_name | Computer | Dns name | |
| Action Site | Free Space on System Drive | Computer | Free space on system drive | |
| Action Site | id This id represents the IBM Endpoint Manager Computer id. |
Computer | Id | |
| Action Site | last_seen | Computer | Last seen | |
| Action Site | name | Computer | Name | |
| Action Site | RAM | Computer | Ram | |
| Action Site | Total Space on System Drive | Computer | Total space on system drive | |
| Action Site | User Name | Computer | User name | |
| Inventory and License | Operating System Information (Windows) | Full Operating System Name and Service Pack Level - Windows | Operating System | Os name |
| Inventory and License | Operating System Information (Windows) | OS Version Number - Windows | Operating System | Os version |
| Inventory and License | Operating System Information (Windows) | OS Type - Windows | Operating System | Os type |
| Inventory and License | Operating System Information (Windows) | OS Product ID - Windows | Operating System | Product id |
| Inventory and License | Operating System Information (Windows) | OS Product Key - Windows | Operating System | Product key |
| Inventory and License | Operating System Information (Windows) | OS Installation Date - Windows | Operating System | Installation date |
| Inventory and License | Operating System Information (Windows) | Uptime - Windows | Operating System | Uptime |
| Inventory and License | Operating System Information (Windows) | OS Language - Windows | Operating System | Os language |
| Inventory and License | Operating System Information (Windows) | System Language - Windows | Operating System | System language |
| Inventory and License | Operating System Information (Windows) | User Language - Windows | Operating System | User language |
| Inventory and License | Random Access Memory (RAM) Properties (Windows) | Current Size of RAM | Computer | Ram |
| Inventory and License | Random Access Memory (RAM) Properties (Windows) | Maximum RAM Installable | Computer | Maximum ram |
| Inventory and License | Random Access Memory (RAM) Properties (Windows) | Number of Used RAM Slots / Total Number of RAM Slots | ||
| Inventory and License | Random Access Memory (RAM) Properties (Windows) | Number of Free RAM Slots | ||
| Inventory and License | Motherboard Properties (Windows) | OnBoard Devices | ||
| Inventory and License | Motherboard Properties (Windows) | System Slots in Use | Computer | System slots in use |
| Inventory and License | Motherboard Properties (Windows) | System Slots Available | Computer | System slots available |
| Inventory and License | USB Devices Detection (Windows) | Connected USB Devices - Windows | ||
| Inventory and License | Memory and Partition Usage (UNIX) | RAM - Unix | Computer | Ram |
| Inventory and License | Memory and Partition Usage (UNIX) | Free RAM - Unix | ||
| Inventory and License | Memory and Partition Usage (UNIX) | Used RAM - Unix | ||
| Inventory and License | Memory and Partition Usage (UNIX) | Total Space of Partitions - Unix | Computer | Total space of partitions |
| Inventory and License | Memory and Partition Usage (UNIX) | Free Space of Partitions - Unix | Computer | Free space of partitions |
| Inventory and License | Memory and Partition Usage (UNIX) | Used Space of Partitions - Unix | Used space of partitions | |
| Inventory and License | Network Information (UNIX) | Hostname - Unix | TCPIP | Hostname |
| Inventory and License | Network Information (UNIX) | Domain - Unix | TCPIP | Domain |
| Inventory and License | Network Information (UNIX) | Domain Search Path - Unix | TCPIP | Domain search path |
| Inventory and License | Network Information (UNIX) | Workgroup - Unix | TCPIP | Workgroup |
| Inventory and License | Network Information (UNIX) | DNS Servers - Unix | TCPIP | Dns servers |
| Inventory and License | Network Information (UNIX) | Network Devices - Unix | Network Adapter | Adapter name |
| Inventory and License | Network Information (UNIX) | IP Addresses - Unix | TCPIP | Ip address |
| Inventory and License | Network Information (UNIX) | MAC Addresses - Unix | Network Adapter | Mac address |
| Inventory and License | Network Information (UNIX) | Subnet Masks - Unix | TCPIP | Subnet masks |
| Inventory and License | Network Information (UNIX) | Broadcast Addresses - Unix | TCPIP | Broadcast addresses |
| Inventory and License | Network Information (UNIX) | PPP Enabled - Unix | TCPIP | Ppp enabled |
| Inventory and License | Hardware Information (HP-UX) | CPU - HP-UX | Processor | Cpu |
| Inventory and License | Hardware Information (HP-UX) | Number of Processors - HP-UX | Computer | Number of processors |
| Inventory and License | Hardware Information (HP-UX) | Hard Disks - HP-UX | Storage | Hard disk |
| Inventory and License | Hardware Information (HP-UX) | RAID - HP-UX | ||
| Inventory and License | Hardware Information (HP-UX) | CD-ROM - HP-UX | Storage | Cd rom |
| Inventory and License | Hardware Information (HP-UX) | Tape Drives - HP-UX | Storage | Tape drive |
| Inventory and License | Hardware Information (HP-UX) | Network Adapter - HP-UX | Network Adapter | Adapter name |
| Inventory and License | Hardware Information (HP-UX) | Video Controller - HP-UX | Media | Video controller |
| Inventory and License | Hardware Information (HP-UX) | Sound Device - HP-UX | Media | Audio device |
| Inventory and License | Hardware Information (HP-UX) | All Devices - HP-UX | All devices | |
| Inventory and License | Hardware Information (AIX) | CPU - AIX | Computer | Cpu |
| Inventory and License | Hardware Information (AIX) | Number of Processors - AIX | Computer | Number of processors |
| Inventory and License | Hardware Information (AIX) | Hard Disks - AIX | Storage | Hard disks |
| Inventory and License | Hardware Information (AIX) | RAID - AIX | ||
| Inventory and License | Hardware Information (AIX) | CD-ROM - AIX | Storage | Cd rom |
| Inventory and License | Hardware Information (AIX) | Tape Drives - AIX | Storage | Tape drives |
| Inventory and License | Hardware Information (AIX) | Network Adapter - AIX | Network Adapter | Adapter name |
| Inventory and License | Hardware Information (AIX) | Video Controller - AIX | Media | Video controller |
| Inventory and License | Hardware Information (AIX) | Audio Device - AIX | Media | Audio device |
| Inventory and License | Hardware Information (AIX) | All Devices - AIX | ||
| Inventory and License | Hardware Information (AIX) | Number of Processor Cores - AIX | Computer | Number of processor cores |
| Inventory and License | Hardware Information (Solaris) | Platform - Solaris | Computer | Platform |
| Inventory and License | Hardware Information (Solaris) | Memory - Solaris | Computer | Ram |
| Inventory and License | Hardware Information (Solaris) | CPU - Solaris | Processor | Cpu |
| Inventory and License | Hardware Information (Solaris) | Number of Processors - Solaris | Computer | Number of processors |
| Inventory and License | Hardware Information (Solaris) | Storage Devices - Solaris | Storage | Storage devices |
| Inventory and License | Hardware Information (Solaris) | Network Adapter - Solaris | Network Adapter | Adapter name |
| Inventory and License | Hardware Information (Solaris) | Video Controller - Solaris | Media | Video controller |
| Inventory and License | Hardware Information (Solaris) | Sound Device - Solaris | Media | Audio device |
| Inventory and License | Network Information (Windows) | DHCP Servers - Windows | TCPIP | Dhcp servers |
| Inventory and License | Network Information (Windows) | DNS Servers - Windows | TCPIP | Dns servers |
| Inventory and License | Network Information (Windows) | Domain/Workgroup - Windows | TCPIP | Domain |
| Inventory and License | Network Information (Windows) | PPP Enabled - Windows | TCPIP | Ppp enabled |
| Inventory and License | Network Information (Windows) | MAC Addresses - Windows | Network Adapter | Mac address |
| Inventory and License | Network Information (Windows) | Subnet Masks - Windows | TCPIP | Subnet masks |
| Inventory and License | Hardware Information (Windows) | Computer Manufacturer - Windows | Computer | Manufacturer |
| Inventory and License | Hardware Information (Windows) | Computer Model - Windows | Computer | Model |
| Inventory and License | Hardware Information (Windows) | Identifying Number - Windows | Computer | Serial number |
| Inventory and License | Hardware Information (Windows) | Laptop - Windows | Computer | Laptop |
| Inventory and License | Hardware Information (Windows) | Brand String of CPU - Windows | Processor | Cpu |
| Inventory and License | Hardware Information (Windows) | Number of Processors - Windows | Computer | Number of processors |
| Inventory and License | Hardware Information (Windows) | Number of Fixed Drives - Windows | Computer | Number of fixed drives |
| Inventory and License | Hardware Information (Windows) | Disk Drives - Windows | Storage | Disk drives |
| Inventory and License | Hardware Information (Windows) | CD-ROM - Windows | Storage | Cd rom |
| Inventory and License | Hardware Information (Windows) | Network Adapter - Windows | Network Adapter | Adapter name |
| Inventory and License | Hardware Information (Windows) | Video Controller - Windows | Media | Video controller |
| Inventory and License | Hardware Information (Windows) | Sound Device - Windows | Media | Audio device |
| Inventory and License | Hardware Information (Windows) | Monitor - Windows | Display | Monitor |
| Inventory and License | Hardware Information (Windows) | Screen Resolution - Windows | Display | Screen resolution |
| Inventory and License | Hardware Information (Windows) | IDE/SATA Devices - Windows | ||
| Inventory and License | Hardware Information (Windows) | SCSI Devices - Windows | ||
| Inventory and License | Hardware Information (Windows) | Number of Processor Cores - Windows | Computer | Number of processor cores |
| Inventory and License | VMWare Workstation Information (Windows) | Version - VMWare Workstation | ||
| Inventory and License | VMWare Workstation Information (Windows) | Product ID - VMWare Workstation | ||
| Inventory and License | VMWare Workstation Information (Windows) | Serial Number - VMWare Workstation | ||
| Inventory and License | VMWare Workstation Information (Windows) | License Type - VMWare Workstation | ||
| Inventory and License | VMWare Workstation Information (Windows) | License Version - VMWare Workstation | ||
| Inventory and License | Hardware Information (Mac OS X) | CPU - Mac OS X | Processor | Cpu |
| Inventory and License | Hardware Information (Mac OS X) | Current RAM - Mac OS X | Computer | Ram |
| Inventory and License | Hardware Information (Mac OS X) | Serial Number - Mac OS X | Computer | Serial number |
| Inventory and License | Hardware Information (Mac OS X) | Machine Model - Mac OS X | Computer | Model |
| Inventory and License | Hardware Information (Mac OS X) | Laptop - Mac OS X | Computer | Laptop |
| Inventory and License | Hardware Information (Mac OS X) | Size of Volumes - Mac OS X | ||
| Inventory and License | Hardware Information (Mac OS X) | Free Space of Volumes - Mac OS X | ||
| Inventory and License | Hardware Information (Mac OS X) | Number of Processor Cores - Mac OS X | Computer | Number of processor cores |
| Inventory and License | Network Information (Mac OS X) | Hostname - Mac OS X | TCPIP | Hostname |
| Inventory and License | Network Information (Mac OS X) | Domain - Mac OS X | TCPIP | Domain |
| Inventory and License | Network Information (Mac OS X) | Domain Search Path - Mac OS X | TCPIP | Domain search path |
| Inventory and License | Network Information (Mac OS X) | Workgroup - Mac OS X | TCPIP | Workgroup |
| Inventory and License | Network Information (Mac OS X) | Active Directory Path - Mac OS X | TCPIP | Active directory path |
| Inventory and License | Network Information (Mac OS X) | DNS Servers - Mac OS X | TCPIP | Dns servers |
| Inventory and License | Network Information (Mac OS X) | Network Devices - Mac OS X | Network Adapter | Adapter name |
| Inventory and License | Network Information (Mac OS X) | IP Addresses - Mac OS X | TCPIP | Ip address |
| Inventory and License | Network Information (Mac OS X) | MAC Addresses - Mac OS X | Network Adapter | Mac address |
| Inventory and License | Network Information (Mac OS X) | Subnet Masks - Mac OS X | TCPIP | Subnet masks |
| Inventory and License | Network Information (Mac OS X) | Broadcast Addresses - Mac OS X | TCPIP | Broadcast addresses |
| Inventory and License | Network Information (Mac OS X) | PPP Enabled - Mac OS X | TCPIP | Ppp enabled |
| Inventory and License | Network Information (Mac OS X) | Multicast Support - Mac OS X | TCPIP | Multicast support |
| Inventory and License | Physical _ Virtual Computer Type Analysis | Computer Type | Computer | Computer type |
| Inventory and License | Hardware Information (Linux) | Base Board - Linux | ||
| Inventory and License | Hardware Information (Linux) | Laptop - Linux | Computer | Laptop |
| Inventory and License | Hardware Information (Linux) | Brand String of CPU - Linux | Processor | Cpu |
| Inventory and License | Hardware Information (Linux) | Number of Processors - Linux | Computer | Number of processors |
| Inventory and License | Hardware Information (Linux) | Hard Disks - Linux | Storage | Hard disks |
| Inventory and License | Hardware Information (Linux) | RAID - Linux | Raid | |
| Inventory and License | Hardware Information (Linux) | CD-ROM - Linux | Storage | Cd rom |
| Inventory and License | Hardware Information (Linux) | Network Adapters - Linux | Network Adapter | Adapter name |
| Inventory and License | Hardware Information (Linux) | Video Controller - Linux | Media | Video controller |
| Inventory and License | Hardware Information (Linux) | Sound Device - Linux | Media | Audio device |
| Inventory and License | Hardware Information (Linux) | FireWire (IEEE 1394) - Linux | Firewire(ieee 1394) | |
| Inventory and License | Hardware Information (Linux) | All Devices - Linux | All devices | |
| Inventory and License | Hardware Information (Linux) | Number of Processor Cores - Linux | Computer | Number of processor cores |
| Inventory and License | Operating System Information (UNIX) | OS Name - Unix | Operating System | Os name |
| Inventory and License | Operating System Information (UNIX) | Kernel version / OS Release - Unix | Operating System | Os version |
| Inventory and License | Operating System Information (UNIX) | OS Build - Unix | Operating System | Os build |
| Inventory and License | Operating System Information (UNIX) | OS Architecture - Unix | Operating System | Os architecture |
| Inventory and License | Operating System Information (UNIX) | Uptime - Unix | Operating System | Uptime |
| Inventory and License | Operating System Information (UNIX) | Local Time Zone - Unix | ||
| Inventory and License | Operating System Information (UNIX) | Number of Running Processes - Unix | ||
| Inventory and License | Operating System Information (Mac OS X) | OS Name - Mac OS X | Operating System | Os name |
| Inventory and License | Operating System Information (Mac OS X) | OS Release - Mac OS X | Operating System | Os version |
| Inventory and License | Operating System Information (Mac OS X) | OS Build - Mac OS X | Operating System | Os build |
| Inventory and License | Operating System Information (Mac OS X) | Uptime - Mac OS X | Operating System | Uptime |
| Inventory and License | Operating System Information (Mac OS X) | Local Time Zone - Mac OS X | ||
| Inventory and License | Operating System Information (Mac OS X) | Number of Processes - Mac OS X | Operating System | Number of processors |
| Inventory and License | Hypervisor Host Information | Hypervisor Host Information | Computer | Hypervisor host information |
| Inventory and License | Virtual Machine Guest Information | Virtual IDs of VM Guests | Computer | Virtual ids of vm guests |
| Mobile Device Management | Device Details - Android / Apple iOS | Carrier | Computer | Carrier |
| Mobile Device Management | Device Details - Android / Apple iOS | GUID / IMEI | Computer | Imei |
| Mobile Device Management | Device Details - Android / Apple iOS | Device Ownership | Computer | Device ownership |
| Mobile Device Management | Device Details - Android / Apple iOS | Device Phone Number | Computer | Device phone number |
| Mobile Device Management | Device Details - Android / Apple iOS | Manufacturer | Computer | Manufacturer |
| Mobile Device Management | Device Details - Android / Apple iOS | Device Id | Computer | Device id |
| Mobile Device Management | Device Details - Android / Apple iOS | Serial Number | Computer | Serial number |
| Mobile Device Management | Device Details - Android / Apple iOS | Model | Computer | Model |
| Mobile Device Management | Device Details - Android / Apple iOS | UUID / UDID | Computer | Uuid |
| Mobile Device Management | Device Details - Android / Apple iOS | User Name | Computer | User name |
| Mobile Device Management | Device Details - Android / Apple iOS | Authenticated User ID | Computer | Authenticated user id |
| Mobile Device Management | Device Details - Lotus Traveler / MS Exchange / BlackBerry / Divide | Model | Computer | Model |
| Mobile Device Management | Device Details - Lotus Traveler / MS Exchange / BlackBerry / Divide | Device Phone Number | Computer | Device Phone Number |
| Mobile Device Management | Device Details - Lotus Traveler / MS Exchange / BlackBerry / Divide | User name | Computer | User name |
| Mobile Device Management | Password Settings | Password Compliant | Computer | Password compliant |
| Mobile Device Management | Password Settings | Password Enabled | Computer | Password enabled |
| Virtual Endpoint Manager | Virtual Machine Host Information | Virtual Machines | Computer | Virtual machines |