This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!
Community FAQ
Register | Log In
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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
- How to bulk update a specific field?
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
‎04-22-2016 05:39 PM
We're using LS 6.0. I would like to remove the location lock we have enabled on about 100+ assets. I really don't want to go through one by one and remove it manually. We're using the non-SQL Server version. I tried creating a report and executing an UPDATE query, but it always reports the column is invalid, which I know it's not. Is this possible? Thanks!
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
‎04-25-2016 10:33 AM
On the 'All Assets' page you can 'Mass Edit Assets', however this is not possible for locks (yet). The following query should work and can be run on the Configuration -> Database Scripts page: UPDATE tblAssetCustom set LocationLock = 0
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-26-2016 12:11 AM
The report builder can only be used to query data, not change data. Just an FYI for everyone: always back up your database prior to running any database scripts that change data, just to be safe.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-25-2016 02:41 PM
Okay, that worked perfectly. I didn't know about the Database Scripts page. I was trying to execute it from the Reports page. Thanks!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-25-2016 10:33 AM
On the 'All Assets' page you can 'Mass Edit Assets', however this is not possible for locks (yet). The following query should work and can be run on the Configuration -> Database Scripts page: UPDATE tblAssetCustom set LocationLock = 0
General Discussions
Find answers to technical questions about Lansweeper.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
- show report results in a custom field in General Discussions
- Fill in Custom Fields automatically with data in General Discussions
- LSAgent update on locked down servers in General Discussions
- Filter by AD location in General Discussions
- When does an Asset Radar asset stop being an Asset Radar asset? in General Discussions
