Duplicate CDF
SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, Count(customdefinedfield.cdf_id) FROM customdefinedfield GROUP BY customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype HAVING Count(customdefinedfield.cdf_id) > '1' ORDER BY customdefinedfield.entitytype ASC, customdefinedfield.name ASC