A system associates problem tickets based on an integrated network and customer database. A data retriever retrieves router configurations from data stores for routers in a service provider network. A data analysis tool parses the router configurations to create port data for each port on each router in the service provider network and integrates the port data with customer data to create an integrated database. The data analysis tool assigns ports to groups in the integrated database based on applying user defined rules. The data analysis tool accesses a problem management system to identify problem tickets that lack an association in the problem management system, and identifies ports associated with the problem tickets. The data analysis tool creates an association between the problem tickets if one of the groups includes the ports associated with the problem tickets. A user interface displays the created association between the problem tickets to troubleshoot associated tickets.