I need your help to generate the following report 

requests created yesterday or in specific period with the following information 

Request Id

Created time

requester

person who assigned request to technician (from History)

time of assignment  (from History)

time of attendance  (from History)

time of closing request 

notes added by technician

Thx