Create a target set import file
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 "Hostname" has a hostname or FQDN 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 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.