DNAC reporting issue with stacks

[TeamIBOS70148]

Customer is generating reports from DNAC that are putting all serials from a stack into one cell separate by comma.  It also puts the PID like that.  Example:

WS-C2960X-48FPS-L, WS-C2960X-48FPS-L, WS-C2960X-48FPS-L 

Through the magic of Excel I can separate them into individual cells, but then it's difficult and very manual to use the rest of the data from that row.  I'm sure this is a canned report, there has to be one that can split the stack into individual rows like the CSPC/SNTC can.  

[nirraman]

Hi,

If the canned report from DNAC doesn't provide the desired format, you may need to explore custom report generation options within DNAC. Cisco DNA Center offers programmability options using APIs (Application Programming Interfaces), such as REST APIs, that allow you to extract data in a customized format. You can leverage these APIs to generate reports that better suit your requirements, including splitting stack information into individual rows.(https://www.cisco.com/c/en/us/td/docs/cloud-systems-management/network-automation-and-management/dna-center-platform/2-3-3-0/user_guide/b_dnac_platform_ug_2_3_3/b_dnac_platform_ug_2_3_3_chapter_0110.html#id_132351)

If you find my reply solved your question or issue, kindly click the 'Accept as Solution' button and vote it as helpful.

You can also learn more about Cisco DNA Center through our live Ask the Experts (ATXs) session. Check out Cisco DNA Center ATXs Resources [https://community.cisco.com/t5/networking-knowledge-base/cisco-dna-center-ask-the-experts-resources/ta-p/4394489] to view the latest schedule for upcoming sessions, as well as the useful references, e.g. online guides, FAQs.

Thank You,
Niranjana