
synopsis:

	Package event history

description:

	Package event history.

columns:

	server_id:i	System identifier
	event_id:i	Event id
	created_date	Date created
	earliest_action	Earliest date this action will occur
	pickup_date	The date/time the action was picked up
	completed_date	The date/time the event was completed
	status		Status of the event
	event		Type of the event
	event_data	Package name, version, and release

multival_columns:

	event_id
	event_data : event_data

sql:

	select server_id, event_id, created_date, earliest_action, pickup_date, completed_date, status, event, event_data from (
	select rhnserveraction.server_id,
		rhnserveraction.action_id as event_id,
		to_char(rhnaction.created, 'YYYY-MM-DD HH24:MI:SS') as created_date,
		rhnaction.created as created_raw_date,
		to_char(rhnaction.earliest_action, 'YYYY-MM-DD HH24:MI:SS') as earliest_action,
		to_char(rhnserveraction.pickup_time, 'YYYY-MM-DD HH24:MI:SS') as pickup_date,
		to_char(rhnserveraction.completion_time, 'YYYY-MM-DD HH24:MI:SS') as completed_date,
		rhnactionstatus.name as status,
		case when rhnactiontype.name = 'Package Install' and rhnactionpackage.parameter = 'upgrade' then 'Package Upgrade'
			else rhnactiontype.name end as event,
		rhnpackagename.name
				|| case when rhnpackageevr.id is not null then '-' || evr_t_as_vre_simple(rhnpackageevr.evr) end
				|| case when rhnpackagearch.id is not null then '.' || rhnpackagearch.label end
			as event_data
	from rhnserveraction, rhnactionpackage
		left outer join rhnpackageevr
			on rhnactionpackage.evr_id = rhnpackageevr.id
		left outer join rhnpackagearch
			on rhnactionpackage.package_arch_id = rhnpackagearch.id
		, rhnpackagename, rhnaction, rhnactiontype, rhnactionstatus
	where rhnserveraction.action_id = rhnactionpackage.action_id
		and rhnactionpackage.name_id = rhnpackagename.id
		and rhnserveraction.action_id = rhnaction.id
		and rhnaction.action_type = rhnactiontype.id
		and rhnserveraction.status = rhnactionstatus.id
	) X
	-- where placeholder
	order by server_id, created_raw_date, event_id

