If a request/complaint is made against suppose, workstation 'PC-2013' and assigned to 'Hardware' I want a report that shows all requests of this workstation that have been assigned to 'Hardware' ONLY. If possible I would also like the number of days between the requests.
| PC does not Boot |
11/2/2016 |
|
| RAM damaged |
12/2/2016 |
30 ( days after the previous complaint) |
|
|
|
The day count is secondary. But the remaining details such as the request id, requestor name, department , problem and the date is required.