Notification

Icon
Error

Bulk AssetLock set

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

tcooper

Member Original PosterPosts: 17
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,976  
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 Lansweeper Webserver Error
by  Bruce.B   Go to last post Go to first unread
Last post: Today at 3:19:01 AM(UTC)
Lansweeper LsAgent install issue
by  Susan.A  
Go to last post Go to first unread
Last post: Yesterday at 8:46:19 PM(UTC)
Lansweeper Is a Common Table Expression possible?
by  PatrickWolf   Go to last post Go to first unread
Last post: Yesterday at 6:52:24 PM(UTC)
Lansweeper Tracking assets like docking station, mouse and keyboards
by  cycleheat  
Go to last post Go to first unread
Last post: Yesterday at 5:00:39 PM(UTC)
Lansweeper Update to V. 7.2.107.4
by  cycleheat   Go to last post Go to first unread
Last post: Yesterday at 4:57:38 PM(UTC)
Lansweeper Windows Defender AV
by  Rob B  
Go to last post Go to first unread
Last post: Yesterday at 4:55:19 PM(UTC)
Lansweeper Scan Server Scanning wrong IP range
by  wayneRex   Go to last post Go to first unread
Last post: Yesterday at 3:49:36 PM(UTC)
Lansweeper Lansweeper support levels
by  RobertB  
Go to last post Go to first unread
Last post: 1/23/2020 10:39:05 PM(UTC)