Success.... I went back to revisit the KB again https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2144269 And tried to see why the additional...
See more...
Success.... I went back to revisit the KB again https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2144269 And tried to see why the additional step of logging into postgres and updating the table didn't actually run the way it should have. As a side note the Readme file for the KB doesn't include the semi colon at the end of the command line ( ; ) - which can throw you if your new to updating stuff in postgres. This time I used the machine name from the expiry email instead of the actual VM which was listed in VRA. So for each of the machines which were being listed in the email I did the following : SELECT * FROM cat_resource WHERE name='Windows 10-99832872'; Notice the Status is PENDING_APPROVAL Run the update command as per the KB - I ignored the Tenant bit. Updated now to Deleted. Once I completed that on all machines I can then do a select again and it now shows the six original machines now with a request_id nulled out from previous commands but the status is now set to deleted. This status must stop whatever background process for expiry is trying to occur - Once they were changed the emails stopped. Yippeee !!!! So perhaps the whole nulling the ID and trying to delete the references were all a bit pointless - following the KB ( with a bit more info ) looks to solve the issue. Thanks everybody for your input - I hope this post helps other people with similar issues in the future.