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 "add cc user" doesn't show the correct listings
by  JLPingree   Go to last post Go to first unread
Last post: Yesterday at 8:12:44 PM(UTC)
Lansweeper Default User Date Format
by  RickW99456  
Go to last post Go to first unread
Last post: Yesterday at 5:00:51 PM(UTC)
Lansweeper Duplicate assets (Servers)
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 3:20:28 PM(UTC)
Lansweeper Lansweeper load the disk subsystem
by  Alexey Gorbachev  
Go to last post Go to first unread
Last post: Yesterday at 3:13:17 PM(UTC)
Lansweeper Lost Configuration tab (Admin rights)
by  kspap   Go to last post Go to first unread
Last post: Yesterday at 10:30:12 AM(UTC)
Lansweeper Deployment with different user rights
by  Jupiter_IT  
Go to last post Go to first unread
Last post: Yesterday at 9:39:20 AM(UTC)
Lansweeper cisco fuji device not linking with connected devices
by  char   Go to last post Go to first unread
Last post: 7/5/2020 9:12:07 AM(UTC)
Lansweeper Microsoft CVE-2020-1425
by  Richard_B  
Go to last post Go to first unread
Last post: 7/3/2020 4:29:41 PM(UTC)