RHNUSERACTIONOVERVIEW
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 | |
| ID | NUMBER(38) | N | NO | NO | NO | |
| TYPE_NAME | VARCHAR2(96) | N | NO | NO | NO | |
| SCHEDULER | NUMBER(38) | Y | NO | NO | NO | |
| EARLIEST_ACTION | DATE | N | NO | NO | NO | |
| ACTION_NAME | VARCHAR2(128) | Y | NO | NO | NO | |
| ACTION_STATUS_ID | NUMBER(38) | N | NO | NO | NO | |
| ACTION_STATUS | VARCHAR2(16) | Y | NO | NO | NO | |
| TALLY | NUMBER(38) | Y | NO | NO | NO | |
| ARCHIVED | NUMBER(38) | N | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select ao.org_id org_id,
usp.user_id user_id,
ao.action_id id,
ao.type_name type_name,
ao.scheduler scheduler,
ao.earliest_action earliest_action,
decode(ao.name, null, ao.type_name, ao.name) action_name,
sa.status action_status_id,
astat.name action_status,
count(sa.action_id) tally,
ao.archived archived
from rhnActionStatus astat,
rhnUserServerPerms usp,
rhnServerAction sa,
rhnActionOverview ao
where ao.action_id = sa.action_id
and sa.server_id = usp.server_id
and sa.status = astat.id
group by ao.org_id,
usp.user_id,
ao.action_id,
ao.type_name,
ao.scheduler,
ao.earliest_action,
decode(ao.name, null, ao.type_name, ao.name),
sa.status,
astat.name,
ao.archived
order by earliest_action