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

Installer CutePDF and Ghostscript install (Print to PDF)
by  Ruben1  
Go to last post Go to first unread
Last post: 10/15/2019 10:35:05 AM(UTC)
Installer Team Viewer Host update / install
by  nb005   Go to last post Go to first unread
Last post: 9/20/2019 10:41:28 AM(UTC)
Installer Sophos Silent Install
by  mzipperer  
Go to last post Go to first unread
Last post: 9/5/2019 11:00:34 PM(UTC)
Installer Script - Reset Local Admin Password
by  Ricky Hignite   Go to last post Go to first unread
Last post: 7/26/2019 6:30:06 PM(UTC)
Installer LsAgent for Windows
by  bbeavis  
Go to last post Go to first unread
Last post: 7/15/2019 10:17:18 PM(UTC)
Installer Uninstall - Adobe Acrobat 9x
by  mzipperer   Go to last post Go to first unread
Last post: 7/12/2019 9:15:51 PM(UTC)
Installer Upgrade Windows 10 to 1803
by  Richard A  
Go to last post Go to first unread
Last post: 7/9/2019 2:05:20 PM(UTC)