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(100) | N | NO | NO | NO | |
SCHEDULER | NUMBER(38) | Y | NO | NO | NO | |
EARLIEST_ACTION | TIMESTAMP(6) WITH LOCAL TIME ZONE | 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 as org_id,
usp.user_id as user_id,
ao.action_id as id,
ao.type_name as type_name,
ao.scheduler as scheduler,
ao.earliest_action as earliest_action,
coalesce( ao.name, ao.type_name ) as action_name,
sa.status as action_status_id,
astat.name as action_status,
count(sa.action_id) as tally,
ao.archived as 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,
coalesce( ao.name, ao.type_name ),
sa.status,
astat.name,
ao.archived
order by earliest_action