I have been working on making sure all assets are in their proper sites. When I use dim_site to display the site name I only get either “Global” or whatever site the asset is in individually. Is there a way to show all sites that a particular asset belongs to?
In addition, the dim_site_asset table will include the relationship between assets and sites and it an easy way to get the list of site IDs for each asset as well as joining other information to return with your report.
This was exactly what I was looking for. Thank you!