The present disclosure provides automated solution for identification of spare fiber capacity with minimal manual intervention thereby eliminating the errors and ensure reliability and scalability and implemented by independent modules to provide Tabular, Schematic and Map view available for depicting route-side fiber capacity (total/used/unused). The method includes automatically enrichment of logical links data discovered by EMS/NMS systems which provide the logical paths/links between two equipment with port details along with host name of the equipment and identifier of the port. The method further includes, enriching the EMS/NMS links data, based on host name and inventory mapping, within logical network inventory management system thereby resulting in the availability of links inventory data in ‘From site-from equipment-rom port’ and ‘to site-to equipment-to port’ format.