Log report filtering
Posted: Wed Jul 10, 2019 7:27 pm
In the Admin Web UI on OpenVPN AS 2.1.12, in Log Reports, you can filter the reports by (among other things) Username, Real IP Address, VPN IP Address, and Services. This is useful to me, because I have network monitoring software that connects to my OpenVPN server every couple minutes and fills the log with API requests, so by default I can't see, for example, who has connected recently. If I choose "VPN" in the "Services" filter field, then I can easily get that information.
In later versions of OpenVPN AS, such as 2.7.4, most of those filter fields are gone. There is a single "Filter records" box, but I can't find any way to get it to filter just by Service=VPN. The box searches all columns of the report. A search for "VPN" matches every row, since the server name, which in my case partially consists of the string "openvpn", appears in the first column of every row.
In 2.7.4 the 'logdba' command-line utility still has the --service_filt= option and that does work (e.g. "/usr/local/openvpn_as/scripts/logdba --csv --limit=20 --service_filt=VPN --desc" will give the last 20 VPN logins).
Is there a way to do that in the Web UI that I'm missing? If not, will it be added back in a later version of the software?
In later versions of OpenVPN AS, such as 2.7.4, most of those filter fields are gone. There is a single "Filter records" box, but I can't find any way to get it to filter just by Service=VPN. The box searches all columns of the report. A search for "VPN" matches every row, since the server name, which in my case partially consists of the string "openvpn", appears in the first column of every row.
In 2.7.4 the 'logdba' command-line utility still has the --service_filt= option and that does work (e.g. "/usr/local/openvpn_as/scripts/logdba --csv --limit=20 --service_filt=VPN --desc" will give the last 20 VPN logins).
Is there a way to do that in the Web UI that I'm missing? If not, will it be added back in a later version of the software?