Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: vjicecool on July 14, 2011, 01:28:04 PM

Title: Genesys Database Question?
Post by: vjicecool on July 14, 2011, 01:28:04 PM
How can we find out when the user is added to Genesys( from CME)
I am sure this is can be find out using database, can any one please suggest me a method.
Also how to find out changes that were made to the object(person, dirn etc)
Title: Re: Genesys Database Question?
Post by: cavagnaro on July 14, 2011, 03:19:25 PM
Check SCI for logs. Enable them on ConfigServer and be sure to configure it to store them on DB. Read the Framework documentation
Title: Re: Genesys Database Question?
Post by: borkokrz on July 14, 2011, 04:14:20 PM
One method is to activate History Of Changes adapter in confserv and extract informations from configDB. Another is to use ICON with role CFG and extract informations from ICON database. Creation date of person is also available in OBJECT table in Datamart DB. In OBJ_TO_OBJ you will also find person to group and skill last date assignments (this source - datamartDB - is not online, due to ETL architecture).
Title: Re: Genesys Database Question?
Post by: fnunezsa on July 14, 2011, 11:14:51 PM
This type of question has been asked a lot here in the forum...

I believe is a matter of time for Tony to reply pointing out Blackchair solution: Spotlight  ;D

Also you can just enable the Audit Trail functionality of Genesys Management Layer. In brief you'll need to:
1) Configure network logging in Configuration Server
2) Enable Message Server to write to a Log Database
3) Implement some sort of data purging procedure for Log Database as there is no OOB purge procedure for this DB. There is some directions to do so in the Management Layer User’s Guide.

Then you can use SCI to review confguration changes our you can implement any other sort of report sourced from Log DB.

I believe there are detailed instructions on how to setup Management Layer Audit Trail in Management Layer User’s Guide.
Title: Re: Genesys Database Question?
Post by: genesysguru on July 18, 2011, 10:33:14 AM
Some time ago I produced my own configuration auditing tool. The technical details are here:

http://genesysguru.com/blog/blog/2010/02/19/who-changed-that-cme-object/

Title: Re: Genesys Database Question?
Post by: GenUser on May 24, 2013, 11:32:39 AM
feel free to check out http://auditgen.com/en/auditgen-overview

It has some unique differentiating features, so feel free to contact us under support@auditgen.com if you're interested in getting more information.
Title: Re: Genesys Database Question?
Post by: Grand_Master on May 24, 2013, 02:10:08 PM
[quote author=fnunezsa link=topic=6534.msg28459#msg28459 date=1310685291]
This type of question has been asked a lot here in the forum...

I believe is a matter of time for Tony to reply pointing out Blackchair solution: Spotlight  ;D

Also you can just enable the Audit Trail functionality of Genesys Management Layer. In brief you'll need to:
1) Configure network logging in Configuration Server
2) Enable Message Server to write to a Log Database
3) Implement some sort of data purging procedure for Log Database as there is no OOB purge procedure for this DB. There is some directions to do so in the Management Layer User’s Guide.

Then you can use SCI to review confguration changes our you can implement any other sort of report sourced from Log DB.

I believe there are detailed instructions on how to setup Management Layer Audit Trail in Management Layer User’s Guide.
[/quote]

Yup.  This will enable the Audit tab in SCI or Monitoring/Audit in GenAdmin.

You can use the Log DB wizard for purging purposes, or simple DB maintenance tasks to do the same.
Title: Re: Genesys Database Question?
Post by: GenUser on May 26, 2013, 06:59:37 PM
That's correct, however enabling the Genesys log database is unfortunately not not good enough as it surely tells you when changes have been made but it doesn't tell you what the previous values were.
If you change for instance permissions of any object, you'll see in Genesys audit records that a permission change has been done but you won't know what the previous values were, besides tracking changes using G_LOG_MESSAGES table isn't really the most user friendly way.
Try changing Timezone (enable/disable DST parameters) and see if you can find previous values. Or try to change Switch access codes and see what you get in log database.