cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
AuxMax
Engaged Sweeper
I'm attempting to import a ton of locations into Lansweeper via a SQL script.

I'm inserting the data into the tsysIPLocations table and the script executes without error. I refresh table from within SQL Studio and I see the additional rows. However, I can not see the added locations from within Lansweeper configuration GUI.

So, I suspect I've botched the import data, specifically, the StartIP and EndIP fields. I know that these fields are numerical converts of the RealStart and RealEnd. Are these created by substituting "." for "0" or some other scheme?

Thanks

2 REPLIES 2
Hemoco
Lansweeper Alumni
10.0.0.0 =
010.000.000.000=
010000000000

123.123.123.123=
123123123123


10.2.200.2=
010.002.200.002=
010002200002
AuxMax
Engaged Sweeper
Well, I had tried this earlier with no success, but I just did it again. Only this time, I closed out of the Lansweeper Configuration and re-open it. Now, it's there. Go figure.

Thanks for the assistance.





Lansweeper wrote:
10.0.0.0 =
010.000.000.000=
010000000000

123.123.123.123=
123123123123


10.2.200.2=
010.002.200.002=
010002200002