You can focus the search of a system view by specifying critical parameters in the SQL statement, for example:
SELECT a.UserName, a.LogDate, a.LogTime, StatementText, LogonSource FROM DBC.AccessLogV AS a, DBC.LogOnOffX AS b WHERE a.UserName = 'DBADMIN' AND a.SessionNo = b.SessionNo ORDER BY 2, 3 ;
This query displays the SQL statements, along with the logon IP address and date/time information, for a particular username and session number.