HowTo: View list of CCC Profiles, and who created them

Article ID: 51949 - Last Review: May 21, 2013


You can view a list of CCC Profiles, and who created them (pulled from the Employee list) by running the attached script in SQL Management Studio.

1. Ensure you have SQL Management Studio installed, and the permissions to connect to your CCMData database.
2. Download the attached Script-Profiles.ZIP and unzip the Script-Profiles.SQL file within.
3. Double click the Script-Profiles.SQL file.  This will open SQL Management Studio to the script screen.
4. Click the Execute (!) button at the top.

NOTE:  If you are looking for a specific profile, after Step 3 you can add the following line to the bottom of the script.  Substitute the name of the profile where the example shows #### ensuring you keep the single quotes around the profile name.  Then press the Execute (!) button.

WHERE tblProfile.Name = '####'

Keywords: SQL script management studio CCC profile contact center client search created creator

Posted Tuesday, May 21, 2013 by amontpetit