Solved

vm deleted date

Posted on 2016-08-18
3
103 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 121

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 23

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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
Teach the user how to edit .vmx files to add advanced configuration options Open vSphere Web Client: Edit Settings for a VM: Choose VM Options -> Advanced: Add Configuration Parameters:

717 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