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 ?
Solved! Go to Solution.
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.
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.
We had an outage over the weekend and I tried your solution, but unfortunately it doesn't work.
I have set the:
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 ?
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.
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