Community FAQ
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

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now