VMware Cloud Community
vMarkusK1985
Expert
Expert
Jump to solution

vCAC MS SQL Database Table - Users

What is the criteria that a user is listed in this Table?

SELECT TOP 1000 [UserName] FROM [vCAC].[dbo].[Users]

Only has logged in, is owner of objects, etc.?

Kind Regards,

Markus

https://mycloudrevolution.com | https://twitter.com/vMarkus_K | https://github.com/vMarkusK
1 Solution

Accepted Solutions
kumarankpl
Hot Shot
Hot Shot
Jump to solution

IAAS Users Table won't have entry until or unless an Resource/machine is associated with the user. So its expected that some of the User are missing. So which means until machine is provisioned or managed User info won't be available in the IAAS User Table. When user triggers Change owner the new user will be inserted into IAAS DB and then transfer the ownership of the VM. All this will be performed as part of edit/Reconfigure action.

Thanks

Kumaran

View solution in original post

2 Replies
kumarankpl
Hot Shot
Hot Shot
Jump to solution

IAAS Users Table won't have entry until or unless an Resource/machine is associated with the user. So its expected that some of the User are missing. So which means until machine is provisioned or managed User info won't be available in the IAAS User Table. When user triggers Change owner the new user will be inserted into IAAS DB and then transfer the ownership of the VM. All this will be performed as part of edit/Reconfigure action.

Thanks

Kumaran

vMarkusK1985
Expert
Expert
Jump to solution

Thanks!

https://mycloudrevolution.com | https://twitter.com/vMarkus_K | https://github.com/vMarkusK
Reply
0 Kudos