Spacewalk DB Schema - View-RHNSERVERCRASHCOUNT

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

RHNSERVERCRASHCOUNT

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
SERVER_ID	NUMBER(38)	N	NO	NO	NO
UNIQUE_COUNT	NUMBER(38)	Y	NO	NO	NO
TOTAL_COUNT	NUMBER(38)	Y	NO	NO	NO
LAST_REPORT	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select server_id,
       count(id) as unique_count,
       sum(count) as total_count,
       max(modified) as last_report
  from rhnServerCrash
 group by server_id