RHNUSERSINORGOVERVIEW
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORG_ID | NUMBER(38) | N | NO | NO | NO | |
| USER_ID | NUMBER(38) | N | NO | NO | NO | |
| USER_LOGIN | VARCHAR2(64) | N | NO | NO | NO | |
| USER_FIRST_NAME | VARCHAR2(128) | N | YES | YES | YES | |
| USER_LAST_NAME | VARCHAR2(128) | N | YES | YES | YES | |
| USER_MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | NO | NO | NO | |
| SERVER_COUNT | NUMBER(38) | Y | NO | NO | NO | |
| SERVER_GROUP_COUNT | NUMBER(38) | Y | NO | NO | NO | |
| ROLE_NAMES | VARCHAR2(4000) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select
u.org_id as org_id,
u.id as user_id,
u.login as user_login,
pi.first_names as user_first_name,
pi.last_name as user_last_name,
u.modified as user_modified,
( select count(server_id)
from rhnUserServerPerms sp
where sp.user_id = u.id)
as server_count,
( select count(server_group_id)
from rhnUserManagedServerGroups umsg
where umsg.user_id = u.id and exists (
select 1
from rhnVisibleServerGroup sg
where sg.id = umsg.server_group_id))
as server_group_count,
coalesce(rhn_user.role_names(u.id), '(normal user)') as role_names
from web_user_personal_info pi,
web_contact u
where
u.id = pi.web_user_id