Request Report - In Store Assets by type and location

Request Report - In Store Assets by type and location

We have created a separate CI called Locations, and created a relationship between the assets in Store to these locations (having a locations field as a custom string is pretty much useless, and with a large business, having a dropdown for 500+ different locations is equally useless)

We would need a report to generate a list of In Store objects, listing their relationship target for "Located in", separate by the CI Type (e.g. switch)

So
Filter: Asset State: In Store
Group by: CI Type

Product Name, Asset Tag, Serial Number, Site, Located In

Could anybody help me with that? My SQL capabilities are so-so, and I really don't have much grasp on the AE data model

Thank you advance for any and all help any of you can provide

~Christian
//Mercedes-Benz Sverige/Danmark

Installation details
------------------
AE: 6122
Server: Windows 2012 R2
DB: MSSQL 2012
Protocol: HTTPS
GPO-deployed Agent-scan
              New to ADManager Plus?

                New to ADSelfService Plus?