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:

• The value in the Size column is in bytes.
• An entry in Key No. indicates a sort key (reference item). The lower the key number, the higher the priority. Records in a table are sorted in ascending order on the basis of the key values.