Cleaning up some LUNs so I can resize them and after rebalancing all the pools the LUN I was going to remove still had some folders on it.  Most of the folders only contained a .hlog file, but a few replica folders still existed and those are a reason for concern.  Using the following SQL commands you can determin if the VM associated with the replica folders still exist, and what VM it is or was in some cases.

SELECT *

FROM [vmwvdb].dbo.VPX_ENTITY

where [NAME] ='replica-xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'

Copy the ID for use in the next query as 'VM-###'

SELECT *

FROM [vmwv composer db].dbo.SVI_REPLICA

where [REPLICA_MOID] = 'VM-###'

Copy the Replica_ID for use in next query

SELECT [VM_NAME]

,[GUEST_COMPUTER_NAME]

,[REPLICA_ID]

FROM [vmwv composer db].dbo.SVI_SIM_CLONE

where [REPLICA_ID] ='11111111-aaaa-1111-aaaa-111111111111'

You should now have the VM name if it still exists in the database.