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?
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.