Contributor II

ClearPass retrieve custom attributes via SQL


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


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

Search Airheads
Showing results for 
Search instead for 
Did you mean: