
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-09-2019 12:06 PM
I need to add custom attribute data to around 420 assets.
Is there a quicker way other than search, edit, change, save, repeat.
Is there a quicker way other than search, edit, change, save, repeat.
Labels:
- Labels:
-
General Discussion
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2019 02:13 PM
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)
Update tblassetcustom
set Custom1 = 'YourValue'
where assetid IN (1,2,3,4,5,6,7)
