Contents

(Supervisor) Number Search Report

This report allows you to search all users who have called or received calls from a specific phone number. The Number Search Report is a tool for managers and system administrators who wish to track down the callers of specific numbers. IC sorts this report by IC user name.

Parameters

You specify a number to search for, a range of dates, the start and end time of day (or shift), account code, and the number to search, to include in the report. The number to search must contain the number in the format +99999999 to result in a successful search. You can use the country code to search for country-specific numbers. For example, if you wish to run a report for USA only, change the parameter to +19999999999 (the ‘1’ represents the country code, which is the USA). You may change this parameter in Interaction Administrator or at runtime.

Notes
- If you enter a range for one of these specific parameters (caller IDs, dialed numbers, DNIS, and user IDs), and a record included in this range has a null value for any one of these parameters, then this record will be excluded on the report. It is not possible to include these records at this time.

- The use of wildcards for the representation of variable numbers is supported . You can enter the range as a wildcard, e.g., dialed number range +13178?????? to 13179??????.

Report Log Tables	Interaction Administrator Unique Report Identifier
CallDetail	SUPER_NUMBERSEARCH_NAME

Sample report

Click on the image below to view a sample of this report.

Report Element	Report Field or Value	Field or Value Description
User	LocalUserId	The name of an IC user account included in the range of users for a report.
Extension	LocalNumber	The extension of the IC user.
Date	ConnectedDate	The date for each call from this Caller ID number.
Time	ConnectedDate	The time each call connected to or from this number.
Direction	CallDirection	This field is Inbound for calls placed to the IC user / extension, and Outbound for calls placed from the IC user / extension.
Number	RemoteNumber or RemoteNumberFmt	The external phone number or extension of the calling party. The call contains the number of a calling party if caller ID is available. In the case where RemoteNumberFmt is blank, then IC uses the RemoteNumber with an * added to the end of the number. If both the Remote NumberFmt and the RemoteNumber are blank, then the RemoteCallerID is used with two ** added to the end of the number. If all these are blank, then N / A is displayed on the report. A null or empty value is possible if the call was an Intercom call that was terminated before the Remote party was specified.
Remote Name	RemoteName	The name of the party that called the IC user, if the name is provided with the call.
Acct Code	AccountCode	The account code assigned to the call
(Min) Duration	Duration hh:mm:ss	The duration of this call. Connected time to disconnected time. This value is calculated using the GMT Times so it is not affected by changes in time due to daylight savings
(Min) Hold Time	Hold Time hh:mm:ss	The time this call was on hold.
Total Hold Time (summary)	Sum(HoldDurationSeconds)	The number of seconds that all Caller ID calls were on hold, on the given date(s).
Total Calls (summary)	CallDetail.ConnectedTime	The total number of calls to the specified number in the given ranges.
Total Duration (summary)	Sum(CallDurationSeconds)	The total time for all calls to the specified number in the given ranges.

Record selection criteria for this report includes:

{CallDetail.ConnectedDate} in {?StartDateTime} to {?EndDateTime} and

{CallDetail.RemoteNumber} in {?StartCallerID} to {?EndCallerID} and

{CallDetail.LocalUserId} in {?StartUser} to {?EndUser} and

{CallDetail.SiteId} in {?StartSiteId} to {?EndSiteId}