RbacUser¶
User object for RBAC. Typically replicated from Active Directory
Fields¶
| Field | Type | Description |
|---|---|---|
| Created | datetime2 | Date/Time this object was created |
| CreatedBy | nvarchar | OctoSAM user that created the object |
| DeletedInDirectory | bit | True if the account was deleted in Active Directory but cannot be removed from the database due to referential integrity. For example if set as SoftwareItem owner. |
| DeletedInDirectoryFirstDetected | datetime2 | Date/Time the Deleted in Directory flag was set |
| DirectoryAccountExpires | datetime2 | accountExpires attribute from ActiveDirectory |
| DirectoryDistinguishedName | nvarchar | DN of this user in Active Directory |
| DirectoryGUID | uniqueidentifier | Object-GUID attribute from Active Directory |
| DirectoryMsDSConsistencyGuid | uniqueidentifier | A unique ID used by Microsoft Entra ID to synchronize user information, |
| DirectoryWhenChanged | datetime2 | whenChanged attribute from Active Directory |
| DirectoryWhenCreated | datetime2 | whenCreated attribute from Active Directory |
| Enabled | bit | True if the user is enabled in Active Directory |
| EntraIdId | nvarchar | Entra ID ID of this RBAC user |
| EntraIdLastSignInDateTime | datetime2 | Date/Time the user last signed in with Microsoft Entra ID |
| EntraIdOnPremisesLastSyncDateTime | datetime2 | Date/Time the user was last synchronized |
| EntraIdOnPremisesSyncEnabled | bit | True if the Entra ID user was synchronized from an on premises active directory |
| EntraIdTenantId | uniqueidentifier | Entra ID tenant ID of this RBAC user |
| ExtraData | nvarchar | Extra data in JSON format |
| HashedKey | nvarchar | Reserved for future use |
| ID | bigint | Internal ID for the RbacUser entity (Primary Key) |
| LastFoundInDirectory | datetime2 | Date/Time this object was last found in Active Directory |
| LastModification | datetime2 | Date/Time this object was last modified |
| LastModifiedBy | nvarchar | OctoSAM user that last modified the object |
| MailAddress | nvarchar | mail attribute of this user in Active Directory, |
| Name | nvarchar | Unique user name |
| Notes | nvarchar | Notes for this RBAC user |
| PasswordLastSet | datetime2 | Date/Time the password was last set in Active Directory |
| PasswordNeverExpires | bit | True if the Password Never Expires flag is set in Active Directory |
| PrintableName | nvarchar | Printable name showed for this user in the user interface |
| PrintableName | nvarchar | access rbac user via inventory user id |
| Res1 | nvarchar | Reserved for future use |
| Res2 | nvarchar | Reserved for future use |
| Res3 | nvarchar | Reserved for future use |
| Res4 | nvarchar | Reserved for future use |
| TelephoneNumber | nvarchar | telephoneNumber attribute of this user in ActiveDirectory |
| UserID | bigint | Internal ID that references the User entity (Foreign Key) |
| UserPasswordExpiryTime | datetime2 | Calculated date/time the password will expire |
| UserPrincipalName | nvarchar | userPrincipalName attribute of this user in Active Directory |