Notification

Icon
Error

Add data to custom attributes to many assets

Posted: Wednesday, October 9, 2019 11:06:44 AM(UTC)
FixitDave

FixitDave

Member Original PosterPosts: 51
0
Like
I need to add custom attribute data to around 420 assets.

Is there a quicker way other than search, edit, change, save, repeat.
Esben.D
#1Esben.D Member Administration Posts: 1,982  
posted: 10/10/2019 1:13:08 PM(UTC)
Scripting it with an SQL update script would be the easiest method. If you grab a list of all the asset IDs of the machines you need to update it would go something like:

Update tblassetcustom
set Custom1 = 'YourValue'
where assetid IN (1,2,3,4,5,6,7)

Active Discussions

Action Find lost space the easy way (spacesniffer.exe)
by  krozar   Go to last post Go to first unread
Last post: 5/5/2020 10:27:33 PM(UTC)
Lansweeper Querying a web server or web services
by  mmo  
Go to last post Go to first unread
Last post: 5/5/2020 9:00:36 PM(UTC)
Action Password Status
by  brodiemac-too   Go to last post Go to first unread
Last post: 4/23/2020 9:01:03 PM(UTC)
Action Email user
by  Michael Kop  
Go to last post Go to first unread
Last post: 4/7/2020 11:24:12 AM(UTC)
Lansweeper actualizacion de datos importando csv
by  jhon freddy   Go to last post Go to first unread
Last post: 3/31/2020 9:04:45 PM(UTC)
Lansweeper Asset Actions - RunAs Prompt
by  Socal_s197  
Go to last post Go to first unread
Last post: 3/26/2020 10:02:16 PM(UTC)
Lansweeper Remote Registry 2019
by  CyberCitizen   Go to last post Go to first unread
Last post: 3/6/2020 12:25:39 AM(UTC)
Lansweeper Installation Parameters
by  Florian_Eigsi  
Go to last post Go to first unread
Last post: 3/3/2020 10:17:18 AM(UTC)