How to find LIVE extension number details and count

[rht.jedhe]

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

[genesysbasha]

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

[genesysbasha]

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

[cavagnaro]

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.

[genesysbasha]

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

[Kubig]

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.

[genesysbasha]

what are the step to achieve this?

[Kubig]

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

[genesysbasha]

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

Do you know Genesys?

[Adam G]

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.

[Kubig]

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 :-)

[genesysbasha]

Thanks Adam

[cavagnaro]

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

[ndongo]

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