We are using version 3.0 and I need help no how to run report and retrive the list of User Names and their Extension number details? Any help appreciated.

You should be able to use the print feature in Interaction Administrator to retrieve a list of users, extensions, etc. File, Print, Users Phone Directory (default) Select the items you would like to be included, then click Save As... to export as a CSV file

Not sure what you want. There is not a CIC report that I know of that provides that detail. You can quickly look at the IA Users tab and see the users name and extension as well as just looking at the company directory in the .net client. We have a handler that pulls the data from the registry and it will give you the user name, workgroup membership and extension. It's a pretty simple handler. There are probably others here who have also developed a work around

I've used the database in the past. Here is the SQL that I use: SELECT DISTINCT LocalName, LocalUserId, LocalNumber FROM CallDetail WHERE (ConnectedDate >= '2/1/2011 8:00 AM') ORDER BY LocalName Hope this helps. ~ Jeff

this actually returns a cleaner list: SELECT DISTINCT LocalUserId, localnumber FROM CallDetail WHERE (ConnectedDate > '1/1/2011 8:00 AM') and localnumber <> '' and localname <> '%/' and localuserid <> '' and len(localnumber) < '5' ORDER BY Localuserid

Wouldn't selecting from the CallDetail table only return names and extensions for users who have actually placed or received calls? The first suggestion was the best, I think - under the File menu in Interaction Administrator there is a Print option which let's you pull up a list of Users or Stations in .csv format. You can choose which details you want to see (from a limited list). Pull up that .csv in Excel and you can sort, format, and save or print a directory of users or stations.