Job Management Partner 1/Software Distribution Description and Planning Guide

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

Appendix C.2 List of relational database tables

The following table lists the relational database tables in alphabetical order.

Table C-1 Relational database tables

Table name Overview See
netmdm_activedirectory Stores information about domains, computers, users, OUs, and groups. C.3
netmdm_addictionary Manages the correspondence between the property attribute names and display names of the domains, computers, users, OUs, and groups managed by Active Directory. C.4
netmdm_adgroup Manages the relationships between a group and its members. C.5
netmdm_adproperty Stores property information about computers, users, OUs, and groups. C.6
netmdm_adupdate Stores the latest flag information that was updated when linkage to Active Directory was established. C.7
netmdm_cabinet Stores information about a package cabinet. C.8
netmdm_clientlist Stores a search results list obtained by searching the software inventory by file name for each client. C.9
netmdm_collect Stores information on remote collection jobs and Collect files from client to relay system jobs. C.10
netmdm_discovery_community Stores a community name specified in host search settings. C.11
netmdm_discovery_info Stores the host information obtained by host search. C.12
netmdm_discovery_options Stores the option settings for host search. C.13
netmdm_discovery_setup Stores host search settings. C.14
netmdm_execution Stores the execution status of each package for each host that is a target of executed jobs. C.15
netmdm_execution_site Stores the execution status of each package for each host that is subject to ID group jobs executed at a relay system. C.16
netmdm_execution_summary Stores information about each all-lower-clients job executed at the central manager. C.17
netmdm_host_withoutdm Stores information about a host on which JP1/Software Distribution is not installed. C.18
netmdm_id Stores the ID groups handled by JP1/Software Distribution. C.19
netmdm_id_policy Stores conditions (policy) for automatic maintenance of ID groups. C.20
netmdm_identry Stores the clients registered in each ID group. C.21
netmdm_inspackage Stores the package installation status for each client. C.22
netmdm_inventry Stores system information for each client. C.23
netmdm_jobgen Stores job definition information. C.24
netmdm_jobgen_collect Stores information about remote collection specified in a job. C.25
netmdm_jobgen_id Stores job definition information for processing ID groups and ID group entries. C.26
netmdm_jobgen_monitoring Stores information about the software operation monitoring specified in a job. C.27
netmdm_jobgen_msg Stores the following part of the job definition information: information about the message to be sent to the client C.28
netmdm_jobgen_node Stores the following part of the job definition information: information about the hosts that are targets of executed jobs. C.29
netmdm_jobgen_pack Stores the following part of the job definition information: package information specified in the job. C.30
netmdm_jobgen_soft Stores the following part of the job definition information: information about a software search job. C.31
netmdm_jobgen_system Stores information needed to link system configuration information an ID group. C.32
netmdm_jobgen_userinv Stores the following part of the job definition information: job information for user inventory. C.33
netmdm_jobsch Stores header information for job execution status. C.34
netmdm_jobsch_site Stores header information for the execution status of an ID group job that was executed at a relay system. C.35
netmdm_jobscript Stores job script file during remote installation. C.36
netmdm_lastupdate Stores the last update date and time of certain tables. C.37
netmdm_mnglist Stores a search list used by a Get software information from client job. C.38
netmdm_monitoring_devicectrl Stores the suppression or activation setting information for each device. C.39
netmdm_monitoring_filter Stores filtering information to be used during logging for software operation monitoring. C.40
netmdm_monitoring_permission Stores permission conditions for software operation monitoring. C.41
netmdm_monitoring_policy Stores an operation monitoring policy for software operation monitoring. C.42
netmdm_monitoring_program Stores information about a program being monitored for software operation monitoring. C.43
netmdm_monitoring_result Stores suppression history for software operation monitoring. C.44
netmdm_monitoring_security Stores suppress history and operation history that are managed in the Operation Log List window. C.45
netmdm_monitoring_usbconnect Manages USB memory information whose access is excluded from being suppressed. C.46
netmdm_monitoring_webfilter Manages the Web access log filtering setting. C.47
netmdm_monitoring_work Stores information about programs from which operation times are acquired. C.48
netmdm_monitoring_workresult Stores information about the software operation times acquired by software operation monitoring. C.49
netmdm_nnm_management Stores information about OpenView Linkage. C.50
netmdm_node Stores destination information. C.51
netmdm_node_policy Stores conditions (policy) for maintaining host groups and ID groups automatically. C.52
netmdm_node_policy_detail Area reserved for function extensions. --
netmdm_oidlist Stores the software information obtained by using the Search for Microsoft Office products option of a Get software information from client job. C.53
netmdm_ospatch_classref Stores class information about patches. C.54
netmdm_ospatch_patchinf Stores patch information and acquired patch data. C.55
netmdm_ospatch_productref Stores information about the programs to be patched. C.56
netmdm_ospatch_script Stores script files for installing patches. C.57
netmdm_ospatch_xmlinf Stores the version of the patch information file. C.58
netmdm_package Stores the package and installation script body. C.59
netmdm_package_inf Stores the package attribute information. C.60
netmdm_registry Stores the registry information for a client. C.61
netmdm_reglist Stores the registry collection items. C.62
netmdm_schedule Stores the schedule of a registered job. C.63
netmdm_softwaredel Stores information about the software that was deleted from software inventory. C.64
netmdm_softwaredic Stores the results of searching software inventory at a client. C.65
netmdm_softwarelicence Stores the number of software licenses. C.66
netmdm_stscnt Stores the job execution status expressed as a combination of host and package subject to job execution. C.67
netmdm_stscnt_site Stores the execution status of ID group jobs executed at a relay system, expressed as a combination of host and package. C.68
netmdm_stscnt_summary Stores the execution status of an all-lower-clients job executed from the central manager, expressed as a combination of host and package. C.69
netmdm_suspend Stores information about whether processing is suspended. C.70
netmdm_system Stores system configuration information. C.71
netmdm_system_delete Stores the deletion history of system configuration information. C.72
netmdm_systeminf Stores the database format. C.73
netmdm_systemjob Stores the system information for JP1/Software Distribution. C.74
netmdm_userinventry Stores user inventory information. C.75
netmdm_userinvlist Stores a list of user inventory items. C.76
netmdm_vidlist Stores the software information obtained by using the Search for anti-virus products option of a Get software information from client job. C.77

Legend:
--: Not applicable

The following sections provide details for all tables.

The tables in these sections use the following conventions: