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 |