Retrieve historical data from SfB QoE Database

[Steffen_Muessig]

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

[Shoaib_Dilawar · Accepted solution]

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.

[Steffen_Muessig]

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

[Shoaib_Dilawar · Accepted solution]

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.