Thursday, 7 November 2013

VMware - vSphere DB queries

Looking for who kicked off a snapshot sometime in the past?

VMware KB2009075 gives you an idea on how to find out.

Will post more once I have played around with it a bit longer!

UPDATE - 14th November 2013

My amended query from the VMware default (as I'm looking for actual 'user' accounts and not system) is.

select task_id, parent_task_id, start_time, username, complete_time, entity_name, descriptionid, complete_state
from VPX_TASK
where USERNAME != ''
and USERNAME NOT IN ('DOMAIN\backup','DOMAIN\anotherservice')


I'm looking at narrowing the search down to a date which will require further investigation. 
Sites that might help with that are:
http://www.w3schools.com/
 

No comments:

Post a Comment