This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Ermitteln / exportieren aller aktiven WLAN Clients

Hallo zusammen,

existiert die Möglichkeit eine Liste aller aktiven WLAN-Clients (auf UTM 9) zu exportieren?
Also im Prinzip die WLAN-Client-Liste (Wireless Protection --> WLAN-Clients) als csv herunterzuladen oder sogar über die APi oder per ssh abzurufen?

Die WLAN-Client-Liste ist als schnelle Übersicht zwar super, allerdings kann ich damit recht wenig mit Skripten etc. anfangen.



This thread was automatically locked due to age.
Parents
  • Hallo Heiko,

    Herzlich willkommen hier in der Community !

    (Sorry, my German-speaking brain isn't creating thoughts at the moment. Frowning2)

    Maybe someone knows how to get that info out of the PostgreSQL database.  In the wireless log, you can grep to get the MAC addresses of the devices connected in September with:

         zgrep 'name="STA connected"' /var/log/wireless/2021/09/*|grep -oP 'sta=".*?"'|sort -n|uniq -c

    MfG - Bob (Bitte auf Deutsch weiterhin.)

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Reply
  • Hallo Heiko,

    Herzlich willkommen hier in der Community !

    (Sorry, my German-speaking brain isn't creating thoughts at the moment. Frowning2)

    Maybe someone knows how to get that info out of the PostgreSQL database.  In the wireless log, you can grep to get the MAC addresses of the devices connected in September with:

         zgrep 'name="STA connected"' /var/log/wireless/2021/09/*|grep -oP 'sta=".*?"'|sort -n|uniq -c

    MfG - Bob (Bitte auf Deutsch weiterhin.)

     
    Sophos UTM Community Moderator
    Sophos Certified Architect - UTM
    Sophos Certified Engineer - XG
    Gold Solution Partner since 2005
    MediaSoft, Inc. USA
Children
No Data