Avaya CMS Excel Macro to Export Login logout report

  • 1 Units in Stock
  • Manufactured by: fracta.net

$2.20

Add to Cart:

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


This product was added to our catalog on Monday 22 April, 2019.

Who's Online

There currently is 1 guest online.
Your IP Address is: 3.234.210.89
Copyright © 2019 Fracta.net Shop. Powered by Zen Cart