Vpn reports

[manonthemoon]

Hi, I need to be notified for example each 24h, by email, the journal report (logs) of persons who were logged on with VPN SSL (Date, Time, how long..,) Best regards

[haxor21]

This is exactly what i am looking for, too. Did you solve this?

I need the login+logout times of the users, the bandwidth/traffic is already on the presets.

I understand that by default there is no preset chart to do this however it should be possible to create a custom dataset

with the correct sql query to get the login/logout times of the users.

I think i am close to this but havent gotten it to work. It should be something like:

# show report dataset 

config report dataset

    edit "vpnein"

        set query "select user count(*) as totalnum from event_log where timestamp >= F_TIMESTAMP (\'now\', \'hour\', \'-23\') and group by user order by totalnum desc"

    next

end

# show report chart 

config report chart

    edit "vpnein2"

        set type table

        set comments "Testing"

        set dataset "vpnein"

        set category event

    next

end

and then adding this in the report as a new chart.

Any ideas?

[manonthemoon]

Thanks @haxor21 and norouzi for your reply

@norouzi

Yes, i'm using Fortianalyzer, if you can guide me how to setup my need, i'll appreciate. Best regards.

[norouzi]

manonthemoon, do you have FortiAnalyzer?

you can do it easily with FortiAnalyzer.

[norouzi]

What is your FortiAnalyzers version?

[manonthemoon]

Hi,

FortiAnalyzer 100B V4 MR3 Patch5

Regards