This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Custom Call Detail

I am trying to make a custom call detail report that shows all outgoing calls from about 30 phones.  Each of those phones have a description that shows the user's name.  I would like to get that Username to show up on the report so it is easy for the person reviewing the report to see what user is making the call.

Current report looks like:

Capture.PNG

Would prefer to group by Username instead of extension.

  • If the description that comes through looks like this 'xxx-xxxx User Name' - then you could use a swql substring function on Orion.IpSla.CCMPhones.Description to parse out the numeric characters at the front. This would leave just the user name in that description field.