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: documentation for using SQL server?

This thread has been viewed 0 times

  • 1.  Clearpass: documentation for using SQL server?

    Posted Aug 14, 2018 03:22 PM

    Are there any documentation available for using SQL server with Clearpass? User guide shows where to put the database name and credentials, but how about what does the Clearpass query from the server? And how it expect the data to be formatted, and in which fields?

     

    For example it seems that the user password must be returned as "user_password" but where is this documented?



  • 2.  RE: Clearpass: documentation for using SQL server?

    EMPLOYEE
    Posted Aug 22, 2018 11:16 PM

    ClearPass will use SQL to extract data from the SQL server.

     

    An example:

    SELECT mac from MACADDRESSES

     

    mac being the column and MACADDRESSES being the table.

     

    You will need to construct your select statement to get the data that you are after.