asset mass update

[msperry]

Got the hang of mass updates however is there a way to mass update asset pictures? say I have 60 optiplex 3020's or 15 24" dell monitors that are the same model. Can that be done?

[stuart_white]

https://www.lansweeper.com/forum/yaf_postst15467_Mass-Update-of-Asset-Images.aspx#post52179

I have created a script that makes things a bit easier for mass image updates.

[iboyd]

Has there been any movement on this in the past year?

The workaround listed does not scale very well with over 500 switches

Thanks,
Ian

[Susan_A · Accepted solution]

There is no built-in functionality at the moment for adding asset images to multiple assets at once. This feature is on our customer wish list, but we do not have a release date for it at this time. When you upload an asset image, its name is changed to the asset ID of the asset you're looking at and the file is moved to the Program Files (x86)\Lansweeper\Website\assetpictures folder on your Lansweeper server, as you can see in the screenshots attached to this post. The asset ID (an arbitrary, unique number assigned to each asset) is visible in the URL of the asset page.

The only workaround to add an image to multiple assets without going through each asset is to add the same image multiple times to the Program Files (x86)\Lansweeper\Website\assetpictures folder, with the ID of each asset as the file name. You can use the report below to list the asset IDs of all assets of a specific model. Replace what we've highlighted with the model you would like to report on. Instructions for adding the report to your Lansweeper installation can be found here.

Select Top 1000000 tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID As [Asset ID],
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Model Like '%your model name%' And tblAssetCustom.State = 1