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 Select individual assets from reports?
by  pryan67   Go to last post Go to first unread
Last post: Today at 10:39:16 PM(UTC)
Lansweeper Exchange Mailbox Usage
by  nhouse24  
Go to last post Go to first unread
Last post: Today at 10:31:09 PM(UTC)
Lansweeper Personalize interface user ticket
by  Brighton   Go to last post Go to first unread
Last post: Today at 9:31:34 PM(UTC)
Lansweeper Update dashboard defaulting to Helpdesk
by  nriddick  
Go to last post Go to first unread
Last post: Today at 9:22:18 PM(UTC)
Lansweeper Change Management : Creating new Events type
by  Hugo Lynch   Go to last post Go to first unread
Last post: Today at 8:05:34 PM(UTC)
Lansweeper Linked Tickets - Helpdesk Workflow/Subordinate Tickets
by  Argon0  
Go to last post Go to first unread
Last post: Today at 5:22:27 PM(UTC)
Lansweeper SCCM Scanning Failure
by  wanduster   Go to last post Go to first unread
Last post: Today at 4:18:47 PM(UTC)
Lansweeper Notification ticket in pending after 1 week
by  Vasile Ciuban  
Go to last post Go to first unread
Last post: Today at 3:18:04 PM(UTC)