Notification

Icon
Error

Mass updating Custom Fields. - Mass update a Custom field with the Inventory ID’s based on the Assets Serial number

Posted: Wednesday, November 7, 2018 9:42:46 AM(UTC)
Tomas

Tomas

Member Original PosterPosts: 32
1
Like
I have an excel sheet with Serial numbers and Inventory ID’s. What would be the best way to Mass update a Custom field with the Inventory ID’s based on the Assets Serial number?
B.L.
#1B.L. Member Posts: 14  
posted: 11/7/2018 12:21:24 PM(UTC)
personally I would create individual queries based on every line, split them in batches.
Run a small batch and then update them all.
individual queries have the advantage that -to me- it's often easier to spot differences, weirdnesses and so on.

Active Discussions

Lansweeper local admin users of a specific device
by  kdunnett   Go to last post Go to first unread
Last post: Today at 9:30:26 PM(UTC)
Lansweeper How to get total disk usage of all VM assets
by  Erik.T  
Go to last post Go to first unread
Last post: Today at 4:49:58 PM(UTC)
Lansweeper Windows Server 2016 & Patch Tuesday May 2020
by  Hendrik.VE   Go to last post Go to first unread
Last post: 5/22/2020 8:20:05 PM(UTC)
Lansweeper Users mapped "shared" printers
by  Andy.S  
Go to last post Go to first unread
Last post: 5/22/2020 4:16:23 PM(UTC)
Lansweeper Report on Assets in a Static Group
by  Andy.S   Go to last post Go to first unread
Last post: 5/22/2020 2:55:03 PM(UTC)
Lansweeper Windows 10 Activation
by  TruSynergy  
Go to last post Go to first unread
Last post: 5/21/2020 7:54:25 PM(UTC)
Lansweeper Filtering Report Based On Active Status
by  CyberCitizen   Go to last post Go to first unread
Last post: 5/21/2020 4:04:33 AM(UTC)
Lansweeper Windows: Unauthorized Administrators (Built-in)
by  Jackie.L  
Go to last post Go to first unread
Last post: 5/20/2020 8:01:17 PM(UTC)