cancel
Showing results for 
Search instead for 
Did you mean: 

SBC CDR records in Insight Reporter

Highlighted
05 Base Camper

SBC CDR records in Insight Reporter

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.  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Staff

Re: SBC CDR records in Insight Reporter

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.

 

View solution in original post

3 REPLIES 3
Highlighted
Staff

Re: SBC CDR records in Insight Reporter

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.

 

View solution in original post

Highlighted
05 Base Camper

Re: SBC CDR records in Insight Reporter

Thanks Denn,

 

Any chance I can get a db schema?

 

 

Highlighted
05 Base Camper

Re: SBC CDR records in Insight Reporter

I think I'm good on this now.  Mr. Winston hooked me up with the DB documentation. 

 

http://help.prognosis.com/docs/FKOW74MIBCNFLVJGSNSQZLS25FANQZZZLVEFEAI/Prognosis_11-4/mergedProjects...

 

Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar