12-19-2023 10:12 PM
I inherited a local lansweeper installation, and found that over the years hundreds of assets have had their locations carefully entered for about a dozen different locations.
Unfortunately, the images they used for the base image for each location is too small, and all of the asset tags are on top of each other. It's so bad that "toggle asset names" doesn't help much.
I would like to upload new base images that are of higher quality and much larger so I can spread out the asset tags. If I keep the aspect ratio of the base image the same as the original, I should be able to take the posX/posY coordinates from the tblAssetRelations table and multiply them with some multiplier and push them back into the table. Easy-peasy.
I'm hoping someone would know the best way to do this.
Since this is a one-off change (i.e., likely never done again), it can be as hackish as need be.
Ideas?
Solved! Go to Solution.
12-20-2023 01:02 AM
You will need the password for the lansweeper database
On imageserver command line:
sqlcmd -S IMAGESERVER\SQLEXPRESS -U sa -P
go
<It will ask for your password>
use lansweeperdb
go
select posx,posy from tblassetrelations
go
<You will get a list of x/y positions to show your on the right track>
update tblassetrelations set posx=posx*2, posy=posy*2 where posx is not null
go
exit
That's it!
12-20-2023 01:02 AM
You will need the password for the lansweeper database
On imageserver command line:
sqlcmd -S IMAGESERVER\SQLEXPRESS -U sa -P
go
<It will ask for your password>
use lansweeperdb
go
select posx,posy from tblassetrelations
go
<You will get a list of x/y positions to show your on the right track>
update tblassetrelations set posx=posx*2, posy=posy*2 where posx is not null
go
exit
That's it!
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now