EffectiveGroupPrivileges_Computer View

This view lists the consolidated role assignments, logon privileges, system rights privileges for each group and copmuter. This view only lists the role assignments that are assigned to Active Directory groups, and lists the trustee Active Directory groups and nested groups.

Column Name

Description

Refers to

ADComputer_CanonicalName

The canonical name of the Active Directory Computer in where the privileges effective

 

ADComputer_CnName

The CN name of the Active Directory Computer in where the privileges effective

 

ADComputer_DnsHostName

The DNS host name of the Active Directory Computer in where the privileges effective

 

ADComputer_ObjectName

The object name of the Active Directory Computer in where the privileges effective

 

ADGroup_CanonicalName

The canonical name of the effective assigned Active Directory group

 

ADGroup_GUID

The GUID of the effective assigned Active Directory group

ADGroups.GUID

ADGroup_Name

The name of the effective assigned Active Directory group

 

ADGroup_ObjectName

The object name of the effective assigned Active Directory group. The format is <samAccountName>@<domain name>

 

ADGroup_SamAccountName

The samAccountName of the effective assigned Active Directory group

 

Assigned_Location

The name of the assignment location

 

Assigned_LocationType

The type of the assignment location

1 – Zone, 2 – Computer, 3 – Computer Role

 

Assigned_LocationTypeDesc

The description fo the type of the assignment location

(Zone, Computer, Computer Role)

 

Computer_Platform

The platform ID of the Active Directory Computer in where the privileges effective

1 – Windows, 2 – UNIX

 

Computer_Platform_Desc

The platform description name of the Active Directory Computer in where the privileges effective

(Windows/UNIX)

 

EffectiveZone_Id

The ID of the effective zone for the privilege assignment

Zones.Zone_Id

EffectiveZone_Name

The name of the effective zone for the privilege assignment

 

Right_FullName

The full name of the right

 

Right_Grants_Logon

If this right could support a user to logon to a system

1 – Yes, 0 – No

 

Right_GUID

The GUID of the right

Rights.Right_GUID

Right_Name

The name of the right

 

Right_Platform

The platform ID of the right

0 – Windows, 1 – UNIX, 2 – Windows/UNIX

 

Right_Platform_Desc

The platform description of the right

(Windows, UNIX, Windows/UNIX)

 

Right_Type

The type ID of the right

RightType.RightTypeId

Right_Type_Desc

The type description of the right

 

Role_FullName

The full name of the role

<role name>/<zone name>

 

Role_GUID

The GUID of the role

Roles.Role_Id

Role_Name

The name of the role

 

RoleAssignment_GUID

The object GUID of the role assignment

RoleAssignments.RoleAssignment_GUID

Trustee_Id

The GUID of the Trustee

ADGroups.ADGroup_GDUI

Trustee_Name

The name of the trustee

 

Trustee_Type

The type ID of the trustee type

TrusteeTypes.TrusteeType_Id

Trustee_Type_Desc

The type description of the trustee type

 

ZoneComputer_Id

The ID of the Zone Computer in where the privileges effective

ZoneComputer.ZoneComputer_Id