Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.53 netmdm_oidlist

This table stores the software information obtained by using the Search for Microsoft Office products option of a Get software information from client job. The Software Inventory page of the System Configuration window or Destination window displays only the software information whose parent software ID is NULL. If the parent software ID is not NULL, the software is not treated as a component of Microsoft Office products.

Note that some of the information is not obtained for some products.

Column name Oracle Microsoft SQL Server Embedded RDB Description Key No.
Data type Size Data type Size Data type Size
dm_nodename VARCHAR2 64 varchar 64 MVARCHAR 64 Node name --
dm_displayname VARCHAR2 255 varchar 255 MVARCHAR 255 Software name (for display) --
dm_name VARCHAR2 255 varchar 255 MVARCHAR 255 Software name --
dm_version VARCHAR2 255 varchar 255 MVARCHAR 255 Software version --
dm_displayversion VARCHAR2 255 varchar 255 MVARCHAR 255 Software version (for display) --
dm_language CHAR 2 char 2 VARCHAR 2 Language --
dm_publisher VARCHAR2 255 varchar 255 MVARCHAR 255 Company name --
dm_productid VARCHAR2 255 varchar 255 MVARCHAR 255 Product ID --
dm_regcompany VARCHAR2 255 varchar 255 MVARCHAR 255 Registered company name --
dm_regowner VARCHAR2 255 varchar 255 MVARCHAR 255 Registered owner name --
dm_installfolder VARCHAR2 255 varchar 255 MVARCHAR 255 Path --
dm_filename VARCHAR2 255 varchar 255 MVARCHAR 255 File name --
dm_softwareid VARCHAR2 255 varchar 255 MVARCHAR 255 Software ID --
dm_parentsoftwareid VARCHAR2 255 varchar 255 MVARCHAR 255 Parent software ID --
dm_installdate VARCHAR2 255 varchar 255 MVARCHAR 255 Installation date --
dm_searchdate VARCHAR2 255 varchar 255 MVARCHAR 255 Search date --
dm_size NUMBER 10 int 4 INTEGER -- Size --
dm_targetos NUMBER 10 int 4 INTEGER -- (Not used) --
dm_accesses NUMBER 10 int 4 INTEGER -- (Not used) --
dm_attributes NUMBER 10 int 4 INTEGER -- (Not used) --
dm_installstate NUMBER 10 int 4 INTEGER -- (Not used) --
dm_installsize NUMBER 10 int 4 INTEGER -- (Not used) --
dm_softwareelementstate NUMBER 10 int 4 INTEGER -- (Not used) --
dm_caption VARCHAR2 255 varchar 255 MVARCHAR 255 (Not used) --
dm_softwareelementid VARCHAR2 255 varchar 255 MVARCHAR 255 (Not used) --
dm_othertargetos VARCHAR2 255 varchar 255 MVARCHAR 255 (Not used) --
dm_lastusedate VARCHAR2 255 varchar 255 MVARCHAR 255 (Not used) --
dm_status VARCHAR2 255 varchar 255 MVARCHAR 255 (Not used) --

Legend:
--: Not applicable