Is there a way to get the end-to-end network routes from the ETL Export database?

[DCIM_Support]

I don't see such a table in the R7.5 Export DB Schema. I also checked the Web Services API and didn't find any web services that may enable that. There is one strategic customer who would like to export all routes for a given rack to a Excel file quickly. You can do that using DCO network management table, but it does it server by server, not at the rack level. Any suggestion would be appreciated.  

Thanks,

(Question on behalf of Raymond Xie)

(CID:104174476)

[DCIM_Support · Accepted solution]

Hi Raymond, you need (at least) DCO 7.5.0 SP3.  All the data is in the Export DB.  Email me for more details

Cheers

(Entered on behalf of Ed Tarento)

(CID:104174482)

[DCIM_Support]

Thanks for the details Ed. I'd add that you will have to retrieve the routes using device id/network module name/port number matching. Only connections between two devices are available in the export db, you won't find a whole route on a single database row.

(Entered on behalf of Guillaume Vigneron)

(CID:104174705)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.