i want a  query report from my tickets with this type:

im using MSSQL Data base and servicedesk plus version 8.2

i need a query like this for each asset of the custome site and department(have to choose witch site or department) :

workorder id	requester(asset owner)	time spent	Other Charge	tehnician	group	category	subcategory	item	state

+ owner of work log in another column

 and end of each asset requests summary show me the sum of the timespent and Other Charges for this asset

in this report i need a report from normal requests and archive requests.

I need total charge of all requests for all of assets.

Thanx