Where in the DB can you find CDR data for SBC's? We want to setup enhanced reporting with another software package where we can use CDR data to do capacity reporting.
Solved! Go to Solution.
Hi Matthew,
Great to see you extending the use of your database in other ways!
The SBC data lives in several Facts tables within the datamart. They are listed below
FactsSessionBorderControllerCall
FactsSessionBorderControllerSummaryRecord
FactsSessionBorderControllerVoiceQualitySummaryStatus
FactsSessionBorderControllerPortStatus
FactsSessionBorderControllerDialPeerSummary
FactsSessionBorderControllerSignalingGroup
FactsSessionBorderControllerIpGroup
Hope this helps.
Hi Matthew,
Great to see you extending the use of your database in other ways!
The SBC data lives in several Facts tables within the datamart. They are listed below
FactsSessionBorderControllerCall
FactsSessionBorderControllerSummaryRecord
FactsSessionBorderControllerVoiceQualitySummaryStatus
FactsSessionBorderControllerPortStatus
FactsSessionBorderControllerDialPeerSummary
FactsSessionBorderControllerSignalingGroup
FactsSessionBorderControllerIpGroup
Hope this helps.
Thanks Denn,
Any chance I can get a db schema?
I think I'm good on this now. Mr. Winston hooked me up with the DB documentation.
Members | Likes |
---|---|
43 | |
36 | |
23 | |
17 | |
11 |