Data export [Документация VAS Experts]

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
en:dpi:dpi_components:qoestor:data_export:start [2023/08/29 07:46] edrudichgmailcomen:dpi:dpi_components:qoestor:data_export:start [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
Line 1: Line 1:
-===== Data export ===== 
-{{indexmenu_n>5}} 
- 
-If necessary, you can independently generate your own reports without additional tools and upload data in any CSV, JSON, TabSeparated format.  
- 
-Data is stored in 4 main logs  
-  * qoestor.fullflow – full netflow log, storage period - 2 hours by default 
-  * qoestor.clicksteam – full clickstream log, storage period - 2 hours by default 
-  * qoestor.fullflow_agg – pre-aggregated netflow log, storage period - 14 days by default  
-  * qoestor.clicksteam_agg – pre-aggregated clickstream log, storage period - 14 days by default  
- 
-The command format is as follows <code>clickhouse-client --database=qoestor  --query="Your sql is here"</code> 
- 
-By default data is uploaded in TabSeparated format. 
- 
-**Example**. The client asked for a log of connections to a specific host in CSV format  
- 
-<code>clickhouse-client --database=qoestor --query="select * from fullflow prewhere flow_start_date = '2018-10-04' where (source_ipv4 = '10.64.66.100' or destination_ipv4 = '10.64.66.100') and host = 'google.com' ORDER BY flow_start_time limit 10 format CSV"</code> 
- 
-For detailed information on SQL ClickHouse, see the link [[https://clickhouse.com/docs/en/sql-reference/statements/select/]] 
-