Untitled

SELECT filter(uniqueCount(eventState), WHERE eventState NOT IN ('RESOLVED', 'OBSOLETE')) OR filter(-1*uniqueCount(eventState), WHERE eventState IN ('RESOLVED', 'OBSOLETE')) FROM NAS_SFS_Flex WHERE eventName LIKE 'CRC Error Detection For Cluster NIC Ports' FACET eventSourceCI as 'CIName', eventID, eventName, eventSourceName