This query checks for Duplicate CDFs according to {{IMSMANG}} rules.
<pre>
SELECT
customdefinedfield.name ASC
</pre>
This query checks for Duplicate CDFs based only on name and. If you get any duplicates here, you need to double-check that the Staging area database is created correctly.
<pre>
SELECT
customdefinedfield.name,
customdefinedfield.entitytype,
Count(customdefinedfield.cdf_id)
FROM
customdefinedfield
GROUP BY
customdefinedfield.name,
customdefinedfield.entitytype
HAVING
Count(customdefinedfield.cdf_id) > '1'
ORDER BY
customdefinedfield.entitytype ASC,
customdefinedfield.name ASC
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]