Your cart is empty

Excel macro to automate Avaya CMS record trace reports


Record Trace

The RecordTrace.xlsm macro enabled Excel document export all trace reports for all agents in an Agents Group and save the individual files in a folder.

Open the file and go to sheet1

Complete the required fields

Agent Group Name - A valid Agent Group in your CMS installation. The names on the report will be for the agents that logged in for the specified date.

Date – can be -1 for yesterday, -2 for 2 days ago, etc… or an actual date. Typically CMS keeps trace reports for the last 7 days, if a date is chosen were CMS has no data then the trace reports will be blank.

User Name – CMS user name

Password – CMS password

Click Run

Look in the directory where the RecordTrace.xlsm file is located and a new folder will be created with a name format mm_dd_yyyy. Inside the folder the individual’s trace report will be saved with each file having the same name as the agent.

This application was tested with Avaya CMS Version 12. Other versions may require minor editing of the VBA code, Hit ALT F11 to edit the VBA code.

Add to Cart:

  • 10 Units in Stock

Please Choose:


This product was added to our catalog on Monday 07 February, 2011.