cancel
Showing results for 
Search instead for 
Did you mean: 

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

3 REPLIES 3

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
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

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
Webinar: The Journey to Microsoft Teams - Readiness Phase (part 2)

Having looked at the planning phase in session one of this series, we will turn our focus to the readiness phase. The all important technical capabilities assessment, ensuring the network, endpoints and users are adequately prepared for the move.

Hear first hand from IR's Global Head of Information Systems and Technology, Jason Schwendinger, on how he has been tackling these issues.

Join webinar