Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: rht.jedhe on January 27, 2015, 04:24:43 PM

Title: How to find LIVE extension number details and count
Post by: rht.jedhe on January 27, 2015, 04:24:43 PM

Hi Team,

This to inform you that we have planned to delete unwanted Extensions from configuration Manager, So we want know how many extensions are currently using in LIVE environments. how to check this? where i get this details.

Please help me!!!

Regards
Basha

Title: Re: How to find LIVE extension number details and count
Post by: genesysbasha on January 27, 2015, 04:32:58 PM

Hi,

Hope we can retrieve this details from configdb, but unfortunately i forgot that method.
i will respond to you in case if its come to my mind.

Mean time if anybody know, please help him

Happy to Help
Genesys

Title: Re: How to find LIVE extension number details and count
Post by: genesysbasha on January 27, 2015, 04:42:59 PM

I believe that our one man army Mr. René can help this, cuz he is encyclopedia for Genesys........:)

Title: Re: How to find LIVE extension number details and count
Post by: cavagnaro on January 27, 2015, 07:32:52 PM

1. What is unused for you?
2. Which PBX are yo using?
3. Genesys has no information on when was a DN last used...this is a total PBX point of view and management on your side...

How you expect this to work? A query on some DB?
The best I can think of is to go on CCPulse and monitor Extension DNs out of Service...but, if they are IP for example, then OutOfService means it is just powered off...
Don't see how Genesys can provide business information to you on that level.

Title: Re: How to find LIVE extension number details and count
Post by: genesysbasha on January 28, 2015, 10:08:26 AM

Hope he is looking for LIVE extension count.....I mean how many extensions are currently using or user Logged in.

Title: Re: How to find LIVE extension number details and count
Post by: Kubig on January 28, 2015, 10:18:47 AM

You can achieve how to get count of users/agents who are logged in through standard statstics of category "CurrentNumber" with mask to LoggedIn.

PS. In config DB you are not able to find mentioned information. There are just configuration of all extensions, but no their status.

Title: Re: How to find LIVE extension number details and count
Post by: genesysbasha on January 28, 2015, 10:25:08 AM

what are the step to achieve this?

Title: Re: How to find LIVE extension number details and count
Post by: Kubig on January 28, 2015, 10:31:34 AM

Just configure it on statserver level object type. Do you know Genesys? :))

Title: Re: How to find LIVE extension number details and count
Post by: genesysbasha on January 28, 2015, 10:36:10 AM

Not much more... but we will try our best..

Do you know Genesys?

Title: Re: How to find LIVE extension number details and count
Post by: Adam G on January 28, 2015, 10:37:08 AM

If you want a list.... you can read about the LOGIN Table for the StatServer.  From there, you can create a query to show unmatched items from your cfg db.

If you want a solution... PM  me.

Title: Re: How to find LIVE extension number details and count
Post by: Kubig on January 28, 2015, 10:40:52 AM

If no, read the documentation and you will be able to configure mentioned statistics. In other case invite Genesys PS or your Genesys partner.

There are many ways how to achieve it. All depends on what are yours goals and needs - you can use Login/Logout information and read from that or use standard statistics, make own PSDK application or use LRM.


PS: Yes, I think that I know Genesys :-)

Title: Re: How to find LIVE extension number details and count
Post by: genesysbasha on January 28, 2015, 11:05:22 AM

Thanks Adam

Title: Re: How to find LIVE extension number details and count
Post by: cavagnaro on January 28, 2015, 04:59:17 PM

??? Why did my brain addded the "non" word??
Sorry there.
Well as Adam says, using SS table does the work.

Sure you know it but:
1. Add DAP to SS
2. Create table using SQL scripts on SS installation folder
3. Enable SS to write data on SS options (login)
4. Dates will be stored in unix time stamp so with a simple SQL function according to your DB Engine you can convert them.

Should work

Title: Re: How to find LIVE extension number details and count
Post by: ndongo on May 19, 2015, 10:17:30 AM

Hello,

I would like to have the same information (last time a place was used), but from Info Mart.

Thank you in advance for your help

BR