Security

 View Only
Back to discussions
Expand all | Collapse all

ClearPass retrieve custom attributes via SQL

This thread has been viewed 10 times

  • 1.  ClearPass retrieve custom attributes via SQL

    Posted Mar 16, 2018 01:24 PM

    Hi,

    I am trying to use the external PostGreSQL to retrieve custom endpoints attributes. Similar to the problem described here:

     

    http://community.arubanetworks.com/t5/Security/SQL-Query-of-Airwatch-Endpoint-attributes/td-p/228103

     

    I found the attributes in question in the tips_tag_defintiion view, but I cannot seem to get the SQL statement to work to retrieve the actual values from the tips_endpoints_attr_view view.

     

    I always get the error message that the relation does not exist.

    My SQL Query is this:


    SELECT tag_value as wksnadport FROM tips_endpoints_attr_view
    WHERE tag_name = 'wksnadport' AND mac_address = LOWER('001871490470')

     

    Could you help?

     

    kind regards,
    Jens Pfennig



Related Content