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 SQL Triggers
by  Kyle Zimmerman   Go to last post Go to first unread
Last post: 3/28/2020 9:43:26 PM(UTC)
Lansweeper Access LS Knowledge base from outside network
by  Hagobian  
Go to last post Go to first unread
Last post: 3/28/2020 12:46:44 AM(UTC)
Lansweeper Wake on Lan wol.exe issue
by  Socal_s197   Go to last post Go to first unread
Last post: 3/27/2020 10:05:42 PM(UTC)
Lansweeper Scanning Queue locked
by  KevinA-REJIS  
Go to last post Go to first unread
Last post: 3/27/2020 8:48:45 PM(UTC)
Lansweeper Asset Radar requirements
by  bbeavis   Go to last post Go to first unread
Last post: 3/27/2020 6:58:20 PM(UTC)
Lansweeper LSAgent Cloud Relay error
by  nlertn  
Go to last post Go to first unread
Last post: 3/27/2020 6:35:55 PM(UTC)
Lansweeper Scanning IP Range Subnet
by  WeatherDave   Go to last post Go to first unread
Last post: 3/27/2020 5:39:17 PM(UTC)