Query pfSense user expiration date on command line?

[bubble1975]

Hey Y'all,

We are using the local pfSense user database to manage OpenVPN users. We have set expiration dates for each user, such that their account will auto-disable when the expiration date comes.

Is there any way, from a shell on the pfSense box, to query the expiration date of all the users at once? I'm looking to write a little script that queries the expiration dates of the users but I don't know what command would get me that data from a shell prompt...?

Thanks for any hints! We are running 2.4.3-RELEASE-p1.

cheers,
erich

[jimp]

There is no command that will query the local database users in that way, you'd have to write your own script.

You could use the changepassword script as a starting point. It is in /etc/phpshellsessions/ and you run it from ssh or console shell with pfSsh.php playback changepassword for example.