Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.31 netmdm_jobgen_soft

This table stores the following part of the job definition information: information about a software search job. This table is associated with netmdm_jobgen.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_folder1 VARCHAR2 32 varchar 32 MVARCHAR 32 Job definition folder level 1 (if not used, NULL) 1
dm_folder2 VARCHAR2 32 varchar 32 MVARCHAR 32 Job definition folder level 2 (if not used, NULL) 2
dm_folder3 VARCHAR2 32 varchar 32 MVARCHAR 32 Job definition folder level 3 (if not used, NULL) 3
dm_folder4 VARCHAR2 32 varchar 32 MVARCHAR 32 Job definition folder level 4 (if not used, NULL) 4
dm_jobgenname VARCHAR2 32 varchar 32 MVARCHAR 32 Job name 5
dm_refersoftware NUMBER 10 int 4 INTEGER -- Software to be searched:
  • 0: Job other than a Get software information from client job
  • 1: Search software installed by Software Distribution
  • 2: Search all software
  • 3: Search for a file
  • 4: Search software listed in "Add/Remove Programs"
  • 5: Search for Microsoft Office products
  • 6: Search for anti-virus products
--
dm_referdrivekind NUMBER 10 int 4 INTEGER -- Drives to be searched:
  • 0: Job other than Get software information from client job
  • 1: All fixed drives
  • 2: All fixed drives + network drives
  • 3: Specified drives
--
dm_referdrivename VARCHAR2 70 varchar 70 MVARCHAR 70 This column is set only when Specified drives is selected as the drives to be searched in a Get software information from client job with drives specification. If multiple drives are specified, the semicolon (;) is used as the delimiter. --
dm_systeminf RAW 24 binary 24 BINARY 24 System information for JP1/Software Distribution Manager --
dm_listname VARCHAR2 32 varchar 32 MVARCHAR 32 Search list name --
dm_listkind NUMBER 3 tinyint 1 SMALLINT -- Type of search list:
  • 0: Standard retrieve list or a search list existing at the client
  • 1: Standard retrieve list and optional software list
  • 2: No search list
  • 3: Optional software list
--
dm_conditionfile LONG RAW -- image -- BLOB -- Name of file containing the file search definition information --

Legend:
--: Not applicable