how to find users instances on which compute?

asked 2015-04-01 02:55:10 -0600

RHK gravatar image

Hi All,

I have a multi compute node environment, when i try to launch a vm my vm will sit on any one of the compute machine depends on resources available on compute (scheduler will takes this responsibility). For example i launched a bulk amount of instances for multiple users, my queston is how can i check user1 instances exist on which compute node, user3 instances on which compute etc.,

Is there any command to find out this?


edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted

answered 2015-04-01 03:22:52 -0600

dbaxps gravatar image

updated 2015-04-01 04:59:47 -0600

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

edit flag offensive delete link more


Thanks for your response.

Is there any command or API to check?

RHK gravatar imageRHK ( 2015-04-01 04:24:06 -0600 )edit

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower


Asked: 2015-04-01 02:55:10 -0600

Seen: 902 times

Last updated: Apr 01 '15