Differences

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

--- tips:bulkqstreamflow [2024/08/05 16:38] – [Script] veera
+++ tips:bulkqstreamflow [2024/11/06 13:25] (current) – [Script] veera
@@ Line 1: / Line 1: @@
-====== Bulk Query ======
+====== Bulk Query ipdr_bulkquery.sh ======
-This script works with the following input
+This script is included with the Trisul Hub IPDR package.  The purpose of this script is to allow our IPDR Customers to enter hundreds of IPs at once. Without this it can be tedious to enter each IP separately into the IPDR Web Form.
+<note important> **XLSX format not available** The drawback is the XLSX format is not supported in this mode. However you can use the CSV files to create a XLSX easily. We recommend you simply use the TXT report format</note>
+This works on the following input
   * Single Timeframe
   * A file containing a list of IP one per line
-===== Script =====
+===== Script Location  =====
+The ''ipdr_bulkquery.sh'' script is available in the ''/usr/local/share/trisul-hub'' directory.
+===== IP List =====
+Create a file called ''iplist1.txt'' and put all IPs you wish to query in that list
+<code bash>
+#one per line
+.43.23.1
+.23.44.55
+.23.55.123
+.178.21.139
+</code>
+===== Run the script  =====
+Say you placed the ''ipdr_bulkquery.sh'' script and the ''iplist1.txt'' in the ''/root'' directory. You can run it like this
+<code lang='bash'>
+./ipdr_bulkquery.sh  -f 1-8-2024-13:00 -t 1-8-2024-13:30   -i /root/iplist1.txt
+</code>
+===== Output =====
+The output will be placed by default into a subdirectory in ''/tmp'' (use the -o option  to specify a different directory)
+The subdirectory will have the format ''ipdrresults-1722851578'' where the number part is a timestamp.
+Inside the subdirectory there will be files containing the IPDR query results. You can copy these files over.
+ <code bash>
+root@ipdradmin:/usr/local/share/trisul-hub# ls -l /tmp/ipdrresults-1722851578
+total 40880
+-rw-r--r-- 1 root root      230 Aug  5 15:22 queryresults.103.84.86.10
+-rw-r--r-- 1 root root        0 Aug  5 15:22 queryresults.103.84.86.10.csv
+-rw-r--r-- 1 root root      230 Aug  5 15:23 queryresults.7.7.7.7
+-rw-r--r-- 1 root root        0 Aug  5 15:23 queryresults.7.7.7.7.csv
+-rw-r--r-- 1 root root 26485607 Aug  5 15:23 queryresults.8.8.4.4
+-rw-r--r-- 1 root root 15360273 Aug  5 15:23 queryresults.8.8.4.4.csv
+root@ipdradmin:/usr/local/share/trisul-hub#
+</code>
-Copy the ipdr_bulkquery.sh script from https://raw.githubusercontent.com/trisulnsm/trisul-scripts/master/bash/ipdr_bulkquery.sh