Ask Your Question
0

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?

Regards,
RHK

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

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

Comments

Thanks for your response.

Is there any command or API to check?

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

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

Stats

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

Seen: 645 times

Last updated: Apr 01 '15