Avaya Support Forums  

Go Back   Avaya Support Forums > IP Telephony and Convergence

Thread Tools Search this Thread Display Modes
Old 09-25-2014, 09:16 AM
cajig1 cajig1 is offline
Aspiring Member
Join Date: Sep 2014
Posts: 2
cajig1 has 10 reputation points
Default Custom report to match user, ext., DID# in Avaya SA - How?


I'm using Avaya Site Administration Ver. 5.0.11. I need to create a costume report that match and lists User Name, Extension #, but only the extensions that have a DID phone number for example:

John Doe 3340 13495783324
Jane Doe 3158 13495783210

Right now to obtain the extension and user name I use the command [LIST STATION], and then I print the output to a XPS files. Then I use the command [DISPLAY INC-CALL-HANDLING-TRMT TRUNK-GROUP (trunk number)]. I repeate that command for each trunk-group to obtain the list of extensions and DID phone numbers. I have to "print" all command outputs to XPS files. Then I have to process those XPS files the hard way with copy/paste, parsing, sorting, manually matching, etc., etc.

I need to create a report to do all that automatically. I saw that under the [Advanced] tab there is a [Report] option. The report option have many type of reports (including [LIST STATION]), but none for the trunks or DID numbers.

How can I create a report for that?
Reply With Quote
Old 09-25-2014, 09:53 AM
cajig1 cajig1 is offline
Aspiring Member
Join Date: Sep 2014
Posts: 2
cajig1 has 10 reputation points

Ok I found that you can use the export option that is also available under the Advanced section but the only difference is that I can output the command to a comma delimited file instead of printing to a XPS file. I still have the issue of matching user name with extension number and DID number.

I need to find a way to create a report that include those specific fields from the database.

User Name, ext. #, DID #

Any ideas?
Reply With Quote
Old 11-26-2014, 08:20 AM
mbong mbong is offline
Hot Shot
Join Date: Aug 2012
Posts: 12
mbong has 11 reputation points

There is no automatic way to produce this out of ASA that I am aware of.

I use Excel and the LOOKUP() function to match the extensions to a table that I've to setup to associate a range of extensions with DIDs. Now, this is possible for my environment as the last 4-digits of our extensions is the last four digits of the DID. So, your mileage may vary on how this works for you.
Reply With Quote
Old 11-30-2014, 02:23 AM
ortiz121 ortiz121 is offline
Aspiring Member
Join Date: Nov 2014
Posts: 1
ortiz121 has 10 reputation points

Thanks for the information, I was looking for....

Christopher T. Ortiz
Harmony House
Reverse Diabetes Naturally
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -7. The time now is 08:05 PM.

This Forum is provided solely for the use and convenience of Avaya customers and partners. Use of the Forum is subject to the Terms and Use and Privacy Statement found at www.avaya.com. No other use is permitted. The Forum including all content posted is “AS IS” and Avaya expressly disclaims all warranties and/or guarantees as to its accuracy, reliability, usefulness, quality or non-infringement of intellectual property. Avaya reserves the right to remove any content posted on the Forum at any time and for whatever reason.

Avaya will not be liable for any content posted on this Forum, including, without limitation, any errors or omissions or for any losses or damages of any kind incurred as a result of use or reliance on any content, regardless of its origin.

You expressly understand and agree that you assume all risks associated with use or reliance on this content.