Log in Horizon as admin, Admin=>System=>Instances would provide info per tenants (projects) && compute nodes

SQL query :-

MariaDB [nova]> select user_id,project_id,hostname,host from instances ;

will provide complete info . Plus join with tables user, project via fields user_id,project_id
Check tables via commands

MariaDB [keystone]> select * from user;
MariaDB [keystone]> select * from project;

Some sql scripting seems to be required to get a complete report via Mariadb (MySQL) Database