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

[jkasalzuma]

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

[cfor · Accepted solution]

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...

[jkasalzuma]

Thank you cfor!

That got what I needed. Much appreciated!