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
Question:
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"?
Environment:
Oracle 11.2, 12c
UIM 8.51
Answer:
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:
https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/using-ump/the-unified-service-manager-portlet/create-and-manage-groups-in-usm