Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.18 netmdm_host_withoutdm

This table stores information about a host on which JP1/Software Distribution is not installed.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_macaddress VARCHAR2 12 varchar 12 MVARCHAR 12 MAC address as hexadecimal lowercase letters without delimiting characters 1
dm_targetflag NUMBER 3 tinyint 1 SMALLINT -- Flag indicating whether the node is to be subject to detection:
  • 0: Subject to detection
  • 1: Not subject to detection
  • 2: Hold
  • 9: Remove
--
dm_name VARCHAR2 80 varchar 80 MVARCHAR 80 Node name (normally the host name) --
dm_description VARCHAR2 255 varchar 255 MVARCHAR 255 Node description --
dm_ipaddress VARCHAR2 15 varchar 15 MVARCHAR 15 IP address --
dm_subnet VARCHAR2 15 varchar 15 MVARCHAR 15 Subnet mask --
dm_nwaddr VARCHAR2 15 varchar 15 MVARCHAR 15 Network address --
dm_finddate DATE -- datetime 8 TIMESTAMP -- First date and time the node was detected --
dm_lastupdatetime DATE -- datetime 8 TIMESTAMP -- Last date and time the node was updated --
dm_nodetype NUMBER 2 tinyint 1 SMALLINT -- Node type:
  • 0: Computer
  • 1: Router
  • 2: Bridge
  • 3: Repeater
  • 4: Printer
  • 5: RMON
--
dm_ip_addr_num NUMBER 10 numeric 10 DECIMAL 10 dm_ipaddress expressed in as numeric value --

Legend:
--: Not applicable