Security

 View Only

  • 1.  CPPM SQL Query "Visitor Company"

    Posted Apr 11, 2022 09:53 AM
    Hello,
    I am building an sql query to interrogate the postgresql insight db for information relating to sponsored visitors connecting to WiFi.  The query output feeds into my customer's monitoring tool. 
    I was able to get information on the username, calling_station_id, ssid, start_time, end_time from radius_acct but am not able to fetch visitor company information.  I know it is there as i can see on ClearPass Insight.  Does anyone know where I may find this record using sql SELECT?

    ------------------------------
    Con Stathis
    ------------------------------


  • 2.  RE: CPPM SQL Query "Visitor Company"

    Posted Apr 20, 2022 08:20 AM
    Edited by James69 Apr 20, 2022 08:21 AM
    I am looking for the same issue, did you found any solution?

    ------------------------------
    James Gross
    ------------------------------

    Original Message


  • 3.  RE: CPPM SQL Query "Visitor Company"

    Posted Apr 25, 2022 10:52 AM
    Trial & error with pgadmin

    ------------------------------
    BERNHARD HUSTOMO
    ------------------------------

    Original Message


Related Content