Frank_Hoffmann_9767 Gerne doch, aber ich kann dir nur ein Beispiel anbieten. Das kannst du dann entsprechend adaptieren also deinen Anforderungen anpassen.
with
AH_ACT_DETAIL (AH_CLIENT, AH_NAME, AH_Idnr, AH_OH_IDNR, AH_OTYPE, AH_LDATE, AH_TimeStamp1, AH_TimeStamp2, AH_TimeStamp3, AH_TimeStamp4)
as (
SELECT AH_CLIENT
, AH_Name
, AH_Idnr
, AH_OH_IDNR
, AH_OTYPE
, AH_LDATE
, AH_TimeStamp1
, AH_TimeStamp2
, AH_TimeStamp3
, AH_TimeStamp4
from AH
where 1 = 1
and AH_OTYPE not in ('HOST','SERV','CLNT','QUEUE','USER')
-- Oracle
and AH_TimeStamp1 between to_date(to_char(sysdate - 8, 'YYYYMMDD') || '000000', 'YYYYMMDDHH24MISS')
and to_date(to_char(sysdate - 1, 'YYYYMMDD') || '235959', 'YYYYMMDDHH24MISS')
)
--Total Runs per Client
select 'Total Runs per Client' Section
, AH_CLIENT as "Client Number"
, null as "Object Name"
, null as "Object Identifier"
, AH_OTYPE as "Object Type"
, null AH_LDATE
, null AH_TimeStamp1
, null AH_TimeStamp2
, null AH_TimeStamp3
, null AH_TimeStamp4
, null as "Min Date"
, null as "Max Date"
, count(1) "Count"
, 1 sort
from AH_ACT_DETAIL
-- where AH_OTYPE not in ('REPORT')
group by
AH_CLIENT
, AH_OTYPE
UNION
-- Statistics per client/Object Name/Object Type
select 'Statistics per Client/Object Name/Object Type' Section
, AH_CLIENT
, AH_NAME
, AH_OH_IDNR
, AH_OTYPE
, null AH_LDATE
, null AH_TimeStamp1
, null AH_TimeStamp2
, null AH_TimeStamp3
, null AH_TimeStamp4
, null min_date
, null max_date
, count(1) "Count"
, 2 sort
from AH_ACT_DETAIL
where ah_oh_idnr <> 0
group by AH_CLIENT
, AH_NAME
, AH_OH_IDNR
, AH_OTYPE
;