I grabbed a custom poller someone wrote which collects the serial number from Cisco devices and stores them in the database. It doesn't, however, store them in the "SerialNumber" column in the "Nodes" table, I'm guessing it's in some other table.
Ideally, I'd like to schedule a script to run that does a select on that other table and then sets the "SerialNumber" in the Nodes table.
I know very basic stuff about SQL and I know less about scripting in Windows so I'm looking for some in-depth help here.
Thanks in advance!