SQL request to get the log of a user by his user name

[bekjos01]

Hi everyone,

I want to get all the connexion log of one user by his user name. To do that , I make a sql request like this " Select * from $log  where ..." I don't know exactly what to put in the where clause to filter by user name . Can you help me please.

Regards.

[hzhao_FTNT]

Although "select *" is working under dataset test console, it doesn't work on report. Please go to log view first and find out which field you need.

Regards,

hz