Solved

vm deleted date

Posted on 2016-08-18
3
81 Views
Last Modified: 2016-08-21
Developer called me asking me what happen to a server ? Some reason the vm was deleted from the inventory. I went to the data store to see whether I can find anything. I noticed there was the vm folder.
I clicked on to the vmx file to add to the inventory , but it was grayed out. I closed the datastore then tried to go into that the folder VM disappeared.

How do I find this vm deleted date or other evidence? it stumped me, never had this issue.
0
Comment
Question by:sara2000
3 Comments
 
LVL 119

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 41760837
Tasks and Events, will show who deleted it and when (DATE), but that will only show the last 1000 events, if the VM was deleted a while ago, you will have to search the SQL Task and Events tables, on the SQL server, or run a PowerCLI script to check and search Tasks and Events.

https://communities.vmware.com/thread/395643?start=0&tstart=0

http://www.simonlong.co.uk/blog/2009/12/10/need-more-vcenter-tasks-and-events/

https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2009075
0
 
LVL 22

Assisted Solution

by:Luciano Patrão
Luciano Patrão earned 250 total points
ID: 41760872
Hi,

In your SQL DB you can get this information.

Just run a query in your SQL DB (with SQL Studio)

SELECT CREATE_TIME, USERNAME, VM_NAME, HOST_NAME, EVENT_TYPE FROM VCDB.DBO.VPX_EVENT WHERE EVENT_TYPE = ‘vim.event.VmRemovedEvent' AND VM_NAME = ‘VMNAME’

Open in new window


And if you remove the VM name, you can get all VMs that were deleted, date and with the name of the user.

Hope this can help
0
 

Author Comment

by:sara2000
ID: 41764514
The SQL query helped me to identify the information.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Teach the user how to install vSphere Update Manager  Console to Windows system:  Install vSphere Update Manager: Configure vSphere Update Manager plug-in in vSphere Client: Verify vSphere Update Manager settings in vSphere Client:
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question