Can someone guide me on how to setup a report to obtain serial numbers for my cisco equipment?
A few of the build in reports (such as Physical Entities (Serial Number)) in NCM will show you this information. Or you can build your own.
Chapter 10 of the NCM manual tells you all about it.
http://www.solarwinds.com/documentation/orionNCM/docs/orionNCMAdministratorGuide.pdf