Search filter by Unqualified Server Name column uses the Server Name column to match values

Products

• CA Configuration Automation

Issue/Introduction

The filter is not returning the expected results as like it's matching the provided value with wrong column.

Environment

CA Configuration Automation - All versions

Resolution

When creating a filter under Servers by the column 'Unqualified Server Name' will apply on the values
for the 'Server Name' (column srvr_name of table acm_srvr_ex).

Below is the query for reference:

Unqualified Server Name -> test_server_abcd
Server Name -> test_server_abcd

Unqualified Server Name -> test_server_acbd
Server Name -> test_server_acbd

Unqualified Server Name -> test_server_acde
Server Name -> test_server_acde.xyb.com

For the filter  'Unqualified Server Name' Matches test_server_a%b% it'll generate the query:

select * from acm_srvr_ex  WITH (NOLOCK) 
WHERE ((UPPER(srvr_name) LIKE UPPER('test_server_a%b%.%')  OR  UPPER(srvr_name) LIKE UPPER('test_server_a%b%'))) 
ORDER BY srvr_name ASC

It'll result:

test_server_abcd
test_server_acbd
test_server_acde.xyb.com

The where clause will change based on the value provided on different conditions. 

There is no database column for 'Unqualified Server Name'. The values of 'Unqualified Server Name' build 
dynamically on the server name. For filter it will apply on the Server Name column. 

Wildcards:
        ?: This wildcard represents a single character. 
        *: This wildcard represents zero or more characters. 

Please use the wildcards above for more precise filter options.