Ideas to make bulk changes to a lansweeper table.

[tcumming]

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?

[tcumming · Accepted solution]

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!