How to check the user last login detail on the netezza database?

Here is the script to check the user last login detail.

connect to history DB and execute this query.

select username, max(time) from "$v_hist_log_events" where op_type ='session create' group by username order by 1;