How run report in TMS to collect endpoint serial numbers?

[jtreyes]

Greetings Cisco Community,

I have TMS v15.4.0 at the moment and I would like to run a report (ie. export into Excel) that collects all the hardware serial numbers of all endpoints and MCUs.  I did execute a report from 'Reporting' > 'System' > 'System Connection' but the report included "System ID", "System Name", "Network Address", "Specific Type", "System Name", etc, but no "Hardware Serial Number".

Is it a matter of creating a custom template or other?

Thank you!

[JFerello · Accepted solution]

See attached.

[jtreyes · Accepted solution]

THANK YOU so much JFerello!  Worked like a charm.  You have been most helpful.

[guy.stevens@caci.com]

Hey man, do you know How run report in TMS to collect endpoint down time?