Solved

vm deleted date

Posted on 2016-08-18
3
72 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 118

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

It Is not possible to enable LLDP in vSwitch(at least is not supported by VMware), so in this article we will enable this, and also go trough how to enabled CDP and how to get this information in vSwitches and also in vDS.
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…
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 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:

895 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now