Can I please get a query that shows all the requests that have been generated for a particular asset/workstation?

For Example:

PC-1265

Does not boot

Heating up

and so on ... 

Version : 8.1.0  Build  8112

Thank You