Retrieve historical data from SfB QoE Database

Highlighted
05 Base Camper

Retrieve historical data from SfB QoE Database

Hi all

 

it is possible to retrieve historical data from the QoE Database from SfB.

We had a network outage between Prognosis and the SfB QoE DB. Now I want to get the missing data.

Is this Possible ?

 

Many thanks

Steffen

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Re: Retrieve historical data from SfB QoE Database

Hi Steffen,

 

It may be possible, but database storage in prognosis is based on retrieval time instead of actual activity time. so if we gathere last week's data today, prognosis would associate all that data to 'today'. That may not give you accurate information when reporting.

 

There is a flag in the <Sitegroup>.ini file:

; Maximum time (in minutes) where Prognosis goes back to get
; CDR and QoE data from the SQL Server, 60 by default.
SqlBackTime=

 

Prognosis also keeps the time it last collected data in Server\Configuration\IPTM\Lync\<Sitegroup>-sqltimestamps file so we can tweak it and let it download old entries from QoE db. You'd have data in prognosis, but may not align with report intervals as such.


If my reply answered your question please click on the 'Accept as Solution' button to help others find the answer.
Thanks,
Shoaib

View solution in original post

Highlighted

Re: Retrieve historical data from SfB QoE Database

Steffen,

 

Did you also tweak Server\Configuration\IPTM\Lync\<Sitegroup>-sqltimestamps file? If not, prognosis assumes that it already has collected data till that point, so the backtime would only work in conjuction with the timestamp.

 

I'd suggest stopping the collector, modifying the ini and sqltimestamps file and then starting the collector.


If my reply answered your question please click on the 'Accept as Solution' button to help others find the answer.
Thanks,
Shoaib

View solution in original post

3 REPLIES 3
Highlighted

Re: Retrieve historical data from SfB QoE Database

Hi Steffen,

 

It may be possible, but database storage in prognosis is based on retrieval time instead of actual activity time. so if we gathere last week's data today, prognosis would associate all that data to 'today'. That may not give you accurate information when reporting.

 

There is a flag in the <Sitegroup>.ini file:

; Maximum time (in minutes) where Prognosis goes back to get
; CDR and QoE data from the SQL Server, 60 by default.
SqlBackTime=

 

Prognosis also keeps the time it last collected data in Server\Configuration\IPTM\Lync\<Sitegroup>-sqltimestamps file so we can tweak it and let it download old entries from QoE db. You'd have data in prognosis, but may not align with report intervals as such.


If my reply answered your question please click on the 'Accept as Solution' button to help others find the answer.
Thanks,
Shoaib

View solution in original post

Highlighted
05 Base Camper

Re: Retrieve historical data from SfB QoE Database

Hi Shoaib

 

We had an outage over the weekend and I tried your solution, but unfortunately it doesn't work.

I have set the:

SqlBackTime=2880

So I hoped I get the data from the last 48 h.

I save the ini file and restarted the Prognosis Service on the Monitoring node.

But I get only the data from the last 60 min.

When I check on the Lync SQL Server in the QoE DB I see the older data.

I tried then with 360 mins as SqlBackTime=360 but no new data arrive.

My assumption was, that I receive in one intervall the complete data.

Any suggestions ?

 

Kind regards

Steffen

Highlighted

Re: Retrieve historical data from SfB QoE Database

Steffen,

 

Did you also tweak Server\Configuration\IPTM\Lync\<Sitegroup>-sqltimestamps file? If not, prognosis assumes that it already has collected data till that point, so the backtime would only work in conjuction with the timestamp.

 

I'd suggest stopping the collector, modifying the ini and sqltimestamps file and then starting the collector.


If my reply answered your question please click on the 'Accept as Solution' button to help others find the answer.
Thanks,
Shoaib

View solution in original post

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