Job Management Partner 1/Software Distribution Description and Planning Guide
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) | -- |
All Rights Reserved. Copyright (C) 2009, 2013, Hitachi, Ltd.
Copyright, patent, trademark, and other intellectual property rights related to the "TMEng.dll" file are owned exclusively by Trend Micro Incorporated.