Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Query influxDB - Suricata Top Port

    Scheduled Pinned Locked Moved Italiano
    1 Posts 1 Posters 494 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • federicopF
      federicop
      last edited by

      Ciao,
      sto cercando di creare una query per avere restituite le principali dest_port che risultano dai logstahs.

      ovviamente risco a trovare la tabella e ad estrapolare i dati, con la seguente query SELECT "dest_port" FROM "logstash" WHERE ("action" <> 'block' AND "action" <> 'pass') AND $timeFilter, ma avendo la prima colonna "TIME" non posso raggrupparle.

      Devo ottenere solo il conteggio delle "dest_port" ma non mi prende il group by "dest_port".

      sapete come posso risolvere?

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.