DX Unified Infrastructure Management

-- Description:
-- This sql procedure generates easy-to-use views in the NIS for accessing raw qos data.
-- The intention of this script is that is is used instead of the qos_server custom probe.
-- The Script creates views named V_qosname, for example V_QOS_CPU_USAGE.
--
-- **** Please note that this is not supported by Nimsoft Support. This Script is intended to
-- be used as is, feel free to modify for your own purpose. ****

-- qos_views_2.7.sql is compatible with CA Nimsoft 7.6 and earlier releases.

-- qos_views_2.8.sql is compatible with CA UIM 8.0 and later releases.

Thank you!! 

Attached is the updated script to work with the V_* views that currently combine the RN_*, HN_*, and DN_* tables; script provided by Cash_Shurley.

can you share equivalent mysql scripts if available.

I'll be working on this over the next few days. Please stay tuned.

I performed this script, but at the final i receive the follow confirmation:

And the views, for example: V_QOS_CPU_USAGE / V_QOS_MEMORY_USAGE / V_QOS_NET_CONNECT, was not created.

How i do to create the follows views: V_QOS_CPU_USAGE / V_QOS_MEMORY_USAGE / V_QOS_NET_CONNECT and the others?

Thanks alot for your help

Here is the updated version: QOS_Views MS SQL script (Feb 2016) 

Cash_Shurley

can you help me with this syntax error. I am getting this when trying to execute the mysql script

I get this when I call qosviews on my mysql 5.6.23 DB. We are running 8.4 on CentOS 64but VMs. When I look at RN_QOS_DATA_0193 I can see that I am actually missing the column for both samplestdev and samplerate. Anyone else have this issue?

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| CREATE OR REPLACE VIEW V_QOS_BC_ONLINE2 AS SELECT Q.source,Q.target,Q.origin,Q.robot,Q.probe,D.sampletime,D.samplevalue,D.samplestdev,D.samplerate,D.tz_offset FROM S_QOS_DATA Q JOIN RN_QOS_DATA_0193 D ON Q.table_id=D.table_id |

+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

1 row in set (3.65 sec)

ERROR 1054 (42S22): Unknown column 'D.samplestdev' in 'field list'

Fixed this.. I actually had two tables like this, 193 and 405 but both contained no records so I just altered the tables adding both columns then it worked fine. Calls using it to the DB are super slow though.

I want to execute the script in Oracle, but the follow error appears with 2.4 version

PLEASE YOUR HELP!

If you are on a recent version of UIM than the 2.4 version might not work without some modifications as the database schema has changed since then. 

Hi Bryan, is there an update version of the qos_views script for mysql database? if so, please share.

Hi we also ran into a similar issue while executing the script against Oracle DB- any ideas?