Creating SLA Report on SLM for 1000 QOS

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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

Environment

Any UIM Version

SQL Server 

Resolution

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