Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.77 netmdm_vidlist

This table stores the software information obtained by using the Search for anti-virus products option of a Get software information from client job. Note that some of the information might not be 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_virusversion VARCHAR2 255 varchar 255 MVARCHAR 255 Version of the virus definition file --
dm_name VARCHAR2 255 varchar 255 MVARCHAR 255 Software name --
dm_version VARCHAR2 255 varchar 255 MVARCHAR 255 Software version --
dm_language CHAR 2 char 2 VARCHAR 2 Language --
dm_publisher VARCHAR2 255 varchar 255 MVARCHAR 255 Company name --
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_engineversion VARCHAR2 255 varchar 255 MVARCHAR 255 Version of virus detection engine --
dm_softwareid VARCHAR2 255 varchar 255 MVARCHAR 255 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_permanent NUMBER 10 int 4 INTEGER -- Resident or nonresident virus detection --
dm_productid VARCHAR2 255 varchar 255 MVARCHAR 255 (Not used) --
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