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 | DATE | 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 org_id,
u.id user_id,
u.login user_login,
pi.first_names user_first_name,
pi.last_name user_last_name,
u.modified user_modified,
( select count(server_id)
from rhnUserServerPerms sp
where sp.user_id = u.id)
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))
server_group_count,
( select nvl(utcv.names, '(normal user)')
from rhnUserTypeCommaView utcv
where utcv.user_id = u.id)
role_names
from web_user_personal_info pi,
web_contact u
where
u.id = pi.web_user_id