SELECT asset.fqdn, port.name FROM port JOIN asset KEY port.assetId
How would I run a query like this:
Asset document is asset:1 and has asset.id (asset:1), and some other details.
Port document has port.assetId (asset:1) and some other details.
Trying to get ports associated with the asset without listing all port UUID’s under the asset.