Organization Table

The Organization table contains data about organizational units used in a FlexNet Manager Suite environment.

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 Organization table

Database Column

Details

OrganizationID

Type: integer. Key. Generated ID

The ID for the organizational unit. (1 is used for “unknown OU” in the universal domain).This is automatically generated by SQL Server.

RDN

Type: text (max 400 characters). Key. Nullable

The relative distinguished name of this organizational unit.

GUID

Type: binary (max 16 bytes). Key. Nullable

The objectGUID of the Active Directory object that represents this organizational unit, if known.

DomainID

Type: integer. Key. Nullable

OrganizationID of the domain in which the entry resides. For a domain, must be set to reference self.

RDNReverse

Type: text (max 400 characters). Key. Nullable

The relative distinguished name of the computer, reversed for superior performance on sub-organization searching.

IsUnknown

Type: integer

True (1) if the organizational unit cannot be resolved through Active Directory (for example, the unknown OU, which has a NULL RDN), false (0) otherwise (if the OU has a non-empty RDN).

IsDomain

Type: integer

True (1) if the organizational unit is a domain (has an empty - not NULL - RDN), false (0) otherwise.

BlockInheritance

Type: boolean

True (1) if package allocations should not be inherited from the parent Organization, unless NoOverride is set for the Policy. NoOverride is set using MemberMode=2 (Always) on the Organization member in the Policy ACL group.