Hi all, I'd like to create a new report about the total or list of SSLVPN users and proxy users of the day before or N day before. I'm new with the FortiAnalyzer.... could someone help me?
Thank you!
Nominating a forum post submits a request to create a new Knowledge Article based on the forum post topic. Please ensure your nomination includes a solution within the reply.
Create a dataset first before creating the chart:
My Dataset contains the following query:
SELECT a.user_src, a.remip, a.user_grp, a.tunneltype, Min(a.login) AS min_login, Max(b.logout) AS max_logout, Max(b.duration) AS max_duration, Max(b.transferred_bytes) AS max_bandwidth, Max(b.sentbyte) AS max_sent, Max(b.rcvdbyte) AS max_rcvd FROM ###(SELECT COALESCE(nullifna(`user`), ipstr(`remip`)) AS user_src, remip, tunneltype, `group` AS user_grp, min(from_dtime(dtime)) AS login, tunnelid FROM $log-event WHERE $filter AND action IN ('tunnel-up', 'tunnel-stats') GROUP BY tunnelid, user_src, remip, user_grp, tunneltype)### a, ###(SELECT max(from_dtime(dtime)) AS logout, duration, sum(sentbyte+rcvdbyte) AS transferred_bytes, sentbyte, rcvdbyte, tunnelid FROM $log-event WHERE $filter AND action IN ('tunnel-down', 'tunnel-stats') GROUP BY tunnelid, duration, sentbyte, rcvdbyte HAVING sum(sentbyte+rcvdbyte)>0)### b WHERE a.tunnelid=b.tunnelid GROUP BY a.tunnelid, a.user_src, a.remip, a.user_grp, a.tunneltype ORDER BY min_login, a.user_src
Perfect, thank you very much!
And if I want a simple list as below grouped by login date, as I should modify the query?
USER----- USER GROUP ----- TUNNEL TYPE ---- LOGIN DATE -----
Many thanks!
Someone can help me to generate a list of proxy users logins during a time period (today, yesterday...)?
Thanx!
Select Forum Responses to become Knowledge Articles!
Select the “Nominate to Knowledge Base” button to recommend a forum post to become a knowledge article.
User | Count |
---|---|
1536 | |
1029 | |
749 | |
443 | |
210 |
The Fortinet Security Fabric brings together the concepts of convergence and consolidation to provide comprehensive cybersecurity protection for all users, devices, and applications and across all network edges.
Copyright 2024 Fortinet, Inc. All Rights Reserved.