Switch stacks and serial no's in RME especially 3750's

Unanswered Question
Aug 10th, 2004


We have a customer with lots of remote sites which have 3750 switch stacks (NOT clusters) in them.

We need to discover all the stack serial no's as a requirement for Cisco Shared Support.

Campus recognise the stack master.

CM gives it the device type of 3750 stack,and the device attributes show the individual switches in the stack.

A Detailed Device Report in RME gives the serial no. of the master switch only, although it does list the other switches under the Interface Table section of the report.

An RME 'Export to File' does not show the stack member devices either.

A 'sh ver' of the stack master does give the serial no's of all members in the stack.

Seeing that CiscoWorks uses CDP to discover a network's topology, and cdp neigh detail shows the serial no., I would have thought LMS would have known about the serial no's somewhere.

Is there any way to get the stack member serial no's out of RME or any part of LMS ?

Would the RME Data Extraction Engine be of any use ?



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
hlow Wed, 08/11/2004 - 20:17

I don't know about anyone else, but my personal opinion is to be careful about getting serial numbers off CiscoWorks. I have found in many instances where instead of giving the chassis serial number, it gives the PCB number.

I believe the Data Extraction Engine would give you the same information as the Detailed Device Report.

krozier@cinci.rr.com Thu, 10/14/2004 - 05:47

I do not know if you have already solved your problem but I have found a way to get the serial numbers for all the 3750's in the switch stack. It appears that there is a table in ANI "WbuC3750Module" that contains the sn# for all members of the switch stack in the "moduleSerialNo" field. The "chassisSerialNo" field contains the sn# for the master switch in the stack.

To get to the database, you must first login to Ciscoworks then change the URL to "{ip address of cw}:1741/dbreader/dbreader.html.

The default Username and password are "cwsiSA" and "cwsiPWD" respectively, and the db is ANI. Select the "Get Database Tables" button and select WbuC3750Mondule. I really hope this can still help you. The is many more useful tables in there that I saved me hours of work!

Comments and votes are welcome!!!!

iswift Fri, 10/15/2004 - 01:03

Excellent suggestion.

I had tried using the RME dbreader as I thought the serial # information would have been in the RME inventory.

It never occurred to me to look in ANI.

getbarnett@gmail.com Tue, 06/19/2012 - 12:38

Old post, I know...but if someone else happens across this as I did.

Honestly, not sure about RME(don't use it), but show inventory from the CLI usually gets me that info for switches, routers, and hardware modules therein.

bwells@sportsmans Mon, 08/13/2012 - 15:44

Do a "show inventory raw"

This will show you both the switches as #1 or #2. It will provide the model number and Serial Number.


This Discussion