You can now use c:distinct in ps2/dcuo (it already existed for ps2). Please be careful when using this on large collections such as character since it must scan every record. Examples: http://census.soe.com/get/dcuo/item?c:distinct=icon_id http://census.soe.com/get/ps2/item?c:distinct=item_type_id