Functions and Views for All Products > apt_v_group_member
  
Version 10.0.01
apt_v_group_member
The apt_v_group_member view contains a single row for each of the parent/child relationships that create the server group hierarchy. For example, for each client that is a member of a single server group, a row will exist within this view.
Table 7 apt_v_group_member
Column Name
Data Type
Description
child_id
NUMBER
If child_type = 1, foreign key to apt_v_server
If child_type = 2, foreign key to apt_v_group
child_type
NUMBER
Enumeration field with the following possible values:
1 = child is a server group
2 = child is a client/server
date_modified
DATE
Date/time this record was last created/updated
group_id
NUMBER
Unique group ID. Primary key in this view
modified_by
NUMBER
User ID of the user who modified this group member
modified_by_name
STRING
Name of the user who modified this group member