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 Only 1 Basic Action not working?
by  DotWAD   Go to last post Go to first unread
Last post: Yesterday at 6:17:05 PM(UTC)
Lansweeper Mapped Drives Incorrect
by  cycleheat  
Go to last post Go to first unread
Last post: Yesterday at 5:21:32 PM(UTC)
Lansweeper Help on creating report list from security groups
by  sc00bs   Go to last post Go to first unread
Last post: Yesterday at 4:52:39 PM(UTC)
Lansweeper Will someone at Lansweeper please take my money?
by  sbAYVdQu  
Go to last post Go to first unread
Last post: Yesterday at 3:31:33 PM(UTC)
Lansweeper Monitor open process
by  Renato   Go to last post Go to first unread
Last post: Yesterday at 3:10:48 PM(UTC)
Lansweeper Duplicate assets (Servers)
by  kjstech  
Go to last post Go to first unread
Last post: Yesterday at 2:34:14 PM(UTC)
Lansweeper Office 365 32bit vs 64bit?
by  CyberCitizen   Go to last post Go to first unread
Last post: Yesterday at 7:22:38 AM(UTC)
Lansweeper "add cc user" doesn't show the correct listings
by  JLPingree  
Go to last post Go to first unread
Last post: 7/6/2020 8:12:44 PM(UTC)