...
| Code Block |
|---|
| language | sql |
|---|
| theme | Eclipse |
|---|
| title | MapIPRange_Server |
|---|
|
INSERT INTO MapIPRange_Server (_ServerID, IPrangeID)
SELECT 1, IPRangeID FROM IPRange WHERE IPRangeID NOT IN (SELECT IPRangeID FROM MapIPRange_Server) |
Attached Insert IP Ranges into iQSonar Database directly. 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) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | CSKB |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label in ("v3","iprange") and type = "page" and space = "CSKB" |
|---|
| labels | v3 iprange |
|---|
|
