SQL Code to copy BIOS Serial Number into Asset Object
In our environment we are unable to use BIOS serial number to map assets since some of our machines have generic text in that field. As a work around we are now using machine name to map assets. I am looking for a way to use a SQL query to auto populate BIOS serial number into a field in Asset object and it should skip the machine if it finds the following text in there. Could you please help?
BIOS Serial Number = System Serial Number
BIOS Serial Number = To be filled by O.E.M.
BIOS Serial Number =
BIOS Serial Number = Null