SSIS Log Transaction Based Query

SELECT project_name
,a.package_name
,cast(start_time as smalldatetime) as StartTime
,cast(end_time as smalldatetime) as EndTime
,CAST(DATEDIFF(MINUTE, cast(start_time as smalldatetime), cast(end_time as smalldatetime))/60 AS VARCHAR(10))+':' + CAST(DATEDIFF(MINUTE, cast(start_time as smalldatetime), cast(end_time as smalldatetime)) % 60 AS VARCHAR(2)) AS [TimeProccess]
--,MESSAGE --> IF You Want To Know Massage In Packet SSIS
,CASE WHEN status = 1 THEN 'created'
WHEN status = 2 THEN 'running'
WHEN status = 3 THEN 'canceled'
WHEN status = 4 THEN 'failed'
WHEN status = 5 THEN 'pending'
WHEN status = 6 THEN 'ended unexpectedly'
WHEN status = 7 THEN 'succeeded'
WHEN status = 8 THEN 'stopping'
WHEN status = 9 THEN 'completed'
ELSE 'Not Active' END AS [Status]
,COUNT(*) AS [Count]
FROM SSISDB.catalog.executions a
--JOIN SSISDB.catalog.event_messages c ON a.execution_id = c.operation_id --> IF You Want To Know Massage In Packet SSIS
WHERE cast(start_time as smalldatetime) >= ( SELECT DATEADD(d,DATEDIFF(d,0,getdate()),0) ) --> This Show You Latest Packet Run Daily
GROUP BY a.package_name,cast(start_time as smalldatetime),cast(end_time as smalldatetime),status,project_name--,MESSAGE
ORDER BY StartTime DESC,package_name