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: 20  
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 Internet Explorer 11 EOL
by  Esben.D   Go to last post Go to first unread
Last post: Today at 12:53:56 PM(UTC)
Lansweeper Software per AD group
by  CPappas  
Go to last post Go to first unread
Last post: Today at 10:52:48 AM(UTC)
Lansweeper Report Merge
by  EnjetIT   Go to last post Go to first unread
Last post: Yesterday at 1:49:51 PM(UTC)
Lansweeper Microsoft True Up: Licenses combined with AD
by  Tstandridge  
Go to last post Go to first unread
Last post: 8/1/2021 6:39:26 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  BKolodny   Go to last post Go to first unread
Last post: 7/30/2021 5:29:43 PM(UTC)
Lansweeper Last user, login time and null entries
by  cross_eur  
Go to last post Go to first unread
Last post: 7/29/2021 5:44:36 PM(UTC)
Lansweeper Stale Tickets
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/28/2021 8:47:09 PM(UTC)