Here is what I did. I followed the VMware Knowledge Base
But end up spending 2 hours how to write SQL query.
Below might help you. But remember the prefix.
SELECT a.ModuleAndEventText,a.Time
From dbo.Event_event_historical a
INNER JOIN
(SELECT ModuleAndEventText,
MAX(Time) as Time
from dbo.Event_event_historical
GROUP BY ModuleAndEventText
) AS b
ON a.ModuleAndEventText = b.ModuleAndEventText
AND a.Time = b.Time
WHERE EventType = 'Agent_CONNECTED';
You get the output since the view environment was built.
Export result in Excel sheet anf filter by the year.
You will need do little excel trick to remove the duplicate users.
