Guest User

hi. while using the Jennifer, i would like to ask a few questions.
i noticed quite a few of tables on the DB JENNIFER user. i was wondering if i could use the DB table to figure out the user IP and sql that such user initiated.
in addition, will it be possible to change the entire log (including user ip, initiated sql, initiated data) into a TEXT file? thanks for your support as always.

Khalid Saeed

The user IP and sql that such user initiated are not located at the table, but at the X-view.
the best way you can do is to search them on X-view and export them.
you can check the statistic of initiated sql from the statistic analysis application.

Guest User

what i would like to do is to make the data including user IP by date, initiated date, initiated SQL into single file so that i could open up the file without going through the JENNIFER. By doing to, i expect to store the file at another system (hard disk) and search related contents.
as a result, i hope to manage and monitor the records of accessed users.

Khalid Saeed

what you are asking is basically not possible. as for user IP, however, you could store a file or db through the XVlog Interface. please refer to our manual for more detail.