UIM - using "SQL" filter criteria for creating groups in operator console

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

You get the following error message when using SQL criteria for device filtering in the groups creation dialog window (operator console): 

"Error |Invalid Sql Query . SELECT sub.cs_id AS id FROM (-OUR QUERY-) sub ".

 

 

Environment

Release : 20.4, 20.3 

Operator Console 

Cause

The SQL query that was used for filtering, does not return cs_id value.

Resolution

The requirement for the SQL filter is that the SQL query MUST return the cs_id of the desired computer systems, so the application can correlate the cs_id with those computer systems/devices. Having this knowledge you can create various SQL queries with JOIN clauses which will allow for very wide and custom filtering criteria.