Last Login Time for a user

 You can increase your retention policy of the dc table.(but watch the space used).

SELECT get_data_collector_policy('SessionEnds');
get_data_collector_policy                                                  
-------------------------------------------------------------------------  
100KB kept in memory, 5000KB kept on disk. Time based retention disabled. 


SELECT set_data_collector_time_policy('SessionEnds', '7 day'::interval);
set_data_collector_time_policy  
------------------------------  
SET       


SELECT get_data_collector_policy('SessionEnds');
get_data_collector_policy                                        
---------------------------------------------------------------  
100KB kept in memory, 5000KB kept on disk. 7 days kept on disk.  

Or you can query your vertica.log for the user connection:

cat vertica.log|grep "Connection authenticated:" | grep username

- you will need to do in all nodes to get the latest.

Thanks Adrian. 

This helps me completely.

Regards

Aadu