Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.65 netmdm_softwaredic

This table stores the result of searching software inventory at a client.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_ppname VARCHAR2 50 varchar 50 MVARCHAR 50 Software name --
dm_filename VARCHAR2 255 varchar 255 MVARCHAR 255 Names of files constituting the software 1
dm_createdate CHAR 19 char 19 CHAR 19 Date and time the software was created 2
dm_filesize VARCHAR2 10 varchar 10 VARCHAR 10 File size of the software 3
dm_company VARCHAR2 50 varchar 50 MVARCHAR 50 Company name of the software --
dm_language CHAR 2 char 2 VARCHAR 2 Language identifier of the software --
dm_charid CHAR 2 char 2 MCHAR 2 (Unused) --
dm_sversion VARCHAR2 50 varchar 50 MVARCHAR 50 Version of the software --
dm_productname VARCHAR2 50 varchar 50 MVARCHAR 50 Product name of the software --
dm_serchdate CHAR 19 char 19 CHAR 19 Search date of the software --
dm_pflg1 CHAR 1 char 1 MCHAR 1 Option flag 1 (record status):
  • NULL: Initial status
  • 0x01: Displayed
  • 0x02: Hidden
--
dm_pflg2 CHAR 1 char 1 MCHAR 1 Option flag 2 --
dm_ppno NUMBER 10 int 4 INTEGER -- Internal information of JP1/Software Distribution (program product number) --
dm_pathname VARCHAR2 255 varchar 255 MVARCHAR 255 Path to the software --
dm_fversion VARCHAR2 50 varchar 50 MVARCHAR 50 File version --
dm_comment VARCHAR2 50 varchar 50 MVARCHAR 50 Comment --
dm_systemtime CHAR 19 char 19 CHAR 19 Creation date (UTC) --

Legend:
--: Not applicable