====== Recording in PCAP, IPFIX Export (Clickstream, DNS, SIP Metadata, FTP) (Service 12)======
{{indexmenu_n>5}}
[[en:dpi:dpi_options:opt_li|Product Description]]
**Example** of generating a clickstream report in CSV format.\\
TOP 50 sites:
cut -f 4 /home/clickstream/url_07* | sort | uniq -c | sort -nr | head -50 | awk '{print $2";"$1}' > top_sites.csv
TOP 50 video sites:
cut -f 4,5 /home/clickstream/url_07* | grep "\.mp4\|\.avi" | cut -f1 | sort | uniq -c | sort -nr | head -50 | awk '{print $2";"$1}' > top_video.csv