
synopsis:

	System entitlement event history

description:

	System entitlement event history.

columns:

	server_id:i	System identifier
	event_id:i	Event id
	created_date	Date created
	status		Status of the event
	event		Type of the event
	event_data	Additional parameters / details for the event

multival_columns:

	event_id
	event_data : event_data

sql:

	select server_id, event_id, created_date, status, event, event_data from (
	select rhnserverhistory.server_id,
		rhnserverhistory.id as event_id,
		to_char(rhnserverhistory.created, 'YYYY-MM-DD HH24:MI:SS') as created_date,
		rhnserverhistory.created as created_raw_date,
		'D' || 'one' as status,
		case when rhnserverhistory.summary like 'Updated system release %' then 'Updated system release'
			else trim(upper(substr(rhnserverhistory.summary, 1, 1)) || substr(rhnserverhistory.summary, 2)) end as event,
		case when summary in ( 'added system entitlement ', 'removed system entitlement ') then details
			when summary like 'Updated system release %' then substr(summary, 24)
		end as event_data
	from rhnserverhistory
	where rhnserverhistory.summary not like 'subscribed to channel %'
		and rhnserverhistory.summary not like 'unsubscribed from channel %'
	) X
	-- where placeholder
	order by server_id, created_raw_date, event_id

