Web History for a specific IP Address

[Stevomillan]

Hello all, We are running a FortiAnalyzer 100C with 5.0.3. Looking for a SQL script that can output all of the websites visited based upon their ip address and the destination ip address. I can definitely tell that there are logs there by using a SELECT * FROM $LOG command in a blank query window. Any thoughts or suggestions?

[clarkg]

I have one that shows all url traffic for specific user that I specify in the filter part of the report. SELECT $calender_time as f_timestamp, coalesce(nullifna(`user`), `srcip`) as user_src, hostname, catdesc FROM $log WHERE $filter