Logid_to_int(logid) not in (4, 7, 14) and ((logver>=52 and countweb>0) Sum(coalesce(sentbyte, 0)+coalesce(rcvdbyte, 0)) as bandwidth Select coalesce(nullifna(`user`), ipstr(`srcip`)) as user_src,ĭtime, catdesc, hostname, utmaction as action, I hate unanswered questions on a forum like this…įrom_dtime(dtime) as timestamp, user_src, catdesc, hostname as website,Īction as status, sum(bandwidth) as bandwidth This is an awesome question and would be an incredible report to have right? Well, CrisP replied with an incredible solution to this issue. Has anyone tried this or any tips on what I need to do. I have had a look at the datasets but my SQL coding is not to good For example a report that lists user name, source IP, date time, url for the “Explicit Violence” category. I want to create a report that allows me to select a category and then to list all the activity for users where the URLS match that category. Ian on Fortinet’s forums asked a good question.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |