EffectiveRoleAssignment_Hierarchical View

This view lists all effective role assignments in hierarchical zones for each user and for each computer.

Column Name

Description

Refers to

ADUser_GUID

The object GUID of the AD user which the user profile referring to.

ADUsers.ADUser_GUID

Assigned_Location

The source assignment location

 

Assigned_LocationType

The type of the source assignment location

1 – Zone

2 – Computer

3 – Computer Role

 

Assigned_LocationType_Desc

The display value of the source assignment location

 

Role_GUID

The object GUID ID of the role

Roles.Role_Id

RoleAssignment_GUID

The object GUID of the role assignment

RoleAssignments.RoleAssignment_GUID

RoleAssignment_EndTime

The end date and time for the role assignment.

 

RoleAssignment_StartTime

The start date and time for the role assignment.

 

Trustee_Id

The trustee ID of the role assignment

 

Trustee_Name

The trustee name of the role assignment

 

Trustee_Type

The trustee type ID of the role assignment

TrusteeTypes.TrusteType_Id

Trustee_Type_Desc

The type description of the trustee

 

ZoneComputer_Id

The object GUID ID of the computer profile

ZoneComputer.ZoneComputer_Id