Getting error on cs_id while trying to use SQL as a filter for a new group in CSM

Document ID : KB000072547
Last Modified Date : 05/03/2018
Show Technical Document Details
What is a sample SQL query that can be used as a filter for a new group in USM and avoid the error: "ORA-00904: "SUB"."CS_ID": invalid identifier"?
Oracle 11.2, 12c
UIM 8.51
As mentioned in product documentation, the query must include "cs_id". That means it must be a SQL query that includes the "cs_id" column in its result set.
For example, to pull a list of all devices from the snmpcollector probe:
select * from cm_device where probe_name LIKE 'snmpcollector'
One of the columns included in the result set is "cs_id". so satisfying the requirement.
Additional Information:
Product Documentation on creating USM Groups: