AnsweredHot!How to create a report policy usage

Author
vincla
New Member
  • Total Posts : 3
  • Scores: 0
  • Reward points: 0
  • Joined: 2019/05/29 04:03:28
  • Status: offline
2019/05/29 04:11:07 (permalink)
0

How to create a report policy usage

Hello ,
 
I want create a report in Forti Analyser to see if a policy is used or hit, so that i can remove the unused policies.
 
Kind Regards,
 
Vincent
 
#1
brazz_FTNT
Silver Member
  • Total Posts : 71
  • Scores: 20
  • Reward points: 0
  • Joined: 2018/02/20 15:09:34
  • Status: offline
Re: How to create a report policy usage 2019/05/29 07:45:47 (permalink)
0
Hey, 
 
I am suggesting something like below:
 
SELECT policyid AS MyPolicyID , COUNT(*) AS MyPolicyHitCount, devid AS MyDeviceID FROM $log WHERE $filter GROUP BY MyPolicyID, MyDeviceID ORDER BY MyPolicyHitCount DESC
 
*Log Type is Traffic.


Let me know what you think.
 
Cheers
#2
vincla
New Member
  • Total Posts : 3
  • Scores: 0
  • Reward points: 0
  • Joined: 2019/05/29 04:03:28
  • Status: offline
Re: How to create a report policy usage 2019/05/29 08:33:09 (permalink)
0
Hello brazz_FTNT,
 
I will try that, thanks for your reply.
I will let you when it works.
 
 
Regards,
 
Vincent
#3
Leen
New Member
  • Total Posts : 5
  • Scores: 1
  • Reward points: 0
  • Joined: 2007/05/08 05:48:09
  • Status: offline
Re: How to create a report policy usage 2019/05/29 18:52:25 (permalink) ☼ Best Answerby Mod_FTNT 2019/05/29 20:39:47
4 (1)
In Fortianalyser menu FortiView, select under traffic "Policy hits"
make your selections on time frame
Now top right you can export to report chart. This will export the current SQL query as a report chart which you can use in any report.
 
Leen
#4
vincla
New Member
  • Total Posts : 3
  • Scores: 0
  • Reward points: 0
  • Joined: 2019/05/29 04:03:28
  • Status: offline
Re: How to create a report policy usage 2019/06/05 04:15:35 (permalink)
0
Thank you very much that is the report i was looking for :-)
 
Regards,
 
Vincent
#5
Jump to:
© 2019 APG vNext Commercial Version 5.5