Author Topic: Get list of All Logged in Genesys Users via SQL - II  (Read 14907 times)

This topic contains a post which is marked as Best Answer. Press here if you would like to see it.

tony

  • Guest
Get list of All Logged in Genesys Users via SQL - II
« on: March 29, 2007, 02:11:56 PM »
All,

This thread has been the target of spam.  I am doing what i can to copy in the contents into this (new) thread and will delete the old one.

Tony

tony

  • Guest
Re: Get list of All Logged in Genesys Users via SQL - II
« Reply #1 on: March 29, 2007, 02:13:21 PM »
AsT:

I work on a site that is open from 6:00am to Midnight.  Lately I have had a bunch of users that have forgotten the need to log out before they go home each night.  I would like to create a sql query that will tell me who is currently logged into Genesys.  With that I can throw together a VB script to email the offenders Team leads every night after midnight.

Does anyone have such a query?

tony

  • Guest
Re: Get list of All Logged in Genesys Users via SQL - II
« Reply #2 on: March 29, 2007, 02:13:49 PM »
catanirex:

Which agent application are you using?

If you are usingn Genesys Desktod/GAD 7 there is an admin tool where you can see logged in agents, and actually log them out!

Otherwise I think you need to enable StatServers writing to LOGIN table, and run a query against that dbtable.

Good Luck!

Marked as best answer by on Today at 07:34:09 PM

tony

  • Guest
Re: Get list of All Logged in Genesys Users via SQL - II
« Reply #3 on: March 29, 2007, 02:14:16 PM »
  • Undo Best Answer
  • cavagnaro

    Uh? Which tool is that???
    Where is it??

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #4 on: March 29, 2007, 02:14:33 PM »
    AsT:

    We are running Genesys 6.5.  Will be upgrading to 7.2 in the next 3 to 6 months.

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #5 on: March 29, 2007, 02:15:02 PM »
    mark:

    Quoted:

    Uh? Which tool is that???
    Where is it??


    http://'gad server'/gdesktop/admin  - 

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #6 on: March 29, 2007, 02:15:33 PM »
    cavagnaro:

    I can see the logged in agents (only those that use GAD) but can't log them out.
    Haven't found the option on any doc neither.
    Are you sure or do i have to configure something?

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #7 on: March 29, 2007, 02:15:58 PM »
    catanirex:

    I'm sure you can log the off :-)

    When you see the agents in the admin tool:

    Click on the agent
    Click on the DN
    There you will see available actions for this DN, for example Logout/Not Ready

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #8 on: March 29, 2007, 02:16:22 PM »
    cavagnaro:

    Hum i connected to another customer and worked.
    Will retry on previous customer.
    Cool, thanks

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #9 on: March 29, 2007, 02:16:45 PM »
    victor:

    Hi, can someone please tell me more about http://GAD_Server you mentioned here.
    Is it some sort of product from Genesys that allows you to control all the agents using ActiveX?
    Wow!!! Never heard of it...

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #10 on: March 29, 2007, 02:17:05 PM »
    Rene:

    Victor,

    GAD server is standard Tomcat engine "hosting" Genesys Desktop - web CTI client developed by Genesys. Everything is based on Java, no ActiveX.

    René

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #11 on: March 29, 2007, 02:17:42 PM »
    cavagnaro:

    And it sucks  ;D

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #12 on: March 29, 2007, 02:18:07 PM »
    victor:

    Quote from: René on 07 February 2007, 14:48:22
    Victor,

    Quoted:

    GAD server is standard Tomcat engine "hosting" Genesys Desktop - web CTI client developed by Genesys. Everything is based on Java, no ActiveX.

    René



    Wow... And how is it? Do many people use it? Also, how stiff is the pricing?
    And what is the official name for it? I looked at Genesys site and coult not find it.
    Thanks, Renë

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #13 on: March 29, 2007, 02:18:36 PM »
    catanirex:

    GAD = Genesys Agent Desktop. It can be found under the Desktop section in the price list, next to GCN/Genesys Contact Navigator.
    GCN is the 6.x web client GAD is the 7.x client

    The admin tool is automatically installed when installing the Genesys Desktop application.

    tony

    • Guest
    Re: Get list of All Logged in Genesys Users via SQL - II
    « Reply #14 on: March 29, 2007, 02:19:00 PM »
    Rene:

    Vic,

    As written in previous post the official name is Genesys Agent Desktop (GDesktop). I don't know how many people use it but it's bundled with Genesys Express so small call centres use it maybe because they get it in "the box".

    I have some bad experience with GDesktop and spent three months last year to make it working properly - agents staying logged in even they logged out -> agents can't log in next day, broken connection between client and server etc. … latest 7.2 release should be ok. But I don't think that web (thin) client is a good idea for CTI.

    I'm pretty sure that cavagnaro will add some notes to GDesktop  because he seems to like this product

    R.