Custom Reports CPD

[Tala]

Hi Everyone,
I am in the middle of writting a custom report which will output to my SQL server. It is triggered when someone uses the CPD Login to authenticate.

It appears that the UVM database clears itself down on a regular basis, noteble the table events BLOCK table?

Am I missing something silly as I should be able to see 100's of records?

Here is my test output

BLOCKED <<< NO DATA
entry id time proto intf client ip client port destination IP destination Port


HOSTS LOGGED IN
entry id Client IP username Last_Session This Session Start Session Expire
407370 192.168.1.25 admin 2012-01-25 09:07:59.133344 2012-01-25 08:43:45.707222 2012-01-25 13:43:45.707222
351275 192.168.1.8 admin 2012-01-25 09:09:09.140045 2012-01-25 05:38:05.25725 2012-01-25 10:38:05.25725


LOGIN EVENTS
entry id login name event auth_type Time client address

[Tala]

Update:

Found in Reports Schema