Serial numbers from NCM entity_physical table to NPM nodes table (custom property [SerialNumber]) - SQL script
see attached for SQL script. This assumes you have a custom property in NetPerfMon Nodes table called "SerialNumber".
Code is in commented sections of the script (annotated by /* comments here */ )
The first section that has a bunch of columns selected will allow you to validate your result set before you commit any changes.
The second section actually updates the NPM Nodes table.
USE WITH CARE
AS ALWAYS - BACK UP YOUR DATABASE(S) PRIOR TO DOING ANY DB WORK