Notification

Icon
Error

Bulk AssetLock set

Posted: Friday, December 13, 2019 6:24:15 PM(UTC)
tcooper

tcooper

Member Original PosterPosts: 18
0
Like
Looking at a report, it looks like we have over 1000 devices with their assettypelock set to True. Is there a way to bulk set them to false or do I need to go to each device individually?
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 12/16/2019 11:14:20 AM(UTC)
Pretty simple script you can use ;)

Backup your database first, then:

Code:

  Update tblAssets
  set AssetTypeLock = 0


This will uncheck them all.

Active Discussions

Lansweeper All USB devices connected
by  RC62N  
Go to last post Go to first unread
Last post: Yesterday at 6:40:58 PM(UTC)
Lansweeper Software audit with installation date
by  RC62N   Go to last post Go to first unread
Last post: 7/3/2020 3:39:41 PM(UTC)
Lansweeper Duplicates (3-4) in report please helppppp!
by  AlexMZetec  
Go to last post Go to first unread
Last post: 7/2/2020 3:15:16 PM(UTC)
Lansweeper Report to find all computers with no logon data
by  Andy.S  
Go to last post Go to first unread
Last post: 7/2/2020 9:55:53 AM(UTC)
Lansweeper Change processes report to show opposite results
by  RC62N   Go to last post Go to first unread
Last post: 6/29/2020 9:38:46 PM(UTC)
Lansweeper Keep link to items when using column names
by  Tom Galvin  
Go to last post Go to first unread
Last post: 6/27/2020 12:16:03 AM(UTC)