====== Bulk Query ipdr_bulkquery.sh ======



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 =====

Copy the ''ipdr_bulkquery.sh'' script from https://raw.githubusercontent.com/trisulnsm/trisul-scripts/master/bash/ipdr_bulkquery.sh


You may have to change permissions to make it executable.

<code bash>
chmod +x ipdr_bulkquery.sh
</code>

===== IP List =====

Create a file called ''iplist1.txt'' and put all IPs you wish to query in that list 

<code bash>
#one per line 
203.43.23.1
22.23.44.55
87.23.55.123
78.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>