Help with querying faulted circuits
Ticketclosed
Kenmure Business Telecom · Help with querying faulted circuits
Alan requested help querying circuit fault data for operations team; Bethan provided step-by-step query builder guidance to find faulted circuits by customer.
What happened
What this says
As at Fri 9 Oct 2026Alan requested help querying circuit fault data for operations team; Bethan provided step-by-step query builder guidance to find faulted circuits by customer.
Problem: Operations team needed urgent query for circuits with open faults in past 24 hours, grouped by customer. Handling: Bethan confirmed the requirement and gave clear step-by-step guidance through the query builder, including filter setup and field selection. Watch: First response within 2 hours 11 minutes. Query guidance suggests active product usage and customer confidence in the brain.
Details
Updated 9 Oct 26Trail
created · Alan Rennie 11 Mar 2026 17:54Hi, I've got an urgent request from our operations team. They need to see the circuit status for all of our SME customers who have faults reported in the last 24 hours. I know the data should be in the brain but I'm not sure how to query it. Can you help me put this together quickly?- Public reply · Bethan Lister 11 Mar 2026 20:05Just so I've got this right, you need to filter for fault status equals open and created date in the last 24 hours, then group by customer. Is that the picture? If so, here's how to set that up: 1. Go to the circuit data source in the query builder 2. Add a filter for fault_status equals open 3. Add a date range filter for the created timestamp 4. Select your customer ID and customer name fields 5. Run the query That should get you what you need. Can you try that and tell me what you see? Thanks, Bethan
- Status change · 17 Mar 2026 23:59