Member Table

The Member table stores the membership lists for every group. Each Member details a User, Computer, Group, or Organization (only Policy ACL groups), and whether the specified item is excluded (only ACL groups), included (the default) or included mandatorily (cannot be excluded - used only for Organizations in Policy ACLs).

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for Member table

Database Column

Details

GroupID

Type: integer. Key

The Group of which this is a Member.

TargetTypeID

Type: integer. Key

The TargetType. Possible values are:

  • 1 = Computer
  • 2 = User
  • 3 = Group
  • 8 = OrgUnit
  • 16 = Operator
TargetID

Type: integer. Key

The ComputerID, UserID, GroupID or OrganizationID.

MemberMode

Type: integer

The MemberMode is 0 for Exclude (regardless of any other memberships, the principals of this Target are excluded from this group), 1 for Include, and 2 for Always - NoOverride.