Tables in CA UIM

[Carlos Hugo Martin Carranza Olivera]

Hi all,
I would like to know what is stored in the VN_QOS_DATA_XXX tables

[James Christensen]

The VN_QOS_DATA_xxxx are actually defined as views for the data in the corresponding RN, DN, and HN QOS_DATA_xxxx tables.

create view [dbo].[VN_QOS_DATA_0001](table_id, sampletime, samplevalue) as select table_id, sampletime,samplevalue from RN_QOS_DATA_0001 UNION ALL select table_id, sampletime,sampleavg as samplevalue from HN_QOS_DATA_0001 UNION ALL select table_id, sampletime,sampleavg as samplevalue from DN_QOS_DATA_0001;

As far as usefulness, I have never looked into using them for queries since you have to know specifically which one is associated to which QOS metrics and you have to know the table_id for the source of that data.

------------------------------
[Designation]
[City]
------------------------------