...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
INSERT INTO MapIPRange_Server (_ServerID, IPrangeID) SELECT 1, IPRangeID FROM IPRange WHERE IPRangeID NOT IN (SELECT IPRangeID FROM MapIPRange_Server) |
Attached IPRange insert Example.xlsx can be used to create a bulk insert, below instructions should be used with this document and contain information on how to make changes. The resulting SQL code should be run against the IQData Database.
- Populate Column B with the required StartIP
- Populate Column D with the required EndIP
- IPRange Type is set to Range, if this is needed to be changed replace the word 'range' in Column E with 'subnet'
- Service Type is set to Port Discovery, if this is required to be changed replace 'Discovery.Port' in Column E with 'Discovery.ICMP'
- Populate Column F with the Location.Name appropriate to the IPRange from the Location table.
- Populate Column H with a description for the location, this is a free text field and can contain any string.
Once the above has been completed, copy column K and paste it into Sql Server Management Studion
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...