One site as a tree: the site, the locations inside it, the assets standing in those, the assets inside those, and each…

One site as a tree: the site, the locations inside it, the assets standing in those, the assets inside those, and each asset’s bill of materials, in the same shape as asset_hierarchy. An asset inside another belongs to the site of the asset at the top of its chain. With no site it is every site, exactly as asset_hierarchy. Filter, order and page the answer as you would a view; a site is the way to read the tree of an organisation with more assets than a page can reach.