This script will list the user and reservation between certain dates.
Be sure to change DavidW2_Reservations to the name of your database.
Also, change the date range to match what you are looking for.
FROM [DavidW2_Reservations].[dbo].[Reservations] as res
left join (Select * from [DavidW2_Reservations].[dbo].[ResObjects]) as ResOBJ on resOBJ.ObjectID = res.ObjectID
where StartDate between '2020-07-27' and '2020-08-27'