accountsreport


Description

List of all users for all organizations, with their details and roles.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
mgm_id numeric 131089 null

The id of the SUSE Manager instance that contains this data

organization varchar 128 null

The organization that owns this data

account_id numeric 131089 null

The id of the user account

username varchar 64 null

The username used to login

last_name varchar 128 null

The person last name(s)

first_name varchar 128 null

The person first name(s)

position varchar 128 null

The descriptive role of this user within the organization

email varchar 128 null

The email address associated with this account

roles text 2147483647 null

List of roles assigned to the user, separated by ;

creation_time timestamptz 35,6 null

When this user account was created

last_login_time timestamptz 35,6 null

When this user account logged in for the last time

status varchar 32 null

Current status of the user. Possible values: enabled, disabled

md5_encryption bool 1 null

True if md5 encryption is used to encode the user password.

synced_date timestamptz 35,6 null

The timestamp of when this data was last refreshed.

Relationships

View Definition


Possibly Referenced Tables/Views