Network Management

last person joined: yesterday 

Keep an informative eye on your network with HPE Aruba Networking network management solutions
Back to discussions
Expand all | Collapse all

client clarity data Airwave database

This thread has been viewed 0 times

  • 1.  client clarity data Airwave database

    Posted Sep 21, 2017 11:35 AM

    Hi all,

     

    I want to analyze clarity data for all clients within Airwave in elastic.

     

    image.png

     

     

    I looked at the airwave database schema, and the table amc_client looks promising. However, this table is empty.

     

     

    amc_client (
    id bigint NOT NULL,
    mac character varying NOT NULL,
    domain character varying,
    ip character varying,
    username character varying,
    version character varying,
    computer character varying,
    latency_timestamp integer,
    latency double precision,
    auth_timestamp integer,
    auth_time double precision,
    dhcp_timestamp integer,
    dhcp_time double precision,
    bw_timestamp integer,
    bw_in double precision,
    bw_out double precision,
    gps character varying DEFAULT ''::character varying
);

    image.png

     

     

    Does anyone know which table this data resides in?

     

    Thanks in advance!



  • 2.  RE: client clarity data Airwave database

    Posted Sep 28, 2017 04:49 AM

    anyone?



  • 3.  RE: client clarity data Airwave database

    EMPLOYEE
    Posted Oct 11, 2017 02:24 PM

    I believe you're looking for the inline* db tables (* = wildcard).  The tables are sliced by timestamp - so there could be over 900 tables.