Section 4.7 of the iQSonar User Guide refers to using a template to perform a bulk-load of targets into iQSonar. To download the template, go to the Locations screen, go to the top level location (called "Default" in a new instance of iQSonar) and click on "Import > Target Sets Import". In the resulting pop-up, instead of selecting a file to upload, click on the link to download the template. This gives you a blank CSV file like the one in the screenshot:

The columns in the template are as follows:

Column Name	Purpose	Examples
Location Path	Defines the location tree Levels separated by vertical bar character "\|"	Org\|Site1\|Windows Org\|Site1\|Linux Org\|Site2\|Windows Org\|Site2\|Linux
Target	Is this a "Device" or an "Application"	Must contain either "Device" or "Application"
Type	For a "Device" target, valid choices are "Hostname", "Single", "Range" or "Subnet" For an "Appplication" target, valid choices are "vCenter", "Oracle Database Server", "Informix" and "SQL Server"	"Range" has a Start IP and an End IP (e.g. 10.0.0.1 .. 10.0.0.99) "Subnet" has a Start IP and a netmask (e.g. 10.0.0.0 / 24) "Hostname" has a hostname or FQDN (e.g. mail.iquate.com) Single has an IP Address (e.g. 192.168.1.1)
Name	The name for the target definition. If defining a single target, the hostname is a good choice. When defining a range of IP Addresses, the physical location and/or purpose should probably be part of the description	Lab range 1 Lab range 2 hostname
Instance Name	Database Instance - used for defining Oracle, SQL Server or DB2 database applications	MSSQLServer MSSQLEXPRESS ORCL
GUID	This column is only relevant when UPDATING an existing configuration. When you export a config file to edit it, existing entries have a GUID used to identify an existing record.	Leave blank for new entries. DO NOT EDIT for existing entries in an existing file.
Hostname	If defining a Hostname Target, put the hostname or FQDN here. Otherwise leave this blank	mail.iquate.com
Start IP	If defining a hostname target - leave this blank. If defining a single device by IP, or an Application target, put the IP Address here. If defining an IP Address Range or Network, put the first address here	192.168.1.1 10.0.0.1
End IP	If defining an IP Address Range, put the last address in the range here	10.0.0.99
Subnet Mask	If defining a Network, put the netmask here (for example 10.0.0.0/24 gives 10.0.0.0 up to 10.0.0.255) If defining a Single Device or IP Address Range by IP address, or defining an IP Address Range, leave this blank If defining a single device by Hostname, set this to 0	24 0
Port	When defining an Application target, put the port here. (For example a vCenter will be usually scanned on port 443) Oracle Database Instances or MS SQL Server instances where there are multiple instances on a single host may define non-standard ports here.	443
Exclusion	If we are defining a Single IP address or a Range of IP Addresses to not scan, set this to TRUE. Otherwise set it to FALSE A setting of TRUE in this column will mean this target will always be excluded from the scan! Note: You cannot use hostnames as exclusions (A single hostname can resolve to multiple IP Addresses, and an IP Address may have multiple hostnames). To exclude a target you must use an IP Address	TRUE or FALSE

Additional Notes:

The total size of the CSV import file can not exceed 4MB.

Browser not supported