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
