How to Mass activate/deactivate "Lock against scanning"

[Green72]

I've searched but couldn´t find an answer.


Is there a way to massively deactivate "Lock against scanning" of the "Assetname" for all the assets?


Thanks in advance.

[Green72]

That is probably the shortest complete answer i have ever seen here.

Works like a charm. Thanks!

[Daniel_B · Accepted solution]

This can only be done through a database script. Under Configuration\Database scripts, section Database scripts, execute the following SQL code. This will deactivate the asset name lock for all assets in your database. Note: We recommend performing a database backup before running a script here.

UPDATE tblAssets SET AssetNameLock = 0