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,877  
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

Lansweeper Notebooks report
by  Martin Izquierdo   Go to last post Go to first unread
Last post: Today at 4:08:32 PM(UTC)
Lansweeper Unauthorized Administrators by OU
by  Craig Fair  
Go to last post Go to first unread
Last post: Yesterday at 8:05:04 PM(UTC)
Lansweeper Waiting reboot status
by  RJJJR   Go to last post Go to first unread
Last post: Yesterday at 7:01:42 PM(UTC)
Lansweeper reboot required or awaiting reboot report
by  RJJJR  
Go to last post Go to first unread
Last post: Yesterday at 6:58:36 PM(UTC)
Lansweeper Report 32 or 64bit software
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 12:21:46 PM(UTC)
Lansweeper Report Needed of just DEFAULT GROUP assets
by  SHib11  
Go to last post Go to first unread
Last post: 10/15/2019 2:57:23 PM(UTC)
Lansweeper No longer shows up-to-date with new OS version
by  ICT Support  
Go to last post Go to first unread
Last post: 10/15/2019 11:29:10 AM(UTC)