Avaya CMS Excel Macro to Export Login logout report for a date range
As you may already know the HistoricalAgentLogin/Logout (Skill) contains multiple entries for each agent each time skills get re-assigned, so if you want to get the proper login and logout times you have to look for the earliest and last entry. This macro does the job for you and as bonus it does it for multiple days in one hit.
The Excel macro was tested using Avaya CMS version 16 and on Windows PC on Excel 2007. Simply enter the date range you would like to get the earliest login time and the last logout time and the skill number and click run. The macro will export and clean up the Avaya HistoricalAgentLogin/Logout (Skill) in a neat summary.
The VBA code is code for ACD 1 but if you are using other ACD simply change in the VBA editor – the project is unlocked. Other settings such as your user name, password and CMS server IP or name can be entered on the front end.
This a sample starter VBA Excel project for one skill. For multiple skills add a loop to your code and cycle for each skill number.
Code provided as is, you must know what you are doing. You might need to adjust Avaya object references if you are on a different version than that I tested it on.
Office/Excel 64bits did not work with the 32bits library Avaya uses when I wrote this in 2015, you probably need Office 32bits installed unless this was fixed. Windows 64 bits is OK.
Sample Output:
Aman Sade 18/06/2012 8:18 AM 5:00 PM
Aman Sade 19/06/2012 8:12 AM 5:00 PM
Aman Sade 20/06/2012 8:10 AM 5:00 PM
Jina Craford 18/06/2012 8:52 AM 5:30 PM
Ol Villa 18/06/2012 8:21 AM 4:58 PM
Ol Villa 19/06/2012 8:42 AM 4:57 PM
Ol Villa 20/06/2012 8:27 AM 5:00 PM
Po Dou 18/06/2012 7:34 AM 5:00 PM
Po Dou 19/06/2012 7:45 AM 4:59 PM
Po Dou 20/06/2012 7:39 AM 7:42 AM
This product was added to our catalog on Friday 22 September, 2023.