====== Recording in PCAP, IPFIX Export (Clickstream, DNS, SIP Metadata, FTP) (Service 12)======
{{indexmenu_n>5}}
<note>[[dpi:dpi_options:opt_li|Product Description]]</note>
<accordion autoclose>
<accordion-item title="1. Example of generating a report in CSV format based on clickstream">
**Example** of generating a clickstream report in CSV format.\\ 
TOP 50 sites: 
<code bash>cut -f 4 /home/clickstream/url_07* | sort | uniq -c | sort -nr | head -50 | awk '{print $2";"$1}' > top_sites.csv</code>
  
TOP 50 video sites:
<code bash>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</code>

</accordion-item>
</accordion>