It would be helpful if you included some of the queries you have tried and the errors you ended up seeing.
This is going to be pretty straight forward in terms of SQL, but requires an understanding of how the data is being calculated and entered.
You pull in the parameters in the query so you have your dates:
declare @st_date datetime:
declare @en_date datetime;
set @en_date = (@en_datein);
set @st_date = (@st_datein);
You can then use those parameters in the queries
Which specific technician (by name) logged how may minutes in journal duration overall (as a sum only) for the time period requested
Select sum(Journal.TimeSpent) as TimeSum,
Where Journal.Owner = @user_param
AND Journal.CreatedDateTime >= @st_date
AND Journal.CreatedDateTime <= @en_date
You can see all of them by dropping the owner clause and add some grouping.
select Owner, sum(Journal.TimeSpent) as TimeSum from Journal group by owner
as well as how much time was logged for specific programs (by name) in Service Requests and Incidents, for the same time requested period.
This is going to be a bit different as you have to apply some grouping
Select Program, sum(Incident.TotalTimeSpent) as TimeSum from Incident
Where Incident.CreatedDateTime >= @st_date
AND Incident.CreatedDateTime <= @en_date
group by Program