We use cookies on our website to analyze website usage and to help secure the website against misuse. Advertising and functional cookies are not used in our site or our web application products.
By clicking “Accept Essential Cookies Only”, you consent to us placing these cookies.
Apply serial number cleaning algorithm to an entire table column
Runs a bulk serial number cleaning algorithm across all rows in a table column, normalising invalid or placeholder serial numbers. The ComputerName substitute field is used as a fallback value when no valid serial number can be determined.
| Parameter | Description |
|---|---|
| cmd | Algorithm name to apply (blank for default, "1" or "2" for alternate algorithms) |
| Argument 0 | Table name to clean (e.g. $tempdb$NetworkDiscovery) |
| Argument 1 | Column containing serial numbers to clean (e.g. MotherBoardSerialNumber) |
| Argument 2 | Primary key column used to identify rows (e.g. DeviceID) |
| Argument 3 | Fallback column used when no valid serial number exists (e.g. ComputerName) |
CleanSerialNumberTable "Algorithm name to apply (blank for default, "1" or "2" for alternate algorithms)", "Table name to clean (e.g. $tempdb$NetworkDiscovery)", "Column containing serial numbers to clean (e.g. MotherBoardSerialNumber)", "Primary key column used to identify rows (e.g. DeviceID)", "Fallback column used when no valid serial number exists (e.g. ComputerName)"