Bulk AssetLock set

[tcooper]

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]

Pretty simple script you can use 😉

Backup your database first, then:

  Update tblAssets
  set AssetTypeLock = 0

This will uncheck them all.