Exporting Switch Stacks with their Serial Numbers

Document ID : KB000095632
Last Modified Date : 14/05/2018
Show Technical Document Details
Issue:
I have modeled Cisco Catalyst Switch Stacks in Spectrum and Chassis Manager shows the modules, i.e. Switch Stacks, correctly. I would like to export Switch Stacks information with their Serial Numbers to import into a CMDB. I am trying to export the information using Modeling Gateway or Web Services API but it isn't easy and there is no straight way to export. What is the best available option to export this information?
Environment:
Spectrum 10.2.2 onward
Resolution:
From Spectrum 10.2.2 onward, we have Chassis-based Asset report implemented in JasperReports Server report. Please see below documentation.

https://docops.ca.com/ca-spectrum/10-2-3/en/installing-and-upgrading/install-report-manager/cabi-jasperreports-server/available-out-of-the-box-reports-and-domains

You can run Current Chassis-based Assets: All report to extract the Switch Stacks and their Serial Numbers information. The report can be exported into CSV format. This is the best available option to export these information.

Current Chassis-based Assets: All report