[OCI] Qtree Count on Each OCI Server

A simple OCI DataWarehouse MySQL query to see how many qtrees you have on each of your regional OCI servers:

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(url,'/',3),'/',-1) AS 'OCI Server',count(*)
FROM dwh_inventory.qtree
GROUP BY `OCI Server`;