Customized FAZ Charts

[Silver]

Dear All,

Anyone can help to customized FAZ charts as per my requirement.

a) Top 100 Users per bandwidth for allowed websites

b) Top 100 Users per bandwidth / Apps

c) Top 100 blocked websites per users

Thanks!

[AtiT]

Hello,

What is the FAZ version you are using?

[AtiT]

Hello,

You can try:

a) Top 100 Users per bandwidth for allowed websites

log type: Web Filter SELECT COALESCE(NULLIFNA(UPPER(`user`)), IPSTR(`srcip`)) AS user_src, SUM(COALESCE(`sentbyte`, 0)) AS traffic_out, SUM(COALESCE(`rcvdbyte`, 0)) AS traffic_in, SUM(COALESCE(`sentbyte`, 0)+COALESCE(`rcvdbyte`, 0)) AS bandwidth FROM $log WHERE $filter AND `action`='passthrough' GROUP BY user_src ORDER BY bandwidth DESC LIMIT 100 b) Top 100 Users per bandwidth / Apps log type: Traffic SELECT COALESCE(NULLIFNA(UPPER(`user`)), IPSTR(`srcip`)) AS user_src, `appid`, COALESCE(NULLIFNA(`app`),'Unknown Application') AS app_name, SUM(COALESCE(`rcvdbyte`, 0)) AS traffic_in, SUM(COALESCE(`sentbyte`, 0)) AS traffic_out, SUM(COALESCE(`sentbyte`,0)+COALESCE(`rcvdbyte`,0)) AS bandwidth FROM $log WHERE $filter AND LOGID_TO_INT(`logid`) NOT IN (4, 7, 14) AND `utmaction`='passthrough' AND NULLIFNA(`app`) IS NOT NULL GROUP BY user_src, `appid`, app_name HAVING SUM(COALESCE(`sentbyte`,0)+COALESCE(`rcvdbyte`,0))>0 ORDER BY bandwidth DESC LIMIT 100

c) Top 100 blocked websites per users

what do you exatly expecting? For every single user top 100 blocked sites? Or only top 100 Users blocked.

[Silver]

Hi,

Thank you for your reply. FAZ version 5.2.2

[Silver]

Hi,

I have created a dataset and the following  below output;

a) create dataset and while test no web url found only user / bandwidth in/out

b) create dataset and while test no data found

c) I would like to get all  block website for each users 

awaiting your reply

Thanks