jkasalzuma
Enthusiast
Enthusiast

SQL Database Query to get all VMs with Guest Customization enabled?

Jump to solution

Hello,

Does anyone know of a SQL query that can be run against the vCloud Director DB to get all of the VMs that have guest customization enabled?

I can't get power shell to pull this data globally.

Thanks,

jkasal

0 Kudos
1 Solution

Accepted Solutions
cfor
Expert
Expert

Took a quick stab...

select top 10 v.id,v.name,v.vapp_name,v.vc_id,v.moref,v.guest_customize_enabled from ui_vapp_vm_list_view v with(NOLOCK)

looks to have if the setting is enabled or not...

ChrisF (VCP4, VCP5, VCP-Cloud) - If you find this or any other answer useful please consider awarding points by marking the answer correct or helpful

View solution in original post

0 Kudos
2 Replies
cfor
Expert
Expert

Took a quick stab...

select top 10 v.id,v.name,v.vapp_name,v.vc_id,v.moref,v.guest_customize_enabled from ui_vapp_vm_list_view v with(NOLOCK)

looks to have if the setting is enabled or not...

ChrisF (VCP4, VCP5, VCP-Cloud) - If you find this or any other answer useful please consider awarding points by marking the answer correct or helpful
0 Kudos
jkasalzuma
Enthusiast
Enthusiast

Thank you cfor!

That got what I needed. Much appreciated!

0 Kudos