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
add a comment

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
add a comment

Get to know Ask OpenStack

Resources for moderators

Question Tools

1 follower

subscribe to rss feed

Stats

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

Seen: 902 times

Last updated: Apr 01 '15

Related questions

nova compute

Can't delete or force-delete instance

Unable to start openstack-nova-compute.service

Nova-compute does not show up in service list

Openstack not showing hypervisor and availability zones [closed]

nova-network create on compute node

Amazon EMR vs OpenStack

Connection to libvirt failed

ERROR (CommandError): You must provide a username or user id via --os-username, --os-user-id, env[OS_USERNAME] or env[OS_USER_ID]

compute instance