...
| 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 IPRange insert Example.xlsx 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.
...
