Service grouping for network reporting

A computer implemented method for service grouping in network reporting, comprising:

• parsing, by a data analysis tool stored in a memory and executed by a processor, router configuration data for routers in a service provider network from data stores that are separate from the routers to create port data for each physical port on each router in the service provider network and integrate the port data with customer data to create an integrated database, wherein the port data for each physical port on each router comprises a customer name;
• integrating, by the data analysis tool, the port data with customer data to create an integrated database, wherein each customer data is associated with one of a plurality of customers, and wherein the integrating comprises matching the customer name included in the port data for each physical port to a corresponding one of the plurality of customers associated with each customer data;
• identifying, by the data analysis tool, physical ports associated with a customer of the plurality of customers;
• identifying, by the data analysis tool, the physical ports associated with the customer which are bundled into bundled logical ports;
• identifying, by the data analysis tool, the physical ports associated with the customer which are partitioned into partitioned logical ports;
• creating, by the data analysis tool, a hierarchy of port information based on the physical ports associated with the customer, the bundled logical ports, the partitioned logical ports, and a service provided to the customer, wherein a primary level of the hierarchy presents the bundled logical ports and partitioned logical ports associated with the customer and a secondary level of the hierarchy presents the physical ports associated with the customer, wherein the hierarchy of port information associated with the customer further comprises a history of information associated with an operational detail of at least one of the physical ports associated with the customer;
• and
• displaying only the hierarchy of port information associated with the customer via a user interface stored in a memory and executed by a processor to enable the customer to troubleshoot ports.

A system for service grouping in network reporting, comprising:

• a processor;
• a data retriever, stored in a memory, that, when executed by the processor, retrieves router configuration data for routers in a service provider network from data stores that are separate from the routers;
• a data analysis tool, stored in a memory, that, when executed by the processor,
• parses the router configuration data to create port data for each physical port on each router in the service provider network, wherein the port data for each physical port on each router comprises a customer name,
• integrates the port data with customer data to create an integrated database, wherein each customer data is associated with one of a plurality of customers, and wherein the integrating comprises matching the customer name included in the port data for each physical port to a corresponding one of the plurality of customers associated with each customer data,
• identifies physical ports associated with a customer of the plurality of customers,
• identifies the physical ports associated with the customer which are bundled into bundled logical ports,
• identifies the physical ports associated with the customer which are partitioned into partitioned logical ports, and
• creates a hierarchy of port information based on the physical ports associated with the customer, the bundled logical ports, the partitioned logical ports, a service provided to the customer, and a geographical location associated with the service, wherein a primary level of the hierarchy presents the bundled logical ports and partitioned logical ports associated with the customer and a secondary level of the hierarchy presents the physical ports associated with the customer, wherein the hierarchy of port information associated with the customer further comprises a history of information associated with an operational detail of at least one of the physical ports associated with the customer;
• and
• a user interface, stored in a memory, that, when executed by the processor, displays only the hierarchy of port information associated with the customer to enable the customer to troubleshoot ports.