RHN_HOST_MONITORING
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| RECID | NUMBER(38) | N | YES | YES | YES | |
| IP | VARCHAR2(4000) | Y | NO | NO | NO | |
| NAME | VARCHAR2(128) | Y | YES | YES | YES | |
| DESCRIPTION | VARCHAR2(256) | Y | YES | YES | YES | |
| CUSTOMER_ID | NUMBER(38) | N | YES | YES | YES | |
| OS_ID | CHAR(1) | Y | NO | NO | NO | |
| ASSET_ID | VARCHAR2(0) | Y | NO | NO | NO | |
| LAST_UPDATE_USER | VARCHAR2(0) | Y | NO | NO | NO | |
| LAST_UPDATE_DATE | VARCHAR2(0) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select s.id as recid,
rhn_server.get_ip_address(s.id) as ip,
s.name as name,
s.description as description,
s.org_id as customer_id,
'4' as os_id,
null as asset_id,
null as last_update_user,
null as last_update_date
from rhnServer s