Job Management Partner 1/Software Distribution Description and Planning Guide

[Contents][Glossary][Index][Back][Next]

Appendix C.12 netmdm_discovery_info

This table stores the host information obtained by host search.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_mac_address VARCHAR2 12 varchar 12 VARCHAR 12 MAC address delimited by a lower-case hexadecimal character and stored without the characters 1
dm_ip_address VARCHAR2 15 varchar 15 VARCHAR 15 IP address delimited by the decimal point symbol (.) --
dm_ip_addr_num NUMBER 10 numeric 10 DECIMAL 10 dm_ip_address expressed as a numeric value --
dm_subnet_mask VARCHAR2 15 varchar 15 VARCHAR 15 Subnet mask --
dm_nwaddr VARCHAR2 15 varchar 15 VARCHAR 15 Network address --
dm_nodetype NUMBER 2 tinyint 1 SMALLINT -- Node type:
  • 0: Computer
  • 1: Router
  • 2: Bridge
  • 3: Repeater
  • 4: Printer
  • 5: RMON
--
dm_hostname VARCHAR2 80 varchar 80 MVARCHAR 80 Host name --
dm_description VARCHAR2 256 varchar 256 MVARCHAR 256 Description --
dm_last_dsry_time DATE -- datetime 8 TIMESTAMP -- Last search date and time --

Legend:
--: Not applicable