I use the QOS views in the Nimsoft database to query performance data. After purging the raw data, I want to be able to query the Historic data that remains. How do I do that?
If I remember correctly, the historic data isn't actually used by any of the newer versions but there are plans for it in the future. I might be wrong or that was the case in 6.x or something.
If you're willing to go to the database, you can find the data in there. take a look at S_QOS_DEFINITION and S_QOS_DATA. In S_QOS_DEFINITION you can find the tables names (h_table -> hn_qos_data_xxxx and d_table -> dn_qos_data_xxxx) for hourly and daily aggregates, prefixed hn_ and dn_ respectively. In S_QOS_DATA you can find the table_id, which refers to that particular metrics in a data table. If you're only interested in hourly aggregate, that table is also mentioned in S_QOS_DATA.
AFAIK current versions are using again the history data, yes it was unusable in some version, but luckily is back now.
Thanks. I found that if I modify the views created by qosviews.sql to query HN tables instead of RN tables, and change a couple of other fields in the query, I get historical data:
SELECT Q.source, Q.target, Q.origin, Q.robot, Q.probe, D.sampletime, D.min_samplevalue, D.sampleavg, D.max_samplevalue, D.tz_offset,
D.sampletime AS inserttime
FROM dbo.S_QOS_DATA AS Q INNER JOIN
dbo.HN_QOS_DATA_0012 AS D WITH (NOLOCK) ON Q.table_id = D.table_id
Retrieving data ...