Link to home
Start Free TrialLog in
Avatar of Stan J
Stan JFlag for United States of America

asked on

Does the vpxd.log contain the VCSA postgres DB table with tasks and events info?

I am in a conversation with VMware support about events and logs in order to locate a reason why users were removed from vCenter tied to users in a domain managed with  LDAP


I looked at the events in vCenter and could not see any indication of users be ing removed.


I extracted vCenter logs from vCenter  by clicking on the "Export system Logs"  in the Web Client.  This generated the large .tgz file.  


I uploaded the logs to support hoping they would extract the and analyze the logs especially the vpxd.log which I though had the same events that are recorded in the VCSA postgres DB.


However, support says that events are not part of the exported logs I uploaded?


They say i have to login to the VCSA postgres DB and look at the table with tasks/events.


Does the vpxd.log contain the VCSA postgres DB tasks and events?



ASKER CERTIFIED SOLUTION
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Stan J

ASKER

The events happened about Oct 6.


From vSphere DOC,,,
Retention of Events in the vCenter Server Database
..the event clean up option is enabled by default and the default number of days to retain event messages in the database is 30. You can change this value to the number of days that you want to retain the event messages in the database. .  
 
I had PoweCLI working in June on my Windows Remote Desktop, but now it no longer is working.

I can access the DB,.
 
I had PoweCLI working in June on my Windows Remote Desktop, but now it no longer is working.

You may be in luck, use PowerCLI/Powershell (fix it, Open a new EE question), far easier in my experience running queries via Powershell, and useful tools in the VMware Admin toolbox.

I can access the DB,.

You have all the tools, to look for the data.

In my experience, it does not reveal much!

Does this answer you question posted on EE ?