Virtual columns

Adaxes has virtual columns that you can use in object lists to display certain property values in a user-friendly format, as well as group and sort those by those properties. For example, the column named Disabled can display whether an account is disabled using simple Yes/No values. The values of virtual columns are not stored anywhere and are calculated or derived on the go.

Here's the full list of available virtual columns.

General

These columns will contain values for every type of objects.

  • Display name

  • Column name

  • Description

  • Parent

  • adm-VirtualColumnParent

  • Displays the name of the Organizational Unit or container where the object is located.

  • Domain

  • adm-VirtualColumnDomain

  • Displays the name of the domain where the object is located.

  • Directory type

  • adm-VirtualColumnDirectoryType

  • Display the type of the directory where the object is located e.g. Active Directory, Microsoft Entra ID.

  • Type

  • adm-VirtualColumnType

  • Displays the object type e.g. User, Group.

Users

These columns will contain values only for user objects.

  • Display name

  • Column name

  • Description

  • Account Expired

  • adm-VirtualColumnAccountExpired

  • Displays whether the user account has expired.

  • Account Locked Out

  • adm-VirtualColumnAccountLockedOut

  • Displays whether the user account is locked out.

  • Must Change Password

  • adm-VirtualColumnMustChangePassword

  • Displays whether the user must change their password at next logon.

  • Password Expired

  • adm-VirtualColumnPasswordExpired

  • Displays whether the user's password has expired.

  • Password Never Expires

  • adm-VirtualColumnPasswordNeverExpires

  • Displays whether the user's password never expires.

  • Password Not Required

  • adm-VirtualColumnPasswordNotRequired

  • Displays whether the user's password is not required to logon.

  • Reversible Password

  • adm-VirtualColumnReversiblePassword

  • Displays whether the user's password is stored using reversible encryption.

  • Smartcard Required

  • adm-VirtualColumnSmartCardRequired

  • Displays whether the user account requires a smart card for interactive logon.

  • Use AES

  • adm-VirtualColumnUseAes

  • Displays whether the user account requires AES encryption for Kerberos authentication.

  • Cannot Be Delegated

  • adm-VirtualColumnCannotBeDelegated

  • Displays whether the security context of the user cannot be delegated to a service even if the service account is set as trusted for Kerberos delegation.

  • Guest

  • adm-VirtualColumnGuest

  • Displays whether the user account is a guest account.

  • Authenticator Apps

  • adm-VirtualColumnAuthenticatorApps

  • Displays the name of the authenticator app the user has activated in Adaxes (either for signing in to the Web interface or for self-service password reset).

Computers

These columns will contain values only for computer objects.

  • Display name

  • Column name

  • Description

  • Computer Type

  • adm-VirtualColumnComputerType

  • Displays the type of the computer account e.g. Workstation.

  • Read-Only Domain Controller

  • adm-VirtualColumnReadOnlyDomainController

  • Displays whether the computer account is a read-only domain controller.

Accounts

These columns will contain values only for user and computer accounts.

  • Display name

  • Column name

  • Description

  • Disabled

  • adm-VirtualColumnDisabled

  • Displays whether the account is disabled.

  • Trusted for Delegation

  • adm-VirtualColumnTrustedForDelegation

  • Displays whether the account is trusted for Kerberos delegation.

  • Kerberos Pre-Auth Not Required

  • adm-VirtualColumnKerberosPreAuthNotRequired

  • Displays whether the account doesn't require Kerberos pre-authentication to log on.

  • Use DES Encryption Types

  • adm-VirtualColumnUseDesEncryptionTypes

  • Displays whether the principal is restricted to use only Data Encryption Standard (DES) encryption types for keys.

Groups

These columns will contain values only for group objects.

  • Display name

  • Column name

  • Description

  • Security Group

  • adm-VirtualColumnGroupTypeNoScope

  • Displays whether the group is a security group or not.

  • Group Scope

  • adm-VirtualColumnGroupScope

  • Displays the group scope.

  • Group Type

  • adm-VirtualColumnGroupTypeAndScope

  • Displays the group scope and the group type.

  • Privacy

  • adm-VirtualColumnVisibility

  • Displays the privacy settings of the Microsoft Entra ID group.

  • Membership Type

  • adm-VirtualColumnGroupMembershipType

  • Displays the group membership type.

  • Membership Update Schedule

  • adm-VirtualColumnGroupMembershipUpdateSchedule

  • Displays the membership update schedule of rule-based groups.

  • Membership Update Duration

  • adm-VirtualColumnGroupMembershipLastUpdateDuration

  • Displays the last membership update duration if the group is rule-based.

See also

© Softerra 2022. All rights reserved.
Send feedback