EffectiveLoginUserPrivilege_Computer View

This view lists the users who can log in and the computers that they can log in to. .

Column Name

Description

Refers to

ADComputer_CanonicalName

The canonical name of the AD Computer in where the privileges effective

 

ADComputer_CnName

The Cn name of the AD Computer in where the privileges effective

 

ADComputer_DnsHostName

The dns host name of the AD Computer in where the privileges effective

 

ADComputer_ObjectName

The object name of the AD Computer in where the privileges effective

 

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 name for the Active Directory user, formatted as <user 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 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)

 

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 ID of the Trustee

Trustee_Type = 1: ADUsers.ADUser_GUID

 

Trustee_Type = 2:

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