Query for Mac USB Report

SELECT DISTINCT ResourceUSBDeviceDetails.RESOURCE_ID AS "RESOURCE ID",  Resource.NAME AS "Name",ResourceUSBDeviceDetails.BLOCKED_LIST AS "BLOCKED_LIST", ResourceUSBDeviceDetails.UNBLOCKED_LIST AS "UNBLOCKED_LIST", COUNTTABLE."ConfigCount" FROM ResourceUSBDeviceDetails INNER JOIN (SELECT ResourceUSBDeviceDetails.RESOURCE_ID, COUNT(ResourceUSBDeviceDetails.RESOURCE_ID) AS "ConfigCount" FROM ResourceUSBDeviceDetails INNER JOIN AppliedConfigHistory ON ResourceUSBDeviceDetails.RESOURCE_ID=AppliedConfigHistory.RESOURCE_ID INNER JOIN CustomScriptConfig ON AppliedConfigHistory.CONFIG_DATA_ID=CustomScriptConfig.CONFIG_DATA_ID WHERE  (AppliedConfigHistory.STATUS = 6)  GROUP BY ResourceUSBDeviceDetails.RESOURCE_ID) COUNTTABLE ON ResourceUSBDeviceDetails.RESOURCE_ID=COUNTTABLE.RESOURCE_ID INNER JOIN Resource ON ResourceUSBDeviceDetails.RESOURCE_ID=Resource.RESOURCE_ID INNER JOIN AppliedConfigHistory ON ResourceUSBDeviceDetails.RESOURCE_ID=AppliedConfigHistory.RESOURCE_ID LEFT JOIN CustomGroupMemberRel ON Resource.RESOURCE_ID=CustomGroupMemberRel.MEMBER_RESOURCE_ID LEFT JOIN ManagedComputer ON Resource.RESOURCE_ID=ManagedComputer.RESOURCE_ID LEFT JOIN UserResourceMapping ON ManagedComputer.RESOURCE_ID=UserResourceMapping.RESOURCE_ID INNER JOIN CustomScriptConfig ON AppliedConfigHistory.CONFIG_DATA_ID=CustomScriptConfig.CONFIG_DATA_ID INNER JOIN CfgDataToCollection ON CustomScriptConfig.CONFIG_DATA_ID=CfgDataToCollection.CONFIG_DATA_ID INNER JOIN Collection ON CfgDataToCollection.COLLECTION_ID=Collection.COLLECTION_ID WHERE Collection.SHOW_IN_VIEW = true AND Collection.COLLECTION_STATE = 0  and Collection.PLATFORM_ID = 2 AND Collection.COLLECTION_TYPE = 1