topic VPN users report in Endpoint

VPN users report

Rick_Rodrix — Mon, 15 Apr 2019 13:27:57 GMT

Hello buddies!

I´ve been looking for a way to report all VPN users by creation date.

On the users properties, I´ve found a field called "User account created on:". Using Database Tool (Dbedit), I dicovered the DB field name "creation_date".

However when I use "fwm dbexport" to extract all VPN users on database, this "creation_date" doesn´t come in the report.

Is there a way to extract this information? Better, is there a way to create a montlhy report using that DB field.

Thanks in advance.

Re: VPN users report

PhoneBoy — Mon, 15 Apr 2019 14:21:13 GMT

What version of Security Management?
That said, I believe even in R80.x, dbedit may be the only way to get the information you're asking for.
You can get a dump of the data in XML format by using the command "printxml users" in dbedit.
From the output of that, you can create a report with the relevant data.

Re: VPN users report

Rick_Rodrix — Mon, 15 Apr 2019 15:56:31 GMT

I´m using R77.30.

Yes, I´ve tried that before, but I´m not familiar with dbedit, so I don´t know how to export that or even import in a pratical way to handle that list.

Any idea?

Re: VPN users report

PhoneBoy — Mon, 15 Apr 2019 17:11:10 GMT

As I said, it's a command you can feed dbedit. You can put the command in a text file, with something like:

[Expert@mgmt:0]# echo printxml users > dbedit.txt

Then you can easily call it with a cronjob or whatever:

[Expert@mgmt:0]# dbedit -local -f dbedit.txt

Parsing said XML output and turning it into the format you want is another matter, but that's how you get the data out.

Re: VPN users report

Rick_Rodrix — Mon, 15 Apr 2019 18:44:03 GMT

Thanks a lot!👍

Re: VPN users report

fabiooliveira7 — Wed, 26 Jan 2022 13:38:43 GMT

Dear Sirs,

I wonder if anyone knows how to customize a report of users using Client VPN mobile?

For example:
Name
user
date
login start
login end
login time