A national facilities-based Competitive Local Exchange Carrier (CLEC) operated a 24x7x365 Network Operations Center (NOC) that monitored and managed over 15,000 network devices supporting more than 1 million customers. These devices spanned central offices, fiber hubs, routers, and aggregation switches across regional and metro markets.
Despite using SolarWinds for network monitoring and management, the scale and complexity of the network made outage identification and correlation extremely time-consuming. The NOC struggled to quickly determine whether service-impacting events were isolated to a single office or symptomatic of a broader regional issue. This delay directly affected time-to-resolution (TTR), customer experience, and operational efficiency.
The CLEC needed a streamlined, visual solution to summarize and geographically represent outages, enabling faster correlation by central office, area, or region without requiring manual interpretation of long device lists or status logs.
Solution Delivered
To solve this challenge, we designed and deployed a highly customized outage visualization platform that integrated seamlessly with the customer’s existing SolarWinds Network Management System. Our solution consisted of three core components:
Custom SQL Database Architecture
We developed a standalone Microsoft SQL Server instance that worked in tandem with the existing SolarWinds database. This auxiliary database housed enriched relational data critical for geographic and logical mapping, including:
This allowed for easy transformation of complex tabular network data into visual-ready formats.
Dynamic KML Generation Engine
We implemented a custom application that continuously queried both SolarWinds and the auxiliary SQL database to dynamically generate KML (Keyhole Markup Language) files. These KML files adhered to the Google Earth schema and included:
- Green for devices and links that were operational (collapsed by default)
This allowed for real-time visibility into outage conditions.
3. Google Earth-Based Visualization Dashboard Using Google Earth’s native support for KML files, we deployed a live-updating dashboard in the NOC. This dashboard provided a dynamic map-based view of the entire nationwide infrastructure, highlighting problem areas with precision. When an outage occurred: The interface automatically zoomed to the affected region using bounding logic All downed links and devices were instantly visible Operators could click into objects for metadata including CLLI, carrier info, and related upstream connections This dynamic map drastically reduced the cognitive load required to assess and understand outage impact.
Photography is the story I fail to put into words get ligula vel, commodo luctus felis. Ut dignissim sapien sit amet molestie rutr
– Destin Sparks
Aliquam vel sem vel vellesuada
Vivamus interdum suscipit lacus. Nunc ultrices accumsan mattis. Aliquam vel sem vel velit efficitur malesuada. Donec arcu lacus, ornare eget ligula vel, commodo luctus felis. Ut dignissim sapien sit amet molestie rutrum. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Pellentesque in porta dolor, a suscipit risus. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras ac arcu in lorem rhoncus ullamcorper. Ut at nulla ut libero mollis viverra sed vitae purus.
Nam dui mauris, congue vel nisi in, tempus gravida enim. Nulla et tristique orci. Pellentesque lectus sapien, maximus id gravida sit amet, tristique non eros. Etiam aliquet, sem vitae sagittis convallis, ante sapien tincidunt nisl, eget dapibus tortor velit quis ex. Proin et condimentum est, sed pretium ex. Mauris posuere est metus, vitae commodo sem posuere eget. Praesent maximus augue rutrum, consequat magna id, facilisis lorem. Quisque molestie, turpis ac interdum gravida
- Donec arcu lacus, ornare eget ligula vel, commodo luctus felis.
- Ut dignissim sapien sit amet molestie rutrum.
- Orci varius natoque penatibus et magnis dis parturient montes.
- Ut at nulla ut libero mollis viverra sed vitae purus.
Nam dui mauris, congue vel nisi in, tempus gravida enim. Nulla et tristique orci. Pellentesque lectus sapien, maximus id gravida sit amet, tristique non eros. Etiam aliquet, sem vitae sagittis convallis, ante sapien tincidunt nisl, eget dapibus tortor velit quis ex.