Sounds like I was doing everything right when I tried the first time.
How do I know I am pointing to the database?
In SQL Server Mgmt Studio I have highlighted my database.
R-Click abd selected "New Query"
Dragged the "getInconsistentVMInfo_mssql.sql" into the window.
The query then contains the Query command listed below. Do I need to modify it in some way?
I click Execute and the Query runs in about 2 sec and does not seem to return any feedback.
The Results Tab says "Query Executed Successfully"
The Messages Tab shows: "(0 row(s) affected)"
Does thsis mean I have no problems with the database?
Thanks again for your assistence.
Query Command:"/* Query for : */
/* a. missing VMs with missing virtual controllers */
/* b. incompatible shares level */
/* c. VMs with non-existent parent file backing IDs */
/* d. VM backing with VMs incorrect device-key */
/* e. VM with snapshot having non-existent parent file backing IDs */
/* f. VM with snapshots that have backing with VMs incorrect device-key */
SELECT T1.ID, T1.NAME FROM VPX_VM_CONFIG_INFO T1 WHERE (T1.ID IN (SELECT T2.ID FROM VPX_VIRTUAL_DEVICE T2 WHERE T2.DEVICE_INFO_LABEL LIKE 'SCSI controller%' AND NOT EXISTS (SELECT 1 FROM VPX_VIRTUAL_SCSICONTROLLER WHERE VDEVICE_ID = T2.VDEVICE_ID)) OR (T1.ID IN (SELECT T2.ID FROM VPX_VIRTUAL_DEVICE T2 WHERE T2.VPX_TYPE LIKE 'vim.vm.device.Virtual%Controller' AND NOT EXISTS(SELECT 1 FROM VPX_VIRTUAL_CONTROLLER WHERE VDEVICE_ID=T2.VDEVICE_ID)))OR ((SELECT ISNUMERIC(CPU_ALLOCATION_SHARES_LEVEL) FROM VPX_VM_CONFIG_INFO WHERE ID=T1.ID) = 1) OR ((SELECT ISNUMERIC(MEM_ALLOCATION_SHARES_LEVEL) FROM VPX_VM_CONFIG_INFO WHERE ID=T1.ID) = 1) OR (T1.ID IN (SELECT DISTINCT(VM_ID) FROM VPX_VDEVICE_FILE_BACKING WHERE FILE_BACKING_PARENT_ID NOT IN (SELECT BACKING_ID FROM VPX_VDEVICE_BACKING_REL))) OR (T1.ID IN (SELECT DISTINCT(VM_ID) FROM VPX_VDEVICE_FILE_BACKING AS T2 WHERE UPDATE_KEY != (SELECT DEVICE_KEY FROM VPX_VIRTUAL_DEVICE WHERE VDEVICE_ID = (SELECT VDEVICE_ID FROM VPX_VDEVICE_BACKING_REL WHERE BACKING_ID = T2.BACKING_ID)))) OR (T1.ID IN (SELECT DISTINCT(VM_ID) FROM VPX_SNAPSHOT WHERE ID IN (SELECT SNAPSHOT_ID FROM VPX_SN_VDEVICE_FILE_BACKING WHERE FILE_BACKING_PARENT_ID NOT IN (SELECT BACKING_ID FROM VPX_SN_VDEVICE_BACKING_REL)))) OR (T1.ID IN (SELECT DISTINCT(VM_ID) FROM VPX_SNAPSHOT WHERE ID IN ( SELECT SNAPSHOT_ID FROM VPX_SN_VDEVICE_FILE_BACKING AS T3 WHERE UPDATE_KEY != (SELECT DEVICE_KEY FROM VPX_SN_VIRTUAL_DEVICE WHERE VDEVICE_ID = (SELECT VDEVICE_ID FROM VPX_SN_VDEVICE_BACKING_REL WHERE BACKING_ID = T3.BACKING_ID))))) );
