Genesys Database Question?

[vjicecool]

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)

[cavagnaro]

Check SCI for logs. Enable them on ConfigServer and be sure to configure it to store them on DB. Read the Framework documentation

[borkokrz]

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

[fnunezsa]

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 

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.

[genesysguru]

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/

[GenUser]

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.

[Grand_Master]

[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 

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.

[GenUser]

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.