Security

last person joined: yesterday 

Forum to discuss Enterprise security using HPE Aruba Networking NAC solutions (ClearPass), Introspect, VIA, 360 Security Exchange, Extensions, and Policy Enforcement Firewall (PEF).
Back to discussions
Expand all | Collapse all

Clearpass SQL API

This thread has been viewed 1 times

  • 1.  Clearpass SQL API

    Posted Feb 03, 2014 04:48 AM

    I want to use Guestaccount information from SQL API because the reports from Insight are only send by email as pdf.

    We want to do the billing automatically for our guestaccounts. We want to creat a process which directly connects to the sql api.

    I got access to the sql api via pgAdmin. But I don't find the table which contains the data i need.

    Where do i find the guest account data like

    username, sponsorname start date and expiry date?

     

    Is there any documentation about the sql api?

     

    Thanks a lot.



  • 2.  RE: Clearpass SQL API

    EMPLOYEE


  • 3.  RE: Clearpass SQL API

    Posted Apr 29, 2014 07:36 AM

    how did you connect to the SQL service with pgAdmin?



  • 4.  RE: Clearpass SQL API

    EMPLOYEE
    Posted Apr 29, 2014 08:06 AM

    Set the appexternal password under cluster settings and use those credentials to connect.

     

     auth1-postgres.png