OpenNMS Tickets create

gistfile1.txt

SELECT
	count(*) AS tally,
	CAST(date_trunc('minute', "eventtime") AS timestamp) AS date,
	CASE
		WHEN events.eventuei = 'uei.opennms.org/troubleTicket/create' THEN CAST('Create' AS text)
		WHEN events.eventuei = 'uei.opennms.org/troubleTicket/update' THEN CAST('Update' AS text)
		WHEN events.eventuei = 'uei.opennms.org/troubleTicket/close' THEN CAST('Close' AS text)
	END AS type
FROM
	events
WHERE
	eventuei LIKE 'uei.opennms.org/troubleTicket/%'
	AND events.eventtime > now() - INTERVAL '2 days'
GROUP BY
	date,
	eventuei
ORDER BY
	date