Looking for query assistance

I amwondering if anyone has and would be willing to share, a query that would show all assets (fully reserved and depreciating) and give the Cost, Period Depreciation, YTD Depreciation, Depreciation Reserve, GL code combination for either expense or reserve account, location, category, period name etc.  I have been struggling with this for awhile now.  I can get depreciating asssets and I can get fully reserved assets but can't get them all to show up in one neat little query. Even if it is just a suggestion that gets me started in the right direction,  any help would be greatly