EffectiveUserPrivileges_ComputerRole_Windows View
The EffectiveUserPrivileges_ComputerRole_Windows view lists effective computer role level role assignments for each user. This view assumes that all computers within the computer role are Windows computers. Assignee “All Active Directory users” are NOT expanded to Active Directory users.
Column Name |
Description |
Refers to |
ADUser_CanonicalName |
The canonical name of the assigned Active Directory user. It will be null when trustee type = 7 |
|
ADUser_FullName |
The full name of the assigned Active Directory user. It will be null when trustee type = 7 |
|
ADUser_GUID |
The GUID of the assigned Active Directory user. It will be null when trustee type = 7 |
ADUsers.ADUser_GUID |
ADUser_Name |
The name of the assigned Active Directory user. It will be null when trustee type = 7 |
|
ADUser_ObjectName |
The general display value for the Active Directory use in the default report. The format is <Active Directory samAccountName>@<domain name>. |
|
ADUser_SamAccountName |
The samAccount name of the assigned Active Directory user. It will be null when trustee type = 7 |
|
ADUser_Upn |
The upn name of the assigned Active Directory user. It will be null when trustee type = 7 |
|
Assigned_Location |
The name of the source assignment location. For this view, it will be always the Computer Role name |
|
Assigned_LocationType |
The type of the source assignment location 3 – Computer Role |
|
Assigned_LocationTypeDesc |
The display value of the source assignment location Computer Role |
|
EffectiveZone_Id |
The ID of the effective zone for the privilege assignment |
Zones.Zone_Id Zones_Hierarchical.Zone_Id |
EffectiveZone_Name |
The name of the effective zone for the privilege assignment |
|
Right_FullName |
The full name of the right. Format in <Right name> / <Right’s zone name> |
|
Right_GUID |
The GUID of the right |
Rights.Right_GUID |
Right_Name |
The name of the right |
|
Right_Platform |
The ID of the right platform |
|
Right_Platform_Desc |
The display value of the right platform |
|
Right_Type |
The ID of the right type |
RightType.RightTypeId |
Right_Type_Desc |
Whether this right is for Unix, Windows or both |
|
Role_FullName |
The full name of the role. Format in <Role name> / <Role’s 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 |
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 GUID of the trustee |
If Trustee_Type = 1: ADUsers.ADUser_GUID If Trustee_Type = 2: ADGroups.ADGroup_GUID |
Trustee_Name |
The name of the trustee |
|
Trustee_Type |
The type of the trustee 1 – Active Directory users 2 – Active Directory groups 7 – All Active Directory users |
TrusteeTypes.TrusteeType_Id |
Trustee_Type_Desc |
The display value of the trustee Active Directory users Active Directory groups All Active Directory users |
|