# OpenVPN - Showing connected users IP Address

**URL:** <https://community.grafana.com/t/openvpn-showing-connected-users-ip-address/5098>\
**Category:** General\
**Created:** [January 30, 2018, 1:02pm UTC](https://community.grafana.com/t/openvpn-showing-connected-users-ip-address/5098 "2018-01-30T13:02:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![telesguilherme](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/telesguilherme/32/2773_2.png) [@telesguilherme](https://community.grafana.com/u/telesguilherme)\
**Post date:** [January 30, 2018, 1:02pm UTC](https://community.grafana.com/t/openvpn-showing-connected-users-ip-address/5098/1 "2018-01-30T13:02:13Z")

</div>

Hello Community,

I´ve integrated my Grafana with Zabbix. And Zabbix with OpenVPN. So right now i can view the network traffic, and how many users are connected.

But now, i want to gow beyond. My company has a request to show on Grafana the IP Address that is currently connected. I know how to do the command line in Linux, like for i.e.:

UserParameter=num\_user.openvpn, cat /var/log/openvpn-server.status | sed -n ‘/Connected Since/,/ROUTING/p’ | grep -o ‘[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}.[0-9]{1,3}’

But the listed IP´s from the command above i cannot show them in grafana. Is there any way to do this ?

---

<div class="post-metadata">

**Author:** ![samaust](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/samaust/32/2792_2.png) [@samaust](https://community.grafana.com/u/samaust)\
**Post date:** [February 1, 2018, 1:34am UTC](https://community.grafana.com/t/openvpn-showing-connected-users-ip-address/5098/2 "2018-02-01T01:34:06Z")

</div>

If you’ve got a reverse proxy in front of Grafana, you could collect the access logs of the reverse proxy and do a query to SELECT the DISTINCT ip addresses that accessed urls of the Grafana server.

Another idea would be to make or configure an existing collect plugin to execute the command you wrote or it’S equivalent in another language and store the result in the database you use.