I imported assets using a CSV file but never included the vendor for the different assets.  How would I go about updating the vendor field for the asset and non-it assets?  If I was using SQL server I could do it with a sql script, but not sure how to do it with an xml file.

ie:  all OptiPlex pc would be vendor Dell, all printers would be HP, etc.

thanks