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

Installer Installer - Microsoft Office
by  Florian_Eigsi   Go to last post Go to first unread
Last post: 6/29/2020 3:33:20 PM(UTC)
Installer Firefox ESR 68.8.0 MSI Installer
by  PLSJohnJohn   Go to last post Go to first unread
Last post: 5/11/2020 4:33:50 PM(UTC)
Installer Update Chrome browser with GoogleUpdate.exe ?
by  Inna Ptushkina  
Go to last post Go to first unread
Last post: 5/4/2020 8:39:29 PM(UTC)
Installer Bios Update for Dell all in one
by  Florian_Eigsi   Go to last post Go to first unread
Last post: 4/2/2020 11:36:43 AM(UTC)
Installer Windows 10 Upgrade
by  Michael Kop  
Go to last post Go to first unread
Last post: 3/27/2020 4:47:52 PM(UTC)
Installer Uninstall - Adobe Acrobat 9x
by  palemmo   Go to last post Go to first unread
Last post: 3/25/2020 7:25:05 PM(UTC)
Installer OneDrive Silent Install
by  Steven.C  
Go to last post Go to first unread
Last post: 3/13/2020 2:55:19 PM(UTC)