EffectiveUserPrivileges_Zone_UNIX View

The EffectiveUserPrivileges_Zone view lists effective zone level role assignments for each user. This view assumes that all computers in the zone are UNIX computers. The assigned Active Directory users must have at least one completed profile in the zone. Assignee “All Active Directory users” is 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 display value for the Active Directory 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 the source assignment location. For this view, it will be always the same as the EffectiveZone_Name

 

Assigned_LocationType

The type of the source assignment location

1 – Zone

 

Assigned_LocationTypeDesc

The display value of the source assignment location

Zone

 

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. 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

Whether this right is for Unix, Windows or both

 

Right_Platform_Desc

The display value of the right platform

 

Right_Type

The ID of the right type

RightType.RightTypeId

Right_Type_Desc

The display value of the right type

 

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

 

Note:   Assigned_LocationType and Assigned_LocationTypeDesc may be removed in a subsequent release.