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 ADSelfService Plus?