Creating SLA Report on SLM for 1000 QOS

Document ID : KB000010064
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

How to create a report of SLA Availability about 1000 Access Points

Environment:
Any UIM Version
Instructions:

Add them directly to the database with a Cursor statement.  Here is a sample query:

 

DECLARE db_cursor CURSOR FOR
SELECT source, target, qos
FROM S_QOS_DATA
where qos = 'QOS_INTERFACE_UTILIZATIONIN'
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @source, @target, @qos
WHILE @@FETCH_STATUS = 0
BEGIN
INSERT INTO S_QOS_CONSTRAINTS (slo_id, qos, source, target, operator, threshold, expected_accuracy) VALUES (5, @qos, @source, @target, '=', 100, 15)
FETCH NEXT FROM db_cursor INTO @source, @target, @qos
END
CLOSE db_cursor

DEALLOCATE db_cursor

 

NOTE: If you need more details or help, please engage CA Services