Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: scoll7567 on June 14, 2011, 11:50:07 PM

Title: Another Login time reporting question
Post by: scoll7567 on June 14, 2011, 11:50:07 PM

I searched and read the posts; Thus far, I have I enabled the login table on the stat server.  I believe DAP is set up correctly.  How do I view the table in BRIO/Hyperion?  I reviewed the tables and do not see anything that provides login time.

Thanks

Steve

Title: Re: Another Login time reporting question
Post by: cavagnaro on June 15, 2011, 04:20:01 AM

?? ON Brio you should connect to the DB where you configured the DAP for LOGIN Table. Then you will see it...is your connection file well configured?

Title: Re: Another Login time reporting question
Post by: Adam G on June 15, 2011, 04:29:01 AM

Use DBA tools to make sure it is there, first.... then Brio/Hyperion....

Title: Re: Another Login time reporting question
Post by: fnunezsa on June 15, 2011, 05:21:32 PM

If you want to see StatServer tables from Biro/Hyperion, then your ODBC entry should point to the StatServer database. If your ODBC entry points to Data Mart DB, then you won't see those tables there UNLESS you created StatServer tables within Data Mart DB

Title: Re: Another Login time reporting question
Post by: scoll7567 on June 15, 2011, 08:45:40 PM

I currently see the ccanalyzer data in the tables I'm assuming the login table points to the ame DAP; I'm not sure though.  I'm told there is a canned CCanalyzer report agent activity that tracks this info.  Is that correct? If so, does someone have it?

Thanks

Title: Re: Another Login time reporting question
Post by: cavagnaro on June 15, 2011, 10:22:32 PM

No, no canned report, you have to build your own as well as the tables to store the info. By any chance have you at least read the documentation?

Title: Re: Another Login time reporting question
Post by: scoll7567 on June 15, 2011, 11:50:11 PM

LOL, yep read the stat server deployment and reference guide as well as read most of the posts on this subject.  I'm an operations guy not an IT guy and just trying to resolve my problems without having to wait for It.  And I do appreciate the help.  Our consultant mentioned a canned report called "Agent Activity"; I never heard of it.

Title: Re: Another Login time reporting question
Post by: cavagnaro on June 16, 2011, 04:00:42 AM

Have you run the script localized at StatServer installation folder into the DB that DAP is configured on? This will create the needed table so StatServer then can write into it. Also check DBServer logs for that DAP so you can see what it is doing

Title: Re: Another Login time reporting question
Post by: Adam G on June 16, 2011, 07:35:36 AM

http://www.tonytillyer.co.uk/License-Auditing.php

???

;D

Title: Re: Another Login time reporting question
Post by: scoll7567 on June 16, 2011, 10:28:55 PM

Thanks guys I'm gonna run the script and go from there

Title: Re: Another Login time reporting question
Post by: Tambo on June 17, 2011, 12:38:00 PM

The LAS works a treat would highly recommend it, we were going to purchase it but were then told we may be moving to another system, so that put a stop to it.

A lot of work in that Tony, brill

Tambo