How to Locate Unused Profile Records.

Version 1

    Details

    Is there a way to identify all unused Profile records that do not have any associated Call Tickets?


    Resolution

    To find these records in SQL Server:

    SELECT CustID FROM Profile

    WHERE CustID NOT IN

    (SELECT CustID from CallLog)

    To find these records as a Profile Group Criteria:
    {Profile.CustID} IN
    (SELECT CustID FROM Profile
    WHERE CustID NOT IN
    (SELECT CustID from CallLog))