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
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.
Product Documentation on creating USM Groups: