Your cart is empty

Avaya CMS Excel Macro to Export Login logout report

$2.00
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.


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


Add to Cart:

  • 1 Units in Stock

Please Choose:

downloadable




This product was added to our catalog on Monday 18 February, 2013.