This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- General Discussions
- Re: Mass Update
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2015 02:46 PM
Hello, I was wondering if there was a way to mass update assets that are related to each other as opposed to going into each one individually. For example, if I had 10 PC's that had all the same Model number and I wanted to use the same asset picture for each one, is there a way I could deploy the picture to update each asset with the matching Model number?
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2015 06:27 PM
For certain fields you are able to perform updates by
- opening Assets
- filtering for relevant assets and selecting them
- hitting Mass change
- insert the updates you would like to apply to the assets
However, this won't work for the asset picture unfortunately.
- opening Assets
- filtering for relevant assets and selecting them
- hitting Mass change
- insert the updates you would like to apply to the assets
However, this won't work for the asset picture unfortunately.
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-11-2015 10:56 AM
This is possible through a database script, but we don't offer support for creation of these. However, this would be a very easy one, because both fields are stored in the same table so you could create a script which updates tblAssetCustom.BarCode on assets having the right serialnumber in tblAssetCustom.Serialnumber. Alternatively use one of the custom fields for your asset tag. Before running database scripts, perform a backup of your database.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2015 09:39 PM
Just curious, is there a way to import my companies asset tag onto the assets? I am in the process of ID'ing all of the IT assets through Lansweeper since they havent had an asset system before, I have a spreadsheet of what they think is in the install base, so I want to pull the asset tag based on serial number into LS. Is this doable?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2015 03:24 PM
Thanks Dan, big help as always.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-10-2015 02:14 PM
Lansweeper has an asset import feature, but this only works for assets which don't already exist in your database. Please find details here. Updating existing assets from and XLS sheet is not supported.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2015 08:05 PM
Thanks for the reply, one more question.
Say I export abour 40 assets to an excel file and in the report I just set it to show descriptions and asset name. Can I go into the excel file, add the descriptions I want, save it as a CSV file and import it into lan sweeper in hopes that it will add these descriptions?
Say I export abour 40 assets to an excel file and in the report I just set it to show descriptions and asset name. Can I go into the excel file, add the descriptions I want, save it as a CSV file and import it into lan sweeper in hopes that it will add these descriptions?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-09-2015 06:27 PM
For certain fields you are able to perform updates by
- opening Assets
- filtering for relevant assets and selecting them
- hitting Mass change
- insert the updates you would like to apply to the assets
However, this won't work for the asset picture unfortunately.
- opening Assets
- filtering for relevant assets and selecting them
- hitting Mass change
- insert the updates you would like to apply to the assets
However, this won't work for the asset picture unfortunately.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now