Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
Dylan
New Contributor

SSL VPN Last Login User Report

I am trying to build a dataset to pull the last time each user has logged in. Best I have been able to get is a report showing each login, but I don't know how to remove the extra (older) dates. Below is the current Dataset I have built.

 

SELECT UPPER(`user`) AS user_src, IPSTR(`remip`) AS remote_ip, TO_CHAR(TO_TIMESTAMP(`itime`)::timestamp, 'YYYY-MM-DD HH24:MI') AS time FROM $log WHERE $filter AND `tunneltype`='ssl-web' AND `action`='tunnel-up' GROUP BY user_src, remote_ip, time ORDER BY user_src, time desc

0 REPLIES 0
Announcements

Select Forum Responses to become Knowledge Articles!

Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.

Labels
Top Kudoed Authors