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