VPN users report

[Rick_Rodrix]

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. 

[PhoneBoy]

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.

[Rick_Rodrix]

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?

[PhoneBoy · Accepted solution]

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.

[Rick_Rodrix]

Thanks a lot!👍