Unlock Exclusive Benefits
Join Our Community Today!
Join our community and post in the forum to earn your exclusive Spring Badge! Become a member today!
LOGIN/REGISTER
CONTINUE AS A GUEST
- Support Forum
- Knowledge Base
- Customer Service
- Internal Article Nominations
- FortiGate
- FortiClient
- FortiADC
- FortiAIOps
- FortiAnalyzer
- FortiAP
- FortiAuthenticator
- FortiBridge
- FortiCache
- FortiCarrier
- FortiCASB
- FortiConverter
- FortiCNP
- FortiDAST
- FortiDDoS
- FortiDB
- FortiDNS
- FortiDLP
- FortiDeceptor
- FortiDirector
- FortiDevSec
- FortiEdgeCloud
- FortiEDR
- FortiExtender
- FortiGate Cloud
- FortiGuard
- FortiHypervisor
- FortiGuest
- FortiInsight
- FortiIsolator
- FortiMail
- FortiMonitor
- FortiManager
- FortiNAC
- FortiNAC-F
- FortiNDR (on-premise)
- FortiNDRCloud
- FortiPAM
- FortiPhish
- FortiPortal
- FortiPresence
- FortiSRA
- FortiProxy
- FortiRecon
- FortiRecorder
- FortiScan
- FortiSandbox
- FortiSASE
- FortiSIEM
- FortiSOAR
- FortiSwitch
- FortiTester
- FortiWAN
- FortiToken
- FortiVoice
- FortiWeb
- FortiAppSec Cloud
- RMA Information and Announcements
- Lacework
- Wireless Controller
- FortiCloud Products
- ZTNA
- 4D Documents
- Customer Service
- Community Groups
- Blogs
Support Forum
The Forums are a place to find answers on a range of Fortinet products from peers and product experts.
- Fortinet Community
- Support Forum
- Need to generate Custom query based report
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need to generate Custom query based report
Hi all,
I need to generate custom query based reports in FortiAnalyzer for below subjects:
- User wise site wise time spent on the web site for a period - User wise total Internet access time for a period
I need custom SQL Query to generate it. Please help me to generate it.
-Kathan
0 REPLIES 0
Labels
-
FortiGate
9,650 -
FortiClient
1,972 -
FortiManager
821 -
5.2
801 -
5.4
639 -
FortiAnalyzer
635 -
FortiSwitch
533 -
FortiAP
522 -
FortiClient EMS
493 -
6.0
416 -
5.6
362 -
FortiMail
352 -
SSL-VPN
319 -
IPsec
296 -
6.2
251 -
FortiNAC
235 -
FortiAuthenticator v5.5
234 -
FortiWeb
230 -
5.0
196 -
SD-WAN
154 -
FortiGuard
153 -
FortiAuthenticator
141 -
6.4
128 -
Firewall policy
116 -
FortiGateCloud
109 -
FortiSIEM
108 -
FortiCloud Products
105 -
FortiToken
97 -
Wireless Controller
90 -
Customer Service
83 -
FortiProxy
72 -
High Availability
72 -
FortiGate-VM
66 -
4.0MR3
64 -
FortiEDR
64 -
ZTNA
64 -
Fortivoice
63 -
Routing
61 -
FortiADC
60 -
VLAN
60 -
DNS
58 -
SAML
55 -
BGP
55 -
Authentication
54 -
RADIUS
51 -
LDAP
50 -
FortiSandbox
49 -
NAT
48 -
FortiExtender
47 -
Certificate
46 -
SSO
45 -
FortiDNS
43 -
FortiLink
41 -
FortiGate v5.4
37 -
Application control
37 -
FortiSwitch v6.4
35 -
VDOM
35 -
Logging
35 -
Interface
34 -
FortiConnect
32 -
FortiWAN
31 -
Web profile
30 -
FortiPAM
29 -
Virtual IP
29 -
FortiGate v5.2
27 -
FortiConverter
27 -
SSL SSH inspection
25 -
FortiPortal
23 -
Traffic shaping
23 -
FortiGate Cloud
22 -
Automation
22 -
Static route
22 -
FortiSwitch v6.2
20 -
SNMP
20 -
SSID
20 -
WAN optimization
19 -
FortiMonitor
18 -
System settings
17 -
OSPF
16 -
API
16 -
FortiDDoS
15 -
Admin
15 -
Security profile
15 -
Web application firewall profile
15 -
IP address management - IPAM
15 -
FortiGate v5.0
14 -
FortiSoar
14 -
FortiCASB
14 -
IPS signature
14 -
FortiAP profile
14 -
Proxy policy
13 -
Intrusion prevention
13 -
Traffic shaping policy
12 -
Web rating
12 -
FortiManager v5.0
11 -
FortiManager v4.0
11 -
FortiRecorder
11 -
Explicit proxy
11 -
FortiWeb v5.0
10 -
FortiBridge
10 -
Traffic shaping profile
10 -
Fabric connector
10 -
Port policy
10 -
4.0MR2
9 -
FortiGate v4.0 MR3
9 -
FortiAnalyzer v5.0
9 -
DNS filter
9 -
Users
9 -
FortiDeceptor
8 -
FortiCache
8 -
RMA Information and Announcements
8 -
trunk
8 -
Antivirus profile
8 -
Fortinet Engage Partner Program
8 -
4.0
7 -
Authentication rule and scheme
7 -
FortiToken Cloud
6 -
Packet capture
6 -
NAC policy
6 -
Application signature
6 -
FortiCarrier
5 -
FortiScan
5 -
FortiTester
5 -
DLP profile
5 -
DoS policy
5 -
Email filter profile
5 -
VoIP profile
5 -
Cloud Management Security
5 -
3.6
4 -
FortiDirector
4 -
Internet service database
4 -
DLP sensor
4 -
Netflow
4 -
Protocol option
4 -
TACACS
4 -
Replacement messages
4 -
SDN connector
4 -
Service
4 -
Multicast routing
4 -
FortiDB
3 -
FortiHypervisor
3 -
FortiNDR
3 -
DLP Dictionary
3 -
Multicast policy
3 -
Vulnerability Management
3 -
FortiInsight
2 -
FortiAI
2 -
Kerberos
2 -
Video Filter
2 -
File filter
2 -
Schedule
2 -
Zone
2 -
FortiEdge Cloud
2 -
FortiGuest
2 -
4.0MR1
1 -
FortiManager-VM
1 -
FortiCWP
1 -
Subscription Renewal Policy
1 -
ICAP profile
1 -
Virtual wire pair
1 -
FortiEdge
1
Top Kudoed Authors
| User | Count |
|---|---|
| 2243 | |
| 1218 | |
| 771 | |
| 451 | |
| 366 |
Broad. Integrated. Automated.
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.
Security Research
Company
News & Articles
Copyright 2025 Fortinet, Inc. All Rights Reserved.