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

Lansweeper Edit Work Time Enhancements
by  pipapo   Go to last post Go to first unread
Last post: Yesterday at 3:41:25 PM(UTC)
Lansweeper software authorization based on "name" AND "version"
by  deejay3670  
Go to last post Go to first unread
Last post: Yesterday at 2:53:28 PM(UTC)
Lansweeper HP Warranty scan - broken for some products
by  JérômeS   Go to last post Go to first unread
Last post: Yesterday at 2:34:13 PM(UTC)
Lansweeper Helpdesk Report for unresolved tickets
by  Walter  
Go to last post Go to first unread
Last post: Yesterday at 2:08:39 PM(UTC)
Lansweeper Certificate status & end dates
by  Antoine EVRARD   Go to last post Go to first unread
Last post: Yesterday at 1:01:37 PM(UTC)
Lansweeper Assign switch port to location map
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 5:21:54 PM(UTC)
Lansweeper Email Link back to ticket
by  TruckDriverTurnedIT   Go to last post Go to first unread
Last post: 5/26/2020 5:20:08 PM(UTC)
Lansweeper LSAgent not Scanning or Reporting all Software
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 4:15:05 PM(UTC)